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();*/
