webwork-register.rar_webwork_webwork 验证_webwork spring

package cn.ac.ict; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Statement; public class UserDAO { private final String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 连接sql数据库的方法 private final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=webwork"; private final String userName = "sa"; private final String password = "123"; private Connection con = null; public UserDAO() { try { Class.forName(dbDriver).newInstance(); // 加载数据库驱动 } catch (Exception ex) { System.out.println("数据库加载失败"); } } public void add(User user) { try { Class.forName(dbDriver).newInstance(); con = DriverManager.getConnection(url, userName, password); PreparedStatement ps = con .prepareStatement("insert into userinfo values(?,?,?,?,?)"); ps.setString(1, user.getUsername()); ps.setString(2, user.getPassword()); ps.setString(3, user.getVerifyPassword()); ps.setString(4, user.getEmail()); ps.setInt(5, user.getAge()); ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (InstantiationException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IllegalAccessException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }