DAO.rar_dao模式怎么写

package DAO; import java.sql.*; import java.util.*; public class UserDAOimpl implements UserDAO{ @Override public void InsertUser(UserBean user) throws Exception { String sql = "INSERT INTO login(id,name,password) VALUES(?,?,?)" ; PreparedStatement pstmt = null ; DataBaseConnection dbc = null ; // 下面是针对数据库的具体操作 try{ // 连接数据库 dbc = new DataBaseConnection() ; pstmt = dbc.getConnection().prepareStatement(sql) ; Scanner in = new Scanner(System.in); System.out.println("请输入id:"); user.setId(in.nextInt()); System.out.println("请输入姓名:"); user.setName(in.next()); System.out.println("请输入密码:"); user.setPassword(in.next()); pstmt.setInt(1, user.getId()); pstmt.setString(2, user.getName()); pstmt.setString(3, user.getPassword()); // 进行数据库更新操作 pstmt.executeUpdate() ; pstmt.close() ; }catch (Exception e){ throw new Exception("操作出现异常") ; } finally{ // 关闭数据库连接 dbc.close() ; } } }