将一个对人员增删改查的程序改成Hibernate+spring+struts方式解决思路

package com.experiment.Dao;import java.util.ArrayList;import java.util.List;import com.experiment.vo.UserInfo;public interface UserManagerDao {    public void insert(UserInfo user);    public void updateById(UserInfo userInfo);    public void deleteById(int id);    public UserInfo queryByAccount(String account);    public ArrayList<UserInfo> queryAll();       public UserInfo queryById(int id);}[color=#FF0000]package com.experiment.Dao.DapImpl;[/color]import java.io.UnsupportedEncodingException;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import com.experiment.Dao.UserManagerDao;import com.experiment.Db.DataBaseConnectionOracle;import com.experiment.vo.UserInfo;public class UserManagerDaoImpl implements UserManagerDao {    public void insert(UserInfo user) {        String sql = "INSERT INTO usertable (id,account,name,birthday,sex) VALUES (?,?,?,?,?)";        PreparedStatement pstmt = null;        DataBaseConnectionOracle dbc = null;        try {    dbc = new DataBaseConnectionOracle();            pstmt = dbc.getConnection().prepareStatement(sql);            pstmt.setInt(1, user.getId());            pstmt.setString(2, user.getAccount());            try { pstmt.setString(3, new String(user.getName().getBytes(),                                "UTF-8"));            } catch (UnsupportedEncodingException e) {                e.printStackTrace(); }            pstmt.setString(4, user.getBirthday());            pstmt.setInt(5, user.getSex());            pstmt.executeUpdate();            pstmt.close();        } catch (SQLException e) {            e.printStackTrace();        } finally {            dbc.close();        }}    public void deleteById(int id) {        String sql = "DELETE FROM usertable WHERE id=?";        PreparedStatement pstmt = null;        DataBaseConnectionOracle dbc = null;        try {            dbc = new DataBaseConnectionOracle();            pstmt = dbc.getConnection().prepareStatement(sql);            pstmt.setInt(1, id);            pstmt.executeUpdate();            pstmt.close();        } catch (Exception e) {            e.printStackTrace();        } finally {            dbc.close();        }}    public ArrayList<UserInfo> queryAll() {        ArrayList<UserInfo> all = new ArrayList<UserInfo>();        String sql = "SELECT id,account,name,birthday,sex FROM usertable";        PreparedStatement pstmt = null;        DataBaseConnectionOracle dbc = null;        try {    dbc = new DataBaseConnectionOracle();            pstmt = dbc.getConnection().prepareStatement(sql);            ResultSet rs = pstmt.executeQuery();            while (rs.next()) {                UserInfo userInfo = new UserInfo();                userInfo.setId(rs.getInt(1));                userInfo.setAccount(rs.getString(2));                userInfo.setName(rs.getString(3));                userInfo.setBirthday(rs.getString(4));                userInfo.setSex(rs.getShort(5));                all.add(userInfo);            }rs.close();            pstmt.close();        } catch (Exception e) {            e.printStackTrace();        } finally {            dbc.close();}        return all;    }public UserInfo queryById(int id) {        UserInfo userInfo = null;        String sql = "SELECT id,account,name,birthday,sex FROM usertable WHERE id=?";        PreparedStatement pstmt = null;        DataBaseConnectionOracle dbc = null;        try {    dbc = new DataBaseConnectionOracle();            pstmt = dbc.getConnection().prepareStatement(sql);            pstmt.setInt(1, id);            ResultSet rs = pstmt.executeQuery();            if (rs.next()) {                userInfo = new UserInfo();                userInfo.setId(rs.getInt(1));                userInfo.setAccount(rs.getString(2));                userInfo.setName(rs.getString(3));                userInfo.setBirthday(rs.getString(4));                userInfo.setSex(rs.getInt(5));            }rs.close();            pstmt.close();        } catch (Exception e) {            e.printStackTrace();        } finally {            dbc.close();        }        return userInfo;    }public UserInfo queryByAccount(String account) {        UserInfo userInfo = null;        String sql = "SELECT id,account,name,birthday,sex FROM usertable WHERE account=?";        PreparedStatement pstmt = null;        DataBaseConnectionOracle dbc = null;        try {    dbc = new DataBaseConnectionOracle();            pstmt = dbc.getConnection().prepareStatement(sql);            pstmt.setString(1, account);            ResultSet rs = pstmt.executeQuery();            if (rs.next()) {                userInfo = new UserInfo();                userInfo.setId(rs.getInt(1));                userInfo.setAccount(rs.getString(2));                userInfo.setName(rs.getString(3));                userInfo.setBirthday(rs.getString(4));                userInfo.setSex(rs.getInt(5));            }            rs.close();            pstmt.close();        } catch (Exception e) {            e.printStackTrace();        } finally {            dbc.close();        }return userInfo;    }    public void updateById(UserInfo user) {        String sql = "UPDATE usertable SET account=?,name=?,birthday=?,sex=? WHERE id=?";        PreparedStatement pstmt = null;        DataBaseConnectionOracle dbc = null;        try {    dbc = new DataBaseConnectionOracle();            pstmt = dbc.getConnection().prepareStatement(sql);            pstmt.setString(1, user.getAccount());            pstmt.setString(2, user.getName());            pstmt.setString(3, user.getBirthday());            pstmt.setInt(4, user.getSex());            pstmt.setInt(5, user.getId());            pstmt.executeUpdate();            pstmt.close();        } catch (Exception e) {            e.printStackTrace();        } finally {            dbc.close();        }}    public static void main(String[] args) {        UserManagerDaoImpl um = new UserManagerDaoImpl();        ArrayList<UserInfo> userlist = um.queryAll();        UserInfo u = um.queryById(1);        System.out.println(userlist.size());    }}[color=#FF0000]package com.experiment.Db;[/color]import java.sql.*;public class DataBaseConnectionOracle {        private final String dbUrl = "jdbc:oracle:thin:@Bard0117:1522:ORCL";    private final String user="system";    private final String password="system";        private Connection conn = null;        public DataBaseConnectionOracle() {        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            this.conn = DriverManager.getConnection(dbUrl,user,password);        } catch (Exception e) {        }    }     public Connection getConnection() {        return this.conn;    }        public void close() {        try {            this.conn.close();        } catch (Exception e) {        }    }   public static void main(String [] args){        DataBaseConnectionOracle dbc = new DataBaseConnectionOracle();        @SuppressWarnings("unused")        Connection conn = dbc.getConnection();        System.out.println("Connection is success!");        dbc.close();    }}[color=#FF0000]package com.experiment.usermanger;[/color]import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.experiment.Dao.UserManagerDao;import com.experiment.Dao.DapImpl.UserManagerDaoImpl;import com.experiment.vo.UserInfo;public class UserManagerServlet extends HttpServlet {    private static final long serialVersionUID = 1L;    public UserManagerServlet() {        super();}    protected void doGet(HttpServletRequest request,            HttpServletResponse response) throws ServletException, IOException {        System.out.println("do get.........");        doPost(request, response);    }protected void doPost(HttpServletRequest request,            HttpServletResponse response) throws ServletException, IOException {        request.setCharacterEncoding("UTF-8");        String action = request.getParameter("action");        System.out.println(action);        if ("add".equals(action)) {            addUser(request,response);        }        if ("update".equals(action)){            updateUser(request,response);        }        if ("delete".equals(action)){            deleteUser(request,response);        }}    private void deleteUser(HttpServletRequest request,            HttpServletResponse response) throws IOException {        System.out.println("删除数据！");        int deleteId = Integer.parseInt(request.getParameter("deleteid"));        UserManagerDao umd = new UserManagerDaoImpl();        umd.deleteById(deleteId);        response.sendRedirect("index.jsp");    }    private String parseBirthday(HttpServletRequest request,            HttpServletResponse response) {        String year = request.getParameter("year");        String month = request.getParameter("month");        String day = request.getParameter("day");        String date = String.valueOf(year + "-" + month + "-" + day);        return date;    }    private void addUser(HttpServletRequest request,            HttpServletResponse response) throws IOException {        System.out.println("提交数据bbb");        UserInfo useradd = new UserInfo();        String userAccount = request.getParameter("userId");        String userName = request.getParameter("nameAll");        String birthday = parseBirthday(request, response);        String sex = request.getParameter("sex");        int sexnum = 0;        if ("b".equals(sex)) {            sexnum = 0;        } else {    sexnum = 1;        }useradd.setAccount(userAccount);        useradd.setName(userName);        useradd.setBirthday(birthday);        useradd.setSex(sexnum);        UserManagerDao umd = new UserManagerDaoImpl();        umd.insert(useradd);        System.out.println("存储用户" + userName);        response.sendRedirect("index.jsp");    }private void updateUser(HttpServletRequest request,            HttpServletResponse response) throws IOException {        System.out.println("更新用户");        UserInfo userUpdate = new UserInfo();        int userId = Integer.parseInt(request.getParameter("userid"));        String userAccount = request.getParameter("updateAccount");        String userName = request.getParameter("updateName");        String birthday = request.getParameter("updateBirthday");        String sex = request.getParameter("sex");        int sexnum = 0;        if ("g".equals(sex)) {            sexnum = 0;        } else {    sexnum = 1;}        userUpdate.setId(userId);        userUpdate.setAccount(userAccount);        userUpdate.setName(userName);        userUpdate.setBirthday(birthday);        userUpdate.setSex(sexnum);        UserManagerDao umd = new UserManagerDaoImpl();        umd.updateById(userUpdate);        System.out.println("更新id为"+ userId+"的用户" );        response.sendRedirect("index.jsp");    }}