大家好,我是王小白,我又来了,我又来为大家进行下一步的更新了,接这上文更新查和删的功能,如果大家已经实现了上两个功能,这两个应该非常简单了,上代码!!! gogogo!!!
public int delete(String num) throws Exception {
Connection conn = null;
PreparedStatement stmt = null;
conn = Util.getCon();
String sql = "delete from student where num=?";
PreparedStatement pstm = conn.prepareStatement(sql);
pstm.setString(1,num);
return pstm.executeUpdate();
}
public Student FindById(String num) throws Exception {
Connection con = null;
con = Util.getCon();
String sql = "select * from Student where num=?";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1, num);
ResultSet rs = pst.executeQuery();
if (rs.next()) {
Student stu = new Student();
stu.setNum(rs.getString("num"));
stu.setName(rs.getString("name"));
stu.setSex(rs.getString("sex"));
stu.setAge(rs.getInt("age"));
stu.setMobile(rs.getString("mobile"));
stu.setCourse(rs.getString("course"));
stu.setGrade(rs.getString("grade"));
return stu;
}
return null;
}
这两个是学生信息的全部功能了,顺便给大家送上登陆信息的功能吧,然后下个博客就要进行给大家讲解view层的书写了,
先把用户登陆的信息给大家发上吧!!
Connection con=null;
Statement statement=null;
ResultSet res =null;
public void insert(String username, String password) {
if (username == null || username.trim().length() <= 0) {
JOptionPane.showMessageDialog(null, "");
return;
}
String sql = "insert into enter(username,password) values(\"" + username + "\",\"" + password + "\")";
try {
int a = statement.executeUpdate(sql);
con.close();
statement.close();
if (a == 1) {
JOptionPane.showMessageDialog(null, "");
}
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "");
e.printStackTrace();
}
}
public boolean compare(String username, String password) {
boolean m = false;
String sql = "select password from enter where username=\"" + username + "\"";
try {
res = statement.executeQuery(sql);
if (res.next()) {
String pa = res.getString(1);
if (pa.equals(password)) {
m = true;
} else {
JOptionPane.showMessageDialog(null, "");
}
} else {
JOptionPane.showMessageDialog(null, "");
}
res.close();
con.close();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
return m;
}
这两个函数所带的功能分别是对登录的验证以及注册的功能的实现,其实都是一些换汤不换药的东西,本小白觉得没有什么难度,各位大神们,你们写的肯定要比这个简单得多!!
剩下的就是view层的实现,运用到了SWing的知识,在图层中实现我们一些简单的逻辑操作。
大家再见,欢迎各位大牛批评指正!!我正在努力上进中!!