sql语句转为java的StringBuilder

package liu.qun.util; import java.awt.Color; import java.awt.TextArea; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.FileReader; import java.io.InputStreamReader; import java.io.UnsupportedEncodingException; import java.util.Scanner; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JPanel; public class SqlToBuilder { public static void main(String[] args) throws Exception { new MyFrame("MyFrameWithPanel",200,200,1000,800); } } class MyFrame extends JFrame{ private JPanel p1,p2,p3; TextArea sqlArea,javaArea; JButton sureBtn; MyFrame(String s,int x,int y,int w,int h){ super(s); setLayout(null); p1=new JPanel(null); p2=new JPanel(null); p3=new JPanel(null); sqlArea = new TextArea(); javaArea = new TextArea(); sureBtn = new JButton("确认"); p1.setBounds(0,0,w/2,4*h/5); p2.setBounds(w/2,0,w/2,4*h/5); p3.setBounds(0,4*h/5,w,h/5); sqlArea.setBounds(0, 0, w/2, 4*h/5); javaArea.setBounds(0, 0, w/2,4*h/5); sureBtn.setBounds(0, 0, w, h/5); p1.setBackground(Color.gray); p2.setBackground(Color.green); p3.setBackground(Color.yellow); p3.add(sureBtn); p1.add(sqlArea); p2.add(javaArea); add(p1); add(p2); add(p3); setBounds(x,y,w,h); setVisible(true); sureBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub String sql = sqlArea.getText(); int first = 0; int end = 0; StringBuilder result = new StringBuilder(); result.append("StringBuilder sqlBuilder = new StringBuilder();\n"); for (int i = 0; i < sql.length(); i++) { if (sql.charAt(i) == '\n') { end = i-1; String line = sql.substring(first, end); String str = "sqlBuilder.append(\""+String.format("%-40s", line)+"\");\n"; result.append(str); first = i+1; if (i == sql.lastIndexOf('\n')) { end = sql.length(); String lastLine = sql.substring(first, end); String lastStr = "sqlBuilder.append(\""+String.format("%-40s", lastLine)+"\");\n"; result.append(lastStr); break; } } } javaArea.setText(result.toString()); } }); } } /*File file = new File("C://Users/群/Desktop/sql.txt"); FileInputStream inputStream = new FileInputStream(file); //FileInputStream fin1 = new FileInputStream(srcFile); InputStreamReader ins1 = new InputStreamReader(inputStream,"utf-8"); // 转换编码结束 FileReader ins = new FileReader(file); BufferedReader readBuf = new BufferedReader(ins); StringBuffer sb = new StringBuffer(); String s = null; StringBuilder result = new StringBuilder(); result.append("StringBuilder sqlBuilder = new StringBuilder();\n"); while((s=readBuf.readLine())!=null){ sb.append(s); String str = "sqlBuilder.append(\""+String.format("%-40s", s)+"\");\n"; result.append(str); } readBuf.close(); inputStream.close();*/