Question

看下try里面的语句有问题吗？怎么直接执行catch？谢谢

public void actionPerformed(ActionEvent e) {
String id="";
String password;
String password_again;
try { String uri="jdbc:derby:Information;create=true";
con=DriverManager.getConnection(uri);
SQL="INSERT INTO yonghu VALUES(?,?,?,?,?,?)";
sql=con.prepareStatement(SQL);
id=view.inputID.getText().trim();
char [] a=view.inputPassword.getPassword();
password = new String(a);
a =view.inputPassword_again.getPassword();
password_again = new String(a);
if(!(password.equals(password_again))) {
JOptionPane.showMessageDialog
(null,"密码不一致","消息对话框",JOptionPane.WARNING_MESSAGE);
return;

}
sql.setString(1,id);
sql.setString(2,view.inputName.getText().trim());
sql.setString(3,password.trim());

sql.setString(4,view.inputBirth.getText().trim());
sql.setString(5,view.inputMajor.getText().trim());
sql.setString(6,view.inputBanji.getText().trim());
m=sql.executeUpdate();
con.close();
}
catch(SQLException exp) {
JOptionPane.showMessageDialog
(null,"请换id","消息对话框", JOptionPane.WARNING_MESSAGE);
}

Answer 1

我看你语句catch是捕获到SQLException 才会执行

追问

谢谢你的热心回答，这个问题我稀里糊涂解决了，出现另一个问题，怎样从数据库里获得某字段的值呢？

追答

jdbc 连接数据库