package com.bestpay.bpbp.bill;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
@SuppressWarnings("serial")
public class CreateSqlWin extends JFrame {
private JPanel contentPane;
private JTextField txtStr;
private JRadioButton rdbtnString;
private JRadioButton rdbtnStringbuffer;
private JSplitPane splitPane;
private JTextArea newSql;
private JTextArea oldSql;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
CreateSqlWin frame = new CreateSqlWin();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the frame.
*/
public CreateSqlWin() {
setMinimumSize(new Dimension(840, 600));
setTitle("SQL JAVA ");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 842, 605);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(new BorderLayout(0, 0));
JPanel panel = new JPanel();
panel.setPreferredSize(new Dimension(10, 80));
contentPane.add(panel, BorderLayout.NORTH);
panel.setLayout(new BorderLayout(0, 0));
JPanel panel_1 = new JPanel();
panel_1.setBorder(new LineBorder(new Color(0, 0, 0)));
panel_1.setPreferredSize(new Dimension(300, 10));
panel.add(panel_1, BorderLayout.CENTER);
panel_1.setLayout(null);
JLabel label = new JLabel(" ：");
label.setBounds(10, 10, 153, 20);
panel_1.add(label);
rdbtnString = new JRadioButton("String");
rdbtnString.setSelected(true);
rdbtnString.setBounds(52, 36, 79, 23);
panel_1.add(rdbtnString);
rdbtnStringbuffer = new JRadioButton("StringBuffer");
rdbtnStringbuffer.setBounds(144, 36, 107, 23);
panel_1.add(rdbtnStringbuffer);
ButtonGroup bGroup = new ButtonGroup();
bGroup.add(rdbtnString);
bGroup.add(rdbtnStringbuffer);
txtStr = new JTextField();
txtStr.setText("str");
txtStr.setBounds(313, 31, 180, 33);
panel_1.add(txtStr);
txtStr.setColumns(10);
JLabel label_1 = new JLabel(" ：");
label_1.setBounds(276, 13, 87, 15);
panel_1.add(label_1);
JPanel panel_3 = new JPanel();
panel_3.setBorder(new MatteBorder(1, 0, 1, 1, (Color) new Color(0, 0, 0)));
panel_3.setPreferredSize(new Dimension(200, 10));
panel.add(panel_3, BorderLayout.EAST);
panel_3.setLayout(new BorderLayout(0, 0));
JButton button = new JButton(" ");
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
// SQL
String oldSqlStr = oldSql.getText();
if(oldSqlStr.equals("")){
JOptionPane.showMessageDialog(CreateSqlWin.this, " SQL ！");
return;
}
//
if(!newSql.getText().equals("")){
newSql.setText("");
}
String valibleName = txtStr.getText();
if(valibleName.trim().equals("")){
JOptionPane.showMessageDialog(CreateSqlWin.this, " ！");
return;
}
String[] sqls = oldSqlStr.split("
");
StringBuffer result = new StringBuffer();
// SQL
if(rdbtnString.isSelected()){
//string
for(int i=0;i