DAO设计模式---实现一个简单的注册(中)

4、DAO接口实现类：

package com.song.Impl;import java.sql.*;import com.song.DAO.RegisterDAO;import com.song.VO.RegisterBean;import com.song.DB.*;public class RegisterImpl implements RegisterDAO{public void insert(RegisterBean registerBean)throws Exception{String sql = "insert into register(username,password,email) values (?,?,?)";PreparedStatement pstmt = null;Connection conn = null;DataBaseConnection dbconn = null;try{dbconn = new DataBaseConnection();conn = dbconn.getConn();pstmt = conn.prepareStatement(sql);pstmt.setString(1,registerBean.getUsername());pstmt.setString(2,registerBean.getPassword());pstmt.setString(3,registerBean.getEmail());pstmt.executeUpdate();pstmt.close();conn.close();}catch(Exception e){System.out.println("数据插入失败！");e.printStackTrace();}finally{dbconn.close();}}}