package com.cn;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.ScrollPane;
import java.awt.TextArea;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
public class JTextFieldDemo extends JFrame {
private JTextField textField_1;
private JTextField textField;
private JTextArea textArea;
private JTextArea textArea1;
private JButton buttonadd;
private JButton buttondel;
private JButton buttonsel;
public Connection conn=null;
public JTextFieldDemo(){
super();
final FlowLayout flowLayout_4=new FlowLayout();
flowLayout_4.setAlignment(FlowLayout.LEFT);
getContentPane().setLayout(flowLayout_4);
setTitle("文本框演示程序");
setBounds(100,100,800,600);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//****************省略布局代码*******************************
Container panel=getContentPane();
Container panel_1=getContentPane();
Container panel_2=getContentPane();
Container panel_3=getContentPane();
Container panel_4=getContentPane();
Container panel_5=getContentPane();
panel.add(new JLabel("姓名: "));
textField=new JTextField(5);
panel.add(textField);
buttonsel=new JButton();
buttonsel.setText("查询");
panel.add(buttonsel);
panel_1.add(new JLabel("身份证号码: "));
textField_1=new JTextField(20);
panel_1.add(textField_1);
panel_3.add(new JLabel("票价: "));
textField_3=new JTextField(5);
panel_3.add(textField_3);
panel_3.add(new JLabel(" "));
panel_3.add(new JLabel("手续费:"));
textField_2=new JTextField(5);
panel_3.add(textField_2);
panel_2.add(new JLabel("乘车需求: "));
textArea=new JTextArea();
textArea.setLineWrap(true);
textArea.setSize(700, 1000);
panel_2.add(textArea);
panel_4.add(new JLabel("备注:"));
textField_4=new JTextField(12);
panel_4.add(textField_4);
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel("金 额:"));
textField_5=new JTextField(5);
panel_4.add(textField_5);
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel("提示信息:"));
textField_6=new JTextField(20);
panel_4.add(textField_6);
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
textArea1=new JTextArea();
textArea1.setLineWrap(true);
textArea1.setSize(770, 1000);
panel_5.add(textArea1);
buttonadd=new JButton();
buttondel=new JButton();
buttonadd.setText(" 添加");
buttondel.setText("取消");
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(buttonadd);
panel_5.add(new JLabel(" "));
panel_5.add(buttondel);
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
setVisible(true);
this.setResizable(false);
//*******数据库连接***************/
GetConn getConn=new GetConn();
Connection conn=getConn.getConnection();
String sql = "select * from ticket";
try{
Statement pstm=conn.createStatement();
ResultSet rs = pstm.executeQuery(sql);
String s2="";
while(rs.next()){
s2+=rs.getString(1);
s2+=rs.getString(2);
s2+=rs.getString(3);
s2+=rs.getString(4);
s2+=rs.getString(5);
s2+=rs.getString(6);
s2+=rs.getString(7);
s2+=rs.getString(8);
}
System.out.println(s2);
textArea1.setText(s2);
conn.close();
}
catch(Exception e2){
e2.printStackTrace();
}
//********Buttonok点击添加按钮触发事件*******************/
buttonadd.addActionListener(new ActionListener() {
/*点击确定按钮保存数据*/
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
String s1=textField_1.getText();
s1=s1.trim();
int n=s1.length();
if(n!=18){
textField_6.setText("身份证号码位数不正确");
}
else{
GetConn getConn=new GetConn();
Connection conn=getConn.getConnection();
try{
String sql = "select * from ticket";
Statement statement=conn.createStatement();
int count=statement.executeUpdate(sql);
count++;
Info info=new Info();
String scount=count+"";
info.setsId(scount);
info.setsName(textField.getText());
info.setsNameId(textField_1.getText());
info.setsPiao(textField_3.getText());
info.setsFee(textField_2.getText());
info.setsInfo(textArea.getText());
info.setsExtra(textField_4.getText());
info.setsBack(textField_5.getText());
infoInsert insert=new infoInsert();
insert.insert(info);
}
catch(Exception e2){
e2.printStackTrace();
}
}
}
});
}
}
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.ScrollPane;
import java.awt.TextArea;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
public class JTextFieldDemo extends JFrame {
private JTextField textField_6;、
private JTextField textField_5;
private JTextField textField_4;
private JTextField textField_3;
private JTextField textField_2;private JTextField textField_1;
private JTextField textField;
private JTextArea textArea;
private JTextArea textArea1;
private JButton buttonadd;
private JButton buttondel;
private JButton buttonsel;
public Connection conn=null;
public JTextFieldDemo(){
super();
final FlowLayout flowLayout_4=new FlowLayout();
flowLayout_4.setAlignment(FlowLayout.LEFT);
getContentPane().setLayout(flowLayout_4);
setTitle("文本框演示程序");
setBounds(100,100,800,600);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
//****************省略布局代码*******************************
Container panel=getContentPane();
Container panel_1=getContentPane();
Container panel_2=getContentPane();
Container panel_3=getContentPane();
Container panel_4=getContentPane();
Container panel_5=getContentPane();
panel.add(new JLabel("姓名: "));
textField=new JTextField(5);
panel.add(textField);
buttonsel=new JButton();
buttonsel.setText("查询");
panel.add(buttonsel);
panel_1.add(new JLabel("身份证号码: "));
textField_1=new JTextField(20);
panel_1.add(textField_1);
panel_3.add(new JLabel("票价: "));
textField_3=new JTextField(5);
panel_3.add(textField_3);
panel_3.add(new JLabel(" "));
panel_3.add(new JLabel("手续费:"));
textField_2=new JTextField(5);
panel_3.add(textField_2);
panel_2.add(new JLabel("乘车需求: "));
textArea=new JTextArea();
textArea.setLineWrap(true);
textArea.setSize(700, 1000);
panel_2.add(textArea);
panel_4.add(new JLabel("备注:"));
textField_4=new JTextField(12);
panel_4.add(textField_4);
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel("金 额:"));
textField_5=new JTextField(5);
panel_4.add(textField_5);
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel("提示信息:"));
textField_6=new JTextField(20);
panel_4.add(textField_6);
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
panel_4.add(new JLabel(" "));
textArea1=new JTextArea();
textArea1.setLineWrap(true);
textArea1.setSize(770, 1000);
panel_5.add(textArea1);
buttonadd=new JButton();
buttondel=new JButton();
buttonadd.setText(" 添加");
buttondel.setText("取消");
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(buttonadd);
panel_5.add(new JLabel(" "));
panel_5.add(buttondel);
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
panel_5.add(new JLabel(" "));
setVisible(true);
this.setResizable(false);
//*******数据库连接***************/
GetConn getConn=new GetConn();
Connection conn=getConn.getConnection();
String sql = "select * from ticket";
try{
Statement pstm=conn.createStatement();
ResultSet rs = pstm.executeQuery(sql);
String s2="";
while(rs.next()){
s2+=rs.getString(1);
s2+=rs.getString(2);
s2+=rs.getString(3);
s2+=rs.getString(4);
s2+=rs.getString(5);
s2+=rs.getString(6);
s2+=rs.getString(7);
s2+=rs.getString(8);
}
System.out.println(s2);
textArea1.setText(s2);
conn.close();
}
catch(Exception e2){
e2.printStackTrace();
}
//********Buttonok点击添加按钮触发事件*******************/
buttonadd.addActionListener(new ActionListener() {
/*点击确定按钮保存数据*/
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
String s1=textField_1.getText();
s1=s1.trim();
int n=s1.length();
if(n!=18){
textField_6.setText("身份证号码位数不正确");
}
else{
GetConn getConn=new GetConn();
Connection conn=getConn.getConnection();
try{
String sql = "select * from ticket";
Statement statement=conn.createStatement();
int count=statement.executeUpdate(sql);
count++;
Info info=new Info();
String scount=count+"";
info.setsId(scount);
info.setsName(textField.getText());
info.setsNameId(textField_1.getText());
info.setsPiao(textField_3.getText());
info.setsFee(textField_2.getText());
info.setsInfo(textArea.getText());
info.setsExtra(textField_4.getText());
info.setsBack(textField_5.getText());
infoInsert insert=new infoInsert();
insert.insert(info);
}
catch(Exception e2){
e2.printStackTrace();
}
}
}
});
}
}