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“2002001000800）;?
		
	}
}

class?Myframe?extends?Jframe{??
????private?JPanel?p1p2p3;??
????TextArea?sqlAreajavaArea;
????JButton?sureBtn;
????Myframe（String?sint?xint?yint?wint?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（00w/24*h/5）;??
????????p2.setBounds（w/20w/24*h/5）;??
????????p3.setBounds（04*h/5wh/5）;??
????????sqlArea.setBounds（0?0?w/2?4*h/5）;
????????javaArea.setBounds（0?0?w/24*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（xywh）;??
????????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?					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?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????3415??2017-03-13?18:37??SqlToJavaBuilder\SqlToBuilder.java
?????文件????????3364??2017-03-13?18:37??SqlToJavaBuilder\sqlToJavaBuilder.jar
?????目錄???????????0??2017-03-13?18:44??SqlToJavaBuilder\