package com.zzptc.easybuy.dao;
import com.zzptc.easybuy.db.IDB;
import com.zzptc.easybuy.db.MysqlDB;
import com.zzptc.easybuy.vo.Users;
import com.zzptc.easybuy.vo.VO;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class UserDao implements com.zzptc.easybuy.dao.IDAO {
//登陆
public boolean login(VO vo){
//获取数据库连接
IDB db=new MysqlDB();
Connection conn= null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
conn = db.getConnnection();
//找一个工具
String sql="select * from t_easybuy_user where eu_user_name=? and eu_password=?";
ps=conn.prepareStatement(sql);
//给?注入值
Users u=(Users)vo;
ps.setString(1,u.getEu_user_name());
ps.setString(2,u.getEu_password());
//要工具完成查询工作
rs=ps.executeQuery();
if (rs.next()){
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
rs.close();
ps.close();
db.closeConn();
} catch (SQLException e) {
e.printStackTrace();
}
}
//释放对象 关闭连接
return false;
}
//注册
public boolean insert(VO vo) {
//获取数据库连接
IDB db=new MysqlDB();
Connection conn= null;
PreparedStatement ps=null;
int i=0;
try {
conn = db.getConnnection();
//用工具操作数据库
ps= conn.prepareStatement("insert into t_easybuy_user(eu_user_id,eu_user_name,eu_password)values(?,?,?)");
//给?注入值
Users users=(Users)vo;
ps.setString(1,users.getEu_user_id());
ps.setString(2,users.getEu_user_name());
ps.setString(3,users.getEu_password());
//操作数据库
i=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
//ps释放 关闭连接
try {
ps.close();
db.closeConn();
} catch (SQLException e) {
e.printStackTrace();
}
}
return i>0;
}
@Override
public List getAll() throws SQLException {
List list=new ArrayList();
//获取数据库连接
IDB db=new MysqlDB();
Connection conn= null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
conn = db.getConnnection();
//获取工具
ps=conn.prepareStatement("select * from t_easybuy_user");
//没有? 不需要注入值
//操作数据库
rs=ps.executeQuery();
while (rs.next()){
Users u=new Users();
//方式一 u.setEu_user_id(rs.getString(1));//从结果集中获取列的值 可以用序号 也可以用表的字段名
u.setEu_user_id(rs.getString("Eu_user_id"));//方式二
u.setEu_user_name(rs.getString(2));
u.setEu_address(rs.getString(9));
u.setEu_birthday(rs.getString(5));
u.setEu_email(rs.getString(7));
u.setEu_identity_code(rs.getString(6));
u.setEu_lj(rs.getString(11));
u.setEu_mobile(rs.getString(8));
u.setEu_password(rs.getString(3));
u.setEu_sex(rs.getString(4));
u.setEu_status(rs.getInt(10));
list.add(u);//加入集合中
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
//释放资源 关闭数据库
try {
rs.close();
ps.close();
db.closeConn();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
@Override
public boolean deleteByID(VO vo){
Users users=(Users)vo;
// //获取数据库连接
IDB db = new MysqlDB();
Connection conn = null;
PreparedStatement ps = null;
int i = 0;
try {
conn=db.getConnnection();
String sql="delete from t_easybuy_user where eu_user_id=?";
//获取操作数据库的工具PreparedStatement 如有?就要注入值
ps=conn.prepareStatement(sql);
ps.setString(1,users.getEu_user_id());
//工作 操作数据库
i=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
ps.close();
db.closeConn();
} catch (SQLException e) {
e.printStackTrace();
}
}
return i > 0;
}
@Override
public boolean update(VO vo){
Users users=(Users)vo;
// //获取数据库连接
IDB db = new MysqlDB();
Connection conn = null;
PreparedStatement ps = null;
int i = 0;
try {
conn=db.getConnnection();
String sql="update t_easybuy_user set eu_user_name=?,eu_address=?,eu_identity_code=?," +
"eu_mobile=?,eu_password=?,eu_sex=?,eu_type=?,eu_lj=?,eu_email=?,eu_birthday=?" +
" where eu_user_id=? ";
//获取操作数据库的工具PreparedStatement 如有?就要注入值
ps=conn.prepareStatement(sql);
ps.setString(1,users.getEu_user_name());
ps.setString(2,users.getEu_address());
ps.setString(3,users.getEu_identity_code());
ps.setString(4,users.getEu_mobile());
ps.setString(5,users.getEu_password());
ps.setString(6,users.getEu_sex());
ps.setInt(7,users.getEu_status());
ps.setString(8,users.getEu_lj());
ps.setString(9,users.getEu_email());
ps.setString(10,users.getEu_birthday());
ps.setString(11,users.getEu_user_id());
//工作 操作数据库
i=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
//释放资源 关闭数据库连接
ps.close();
db.closeConn();
} catch (SQLException e) {
e.printStackTrace();
}
}
return i > 0;
}
@Override
public VO getByID(VO vo) throws SQLException {
return null;
}
//测试
public static void main(String[] args) {
UserDao u=new UserDao();
Users user=new Users();
user.setEu_user_id("3");
user.setEu_user_name("bbb");
user.setEu_password("123");
// try {
// if(u.insert(user)){
// System.out.println("succ");
// }else{
// System.out.println("error");
// }
// } catch (SQLException e) {
// e.printStackTrace();
// }
try {
System.out.println(u.getAll().size());
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(u.login(user));
}
}
一键复制
编辑
Web IDE
原始数据
按行查看
历史