java的MVC 模式的数据库增删改查.docVIP

攀枝花学院实验报告 实验课程:JAVA应用开发范胜波 实验目的： 掌握JSP，servlet的基本应用。 掌握用JSP对数据库进行增，删，查，改操作。 实验设备 Eclipse，Mysql数据库，Tomact 实验内容 创建数据库javaee和表Users，Users的sql语句为： CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `UserName` varchar(30) NOT NULL, `Password` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; 编写数据库连接、增、删、查、改类UserDao，核心代码如下： public class UserDao { final static String url = jdbc:mysql://localhost:3306/javaee?useUnicode=truecharact erEncoding=UTF-8; final static String user = root; final static String password = 123456; static { try { Class.forName(com.mysql.jdbc.Driver); } catch (ClassNotFoundException e) { e.printStackTrace(); } } //数据库连接 private Connection getConnection() throws SQLException { Connection conn = DriverManager.getConnection(url, user, password); return conn; } //根据ID删除用户 public boolean delUser(int id){ boolean flag=false; String addUserSQL=DELETE FROM Users WHERE ID=?; Connection conn = null; PreparedStatement pst = null; try { conn=getConnection(); pst=conn.prepareStatement(addUserSQL); pst.setInt(1, id); flag=(pst.executeUpdate()==1); } catch (SQLException e) { e.printStackTrace(); }finally{ try { pst.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return flag; } //增加用户 public boolean addUser(User newUser){ boolean flag=false; String addUserSQL=INSERT INTO Users(UserName,Password) VALUES(?,?); Connection conn = null; PreparedStatement pst = null; try { conn=getConnection(); pst=conn.prepareStatement(addUserSQL); pst.setString(1, newUser.getUserName()); pst.setString(2, newUser.getPassword()); flag=(pst.executeUpdate()==1); } catch (SQLException e) { e.printStackTrace(); }finally{ try { pst.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return flag; } //分页查询用户 public ListUse