简易用户增,删,改,查(DAO模式实现):
简单介绍:
- Conn.java:连接数据库
- UserDao.java(数据层):放增,删,改,查的方法
- User.java:JavaBean定义,封装用户属性的类,注意命名要与表中变量名一致
- view.jsp:初始界面,进行选择
- Register.jsp:添加注册页面
- DoRegister.jsp:执行添加操作
- SelectUser.jsp:用来显示全部用户及查找,还可用于选择删除和修改操作
- DeleteUser.jsp:删除用户
- UpdateUser.jsp:修改用户
- DoUpdateUser.jsp:执行修改用户操作
话不多说上代码:
- Conn.java
package com.JavaBean_zyd.conn;
import java.sql.*;
public class Conn {
public Connection getConn() {
Connection conn=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/testaa?characterEncoding=utf-8", "root", "123456");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}
package com.JavaBean_zyd.dao;
import com.JavaBean_zyd.conn.*;
import com.JavaBean_zyd.user.*;
import java.sql.*;
import java.util.*;
public class UserDao {
public int InsertUser(User user) {
int rs=0;
try {
Conn dbc=new Conn();
Connection conn=dbc.getConn();
String sql_insert="INSERT INTO user(username,password,type) VALUES (?,?,?) ";
PreparedStatement pst = conn.prepareStatement(sql_insert);
pst.setString(1,user.getUsername());
pst.setString(2, user.getPassword());
pst.setString(3,user.getType());
rs=pst.executeUpdate();
pst.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
return rs;
}
public List<User> SelectUser() {
List<User> list = new ArrayList<User>();
ResultSet rs = null;
try {
Conn dbc=new Conn();
Connection conn=dbc.getConn();
String sql_select="select * from user ";
PreparedStatement pst = conn.prepareStatement(sql_select);
rs=pst.executeQuery();
while(rs.next()) {
User user = new User();
user.setId(rs.getString("id"));
user.setUsername(rs.getString("username"));
user.setPassword(rs.getString("password"));
user.setType(rs.getString("type"));
list.add(user);
}
rs.close();
pst.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
return list;
}
public int DeleteUser(User user) {
int rs=0;
try {
Conn dbc=new Conn();
Connection conn=dbc.getConn();
String sql_delete="delete from user where id = ?";
PreparedStatement pst = conn.prepareStatement(sql_delete);
pst.setString(1,user.getId());
rs=pst.executeUpdate();
pst.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
return rs