.getString(6);
datas[j][7] = rs.getString(7);
j++;
}
} catch (SQLException e1) {
e1.printStackTrace();
}
JTable table = new JTable(datas, title);
jScrollPane1.setViewportView(table);
jScrollPane1.revalidate();
}
4.3.3 添加联系人信息功能:
4.3.3.1 添加:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String[] option = { "添加", "修改" };
int n = JOptionPane.showOptionDialog(this, "请仔细检查信息,确定添加?", "添加信息",
JOptionPane.YES_NO_OPTION, JOptionPane.WARNING_MESSAGE, null,
option, option[1]);
if (n == 0) {
//获取添加的内容
String acctnum = jTextField1.getText();
String name = jTextField2.getText();
String sex = jTextField3.getText();
String mobile = jTextField4.getText();
String academy = jTextField5.getText();
String major = jTextField6.getText();
String adress = jTextField7.getText();
String classes = jTextField8.getText();
//插入内容
String sql = "INSERT INTO STUINFO VALUES('" + acctnum + "', '"
+ name + "', '" + sex + "', '" + mobile + "', '" + academy
+ "', '" + major + "', '" + adress + "', '" + classes
+ "')";
choose.dataInsert(sql);
JOptionPane.showMessageDialog(this, "添加成功!", "提示",
JOptionPane.INFORMATION_MESSAGE);
jButton2ActionPerformed(evt);
}
}
4.3.3.2 重置:
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
}
4.3.4 删除联系人信息功能:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String str = (String) jComboBox1_view.getSelectedItem();
String str2 = jTextField1.getText();
String sql = null;
if (str.equals("编号")) {
sql = "SELECT * FROM stuinfo where 编号='" + str2 + "'";
} else
sql = "SELECT * FROM stuinfo where ='" + str2 + "'";
ResultSet rs = choose.dataSelect(sql);
try {
while (rs.next()) {
jTextField2_acctnum.setText(rs.getString(1));
jTextField9_name.setText(rs.getString(2));
jTextField3_sex.setText(rs.getString(3));
jTextField4_mobile.setText(rs.getString(4));
jTextField5_academy.setText(rs.getString(5));
jTextField6_major.setText(rs.getString(6));
jTextField7_address.setText(rs.getString(7));
jTextField8_class.
上一篇:
java课程设计论文(课程管理系统)
下一篇:
电信运营支持系统的设计与开发毕业论文