userdaoimpl.java

企业宣传网站后台

package com.westaccp.jsp.company.dao.impl;

import java.util.ArrayList;
import java.util.List;


import com.westaccp.jsp.company.dao.UserDao;
import com.westaccp.jsp.company.model.Users;

import java.sql.*;


public class UserDaoImpl extends BaseDao implements UserDao {

	private Connection con = null;
	private PreparedStatement pstmt = null;
	private ResultSet rs = null;
	
	public int addUser(Users user) {
		int rowCount = 0;
		String sql = "insert into tabUsers values(?, ?, ?)";
		
		try {
			con = this.getCon();
			pstmt = con.prepareCall(sql);
			pstmt.setString(1, user.getUserName());
			pstmt.setString(2, user.getUserName());
			pstmt.setInt(3, user.getStatus());
			rowCount = pstmt.executeUpdate();
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			this.closeDB(null, pstmt, con);
		}
		
		return rowCount;
	}

	public int deleteUser(int userId) {
		int rowCount = 0;
		String sql = "delete from tabUsers where userId = ?";
		
		try {
			con = this.getCon();
			pstmt = con.prepareStatement(sql);
			pstmt.setInt(1, userId);
			rowCount = pstmt.executeUpdate();
		} catch (Exception ex) {
			ex.printStackTrace();
 		} finally {
 			this.closeDB(null, pstmt, con);
 		}
 		
 		return rowCount;
	}

	public List findListUser() {
		List userList = null;
		String sql = "select * from tabUsers";
		
		try {
			con = this.getCon();
			pstmt = con.prepareCall(sql);
			rs = pstmt.executeQuery();
			userList = new ArrayList();
			while(rs.next()) {
				Users user = new Users();
				user.setUserId(rs.getInt("userId"));
				user.setUserName(rs.getString("userName"));
				user.setPassWord(rs.getString("password"));
				user.setStatus(rs.getInt("status"));
				userList.add(user);
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			this.closeDB(rs, pstmt, con);
		}
		
		return userList;
	}

	public Users findUser(int userId) {
		// TODO Auto-generated method stub
		return null;
	}

	public Users findUser(String userName) {
		// TODO Auto-generated method stub
		return null;
	}

	public int updateUser(Users user) {
		// TODO Auto-generated method stub
		return 0;
	}
}