userdao java_UserDao.java

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

原始数据

按行查看

历史