Question

求java和sql高手啊、、、本人菜鸟苦闷中！

else if(e.getSource()==re_collage) {
String str4 = JOptionPane.showInputDialog(this,"输入新信息","输入对话框",
JOptionPane.PLAIN_MESSAGE);

try{
stmt = conn.createStatement();
String sql1 = "select * from collage where D_NAME = '"+ str4 + "'";
rs = stmt.executeQuery(sql1);
if (rs.next())
stmt1 = conn.createStatement();
String sql = "update student set D_ID = '"+rs.getString("D_ID")+"' where student.S_ID = '"
+ jtf_num1.getText().trim() + "'";
stmt1.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "修改成功！");
} catch (SQLException e2) {
e2.printStackTrace();
}
}
1

Answer 1

想回答你的问题，但你说的确实不清楚，建议把问题补充改一改。

Answer 2

你想问什么？

Answer 3

能否说怎么了

Answer 4

看不清，说下问题