-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathMyFrame.java
More file actions
152 lines (122 loc) · 4.41 KB
/
Copy pathMyFrame.java
File metadata and controls
152 lines (122 loc) · 4.41 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
package Win_SQL;
import java.awt.GridBagLayout;
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.SQLException;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
public class MyFrame extends JFrame {
private JTextField id_t;
private JTextField name_t;
private JTextField attack_t;
private JTextField defend_t;
private JComboBox sex_t;
private JTextField nationality_t;
public MyFrame(){
setSize(200,300);
setLayout(new GridBagLayout());
//创建及添加标签及文本框
JLabel id=new JLabel("id:");
id_t =new JTextField(6);
JLabel name=new JLabel("name:");
name_t =new JTextField(6);
JLabel attack=new JLabel("attack:");
attack_t =new JTextField(6);
JLabel defend=new JLabel("defend:");
defend_t =new JTextField(6);
JLabel sex=new JLabel("sex:");
sex_t =new JComboBox();
sex_t.insertItemAt('男',0);
sex_t.insertItemAt('女',0);
JLabel nationality=new JLabel("nation:");
nationality_t =new JTextField(6);
// add(id,new GBC(0,0).setAnchor(GBC.WEST));
add(id_t,new GBC(1,0).setWeigth(100,100).setFill(GBC.CENTER));
add(name,new GBC(0,1).setAnchor(GBC.WEST));
add(name_t,new GBC(1,1).setWeigth(100,100).setFill(GBC.CENTER));
add(attack,new GBC(0,2).setAnchor(GBC.WEST));
add(attack_t,new GBC(1,2).setWeigth(100,100).setFill(GBC.CENTER));
add(defend,new GBC(0,3).setAnchor(GBC.WEST));
add(defend_t,new GBC(1,3).setWeigth(100,100).setFill(GBC.CENTER));
add(sex,new GBC(0,4).setAnchor(GBC.WEST));
add(sex_t,new GBC(1,4).setWeigth(100,100).setFill(GBC.CENTER));
add(nationality,new GBC(0,5).setAnchor(GBC.WEST));
add(nationality_t,new GBC(1,5).setWeigth(100,100).setFill(GBC.CENTER));
JButton bt=new JButton("确定");//创建确定按钮
//添加确定按钮的监听器
bt.addActionListener(new ActionListener(){
@Override
public void actionPerformed(ActionEvent e) {
Connection con=null;
boolean error=false;
try {
PreparedStatement pst;
con=getConnection();
//预处理语句
pst=con.prepareStatement("insert into sanguo(name,gongji,fangyu,sex,country) values(?,?,?,?,?)");
pst.setString(1,name_t.getText());
pst.setInt(2,Integer.parseInt(attack_t.getText()));
pst.setInt(3,Integer.parseInt(defend_t.getText()));
pst.setString(4,sex_t.getItemAt(sex_t.getSelectedIndex()).toString());
pst.setString(5,nationality_t.getText());
pst.execute();
} catch (SQLException e1) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(MyFrame.this,"SQL错误！","SQLError",2);
error=true;
}
catch (NumberFormatException e1){
JOptionPane.showMessageDialog(MyFrame.this,"输入不合法","InputError",2);
error=true;
}
finally{
//关闭连接
try {
con.close();
} catch (Exception e1) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(MyFrame.this,"文件未正确关闭","FileCloseError",2);
}
if (error==false)
JOptionPane.showMessageDialog(MyFrame.this,"插入成功","success",2);
}
error=false;
}
});
add(bt,new GBC(0,6).setAnchor(GBC.EAST).setFill(GBC.CENTER));//添加确定按钮
JButton bts=new JButton("清除");//创建按钮
//添加按钮的监听器，将文本框内的内容清除
bts.addActionListener(new ActionListener(){
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
id_t.setText("");
name_t.setText("");;
attack_t.setText("");;
defend_t.setText("");;
MyFrame.this.setVisible(false);
nationality_t.setText("");;
}
});
add(bts,new GBC(1,6).setAnchor(GBC.EAST).setFill(GBC.CENTER));//添加清除按钮
}
//获取数据库连接的函数
public static Connection getConnection()throws SQLException{
Connection con=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/moshou","root","123456");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(null,"无法找到类！","SQLError",2);
}
return con;
}
}