admindao.java

详细的学生档案管理系统,包括系统管理员学生,老师,辅助管理员,功能已经很完善了

package com.nitpro.school.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.nitpro.school.bean.Admin;
import com.nitpro.school.bean.User;
import com.nitpro.school.util.ConnectionPoolHelper;

public class AdminDao {
    public Admin getAdmin(User user){
    	Admin admin = null;
    	try {
			Connection conn = ConnectionPoolHelper.getConnection();
			String sql = "SELECT adminId, userName, pwd, lastChange FROM admin WHERE userName=? AND pwd = ?";
			PreparedStatement state = conn.prepareStatement(sql);
			state.setString(1, user.getUserName());
			state.setString(2, user.getPwd());
			ResultSet rs = state.executeQuery();
			if(rs.next()){
				admin = new Admin();
				admin.setAdminId(rs.getInt("adminId"));
				admin.setUserName(rs.getString("userName"));
				admin.setPwd(rs.getString("pwd"));
				admin.setLastChange(rs.getDate("lastChange"));
			}
			ConnectionPoolHelper.closeResultSet(rs);
			ConnectionPoolHelper.closeStatement(state);
			ConnectionPoolHelper.closeConnection(conn);
		} catch (Exception e) {
			e.printStackTrace();
		}
    	return admin;
    }
    
    public int changePwd(Admin admin){
    	int result = 0;
    	try {
			Connection conn = ConnectionPoolHelper.getConnection();
			String sql = "UPDATE admin SET pwd = ?, lastChange = ? WHERE adminId = ?";
			PreparedStatement state = conn.prepareStatement(sql);
			state.setString(1, admin.getPwd());
			state.setDate(2, new java.sql.Date(admin.getLastChange().getTime()));
			state.setInt(3, admin.getAdminId());
			result = state.executeUpdate();
			ConnectionPoolHelper.closeStatement(state);
			ConnectionPoolHelper.closeConnection(conn);
		} catch (Exception e) {
			e.printStackTrace();
		}
    	return result;
    }
    
}