动态拼成SQL代码,Java代码库,德仔网

代码语言
代码分类
【Java】动态拼成SQL
作者:颜风 / 发布于2015/8/10/ 730

	package com.chenjun.utils;
	import java.awt.Button;
	import java.awt.Dimension;
	import java.awt.Font;
	import java.awt.GridLayout;
	import java.awt.TextArea;
	import java.awt.TextField;
	import java.awt.event.ActionEvent;
	import java.awt.event.ActionListener;
	import java.util.ArrayList;
	import java.util.List;
	
	import javax.swing.JFrame;
	import javax.swing.JPanel;
	
	import org.apache.commons.lang3.StringUtils;
	class ImeBox extends JFrame{
	 private JPanel jPanel1;
	 private JPanel jPanel2;
	 private TextArea textArea1;
	 private TextArea textArea2;
	 private TextField textField1;
	 private TextField textField2;
	
	 private Button btn1;
	
	 public void initImeBox(){
	 super.setTitle("串码调整工具");
	 super.setBounds(200, 200,1000, 600);
	 super.setVisible(true);
	 jPanel1 = new JPanel(new GridLayout(3,1));//3行一列
	 jPanel2 = new JPanel(new GridLayout(1,3));//1行3列
	
	 textArea1 = new TextArea(MAXIMIZED_HORIZ, MAXIMIZED_VERT);
	 btn1 = new Button("<-Prefix Generation the SQL ->Suffix");
	 btn1.setFont(new Font("微软雅黑", Font.BOLD, 14));
	 textArea2 = new TextArea(MAXIMIZED_HORIZ, MAXIMIZED_VERT);
	 textField1 = new TextField();
	 textField2 = new TextField();
	 //添加组件
	
	 jPanel1.add(textArea1);
	
	 jPanel2.add(textField1);
	 jPanel2.add(btn1);
	 jPanel2.add(textField2);
	 jPanel2.setPreferredSize(new Dimension(this.getWidth(), 30));
	 jPanel1.add(jPanel2);
	 jPanel1.add(textArea2);
	 super.add(jPanel1);
	
	 btn1.addActionListener(new ActionListener() {
	 @Override
	 public void actionPerformed(ActionEvent e) {
	 List <String> sqlList = generationSQL(textArea1.getText());
	 StringBuffer sb = new StringBuffer();
	 for(String s: sqlList){
	 sb.append(s).append("\n");
	 System.out.println(s);
	 }
	 textArea2.setText(sb.toString());
	 }
	 });
	 }
	 public List<String> generationSQL(String imeStr){
	 StringBuffer prefix = new StringBuffer(textField1.getText());
	 StringBuffer suffix = new StringBuffer(textField2.getText());
	 System.out.println("Prefix = "+prefix);
	 System.out.println("Suffix = "+suffix);
	 String [] tempStrs = StringUtils.split(imeStr,"\r\n");
	 List<String> imeList = new ArrayList<String>(0);
	 for(String s : tempStrs){
	 StringBuffer temp = new StringBuffer(s);
	 StringBuffer tmpPrefix = new StringBuffer(prefix);
	 temp = tmpPrefix.append(temp).append(suffix); //前缀+IME+后缀
	 imeList.add(temp.toString());
	 }
	 return imeList;
	 }
	}
	
	public class ImeUtil {
	 public static void main(String[] args) {
	 // TODO Auto-generated method stub
	 ImeBox imeBox = new ImeBox();
	 imeBox.initImeBox();
	 }
	
	}
试试其它关键字
　动态SQL　
同语言下
可能有用的
颜风贡献的其它代码(4)