51,411
社区成员
发帖
与我相关
我的任务
分享




//点击确定按钮
if(e.getSource() == button7){
if(flagAge && flagClass && flagID && flagName && flagSex){
sta.executeUpdate(into);
JOptionPane.showMessageDialog(null, "添加成功!");
//清空 输入框
stuName.setText("");
stuAge.setText("");
stuClass.setText("");
stuID.setText("");
stuSex.setText("");
//文本域显示命令
tamlh.setText(""); //清空
tamlh.append(beginTime + "执行成功: " + into + "\n");
//向集合框里添加列表项
stuList.add(IDText + "," + nameText);
} else {
sta.executeUpdate(update); //删除空值
JOptionPane.showMessageDialog(null, "你的输入不合法!");
tamlh.setText(""); //清空
tamlh.append(beginTime + ": 请输入完整的学生信息!\n");
}
}
String nameList = null;
String stuClassList = null;
String IDList = null;
String sexList = null;
String ageList = null;
//构造函数 传递List List内查询的值 赋给 输入框
public void stuText(String nameList, String stuClassList, String IDList, String sexList, String ageList) {
newf Listrun = new newf();
this.nameList = nameList;
this.stuClassList = stuClassList;
this.IDList = IDList;
this.sexList = sexList;
this.ageList = ageList;
Thread th = new Thread(Listrun);
th.start();
System.out.println("运行了" + nameList + stuClassList + IDList + sexList + ageList);
}
@Override
public void run() {
stuName.setText(nameList);
stuAge.setText(stuClassList);
stuClass.setText(IDList);
stuID.setText(sexList);
stuSex.setText(ageList);
System.out.println("运行了111111" + nameList + stuClassList + IDList + sexList + ageList);
}
package DaZuoYe;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.*;
import java.util.Arrays;
class ListListener implements ActionListener,ItemListener{
String nameList = null;
String stuClassList = null;
String IDList = null;
String sexList = null;
String ageList = null;
@Override
public void itemStateChanged(ItemEvent e) {
// TODO Auto-generated method stub
//System.out.println(e.getSource());
}
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
//System.out.println(e.getActionCommand());
String str = e.getActionCommand();
String[] arr = str.split(","); // 用,分割
System.out.println(Arrays.toString(arr));
try {
Class.forName("com.mysql.cj.jdbc.Driver"); //加载驱动程序
Connection conn = DriverManager.getConnection( //链接数据库
"jdbc:mysql://112.125.95.197:3306/java",
"java", "Aa316216");//建立数据库连接
Statement sta = conn.createStatement(); //用sta执行SQL语句
String select = "select * from stu where name = '"+ arr[1] +
"' and ID = '"+ arr[0] +"';";
System.out.println(arr[0] + arr[1]);
ResultSet rs = sta.executeQuery(select);
while (rs.next()){
nameList = rs.getString(1);
stuClassList = rs.getString(2);
IDList = rs.getString(3);
sexList = rs.getString(4);
ageList = rs.getString(5);
}
System.out.println(nameList + stuClassList + IDList + sexList + ageList);
new newf().stuText(nameList,stuClassList,IDList,sexList,ageList);
} catch (ClassNotFoundException classNotFoundException) {
classNotFoundException.printStackTrace();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
,