这不就是个SQL语句的问题么?String sql = "Select * From 学生表 Where 姓名 = ?"; 然后用PreparedStatement来设置参数就好了。
建议楼主找相关T-SQL语法的书籍,先学习语法吧。毕竟数据库的好多操作还是由T-SQL语句完成的!
示例: select ID,name,sex,age,address,phone,user,password,roleid from employee where ID like '%" + tfid.getText() + "%' and name like '%" + tfname.getText() + "%'"
然后用PreparedStatement来设置参数就好了。
select ID,name,sex,age,address,phone,user,password,roleid from employee where ID like '%" +
tfid.getText() +
"%' and name like '%" + tfname.getText() + "%'"
@Override
public void actionPerformed(ActionEvent e) {
try {
if(validate(userField.getText() , passField.getText())){
展示学生信息窗口//从等录窗口获取信息并通过validate方法来判断数据库中是否有此人
}
else {
不存在
}
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}// TODO Auto-generated method stub
}
}); public boolean validate(String userPass, String userName) throws Exception {
try (Connection conn = DriverManager.getConnection(url, user, pass);
PreparedStatement ps = conn
.prepareStatement("select *from jdbc_test where jdbc_name=? and jdbc_id=?")) {
ps.setString(1, userPass);
ps.setString(2, userName);
try (ResultSet rs = ps.executeQuery();){
if(rs.next()){
return true;
}
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
}