userdaoimpl.java

固定资产管理系统包括一个基本的部分

package com.shenlong.assetmanage.daoImplSQLserver;

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

import com.shenlong.assetmanage.dao.UserDao;
import com.shenlong.assetmanage.dbhelp.ConnectionFactory;
import com.shenlong.assetmanage.domain.User;



public class UserDaoImpl implements UserDao{
	//－－－－－根据用户的名字查询用户的信息－－－－－
	public User getUser(String username) throws SQLException{
		
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		User user = null;
		try{
			con = ConnectionFactory.getConnection();
			String sql = "SELECT * FROM admin WHERE admin_name=?";
			ps = con.prepareStatement(sql);
			ps.setString(1, username);
			rs = ps.executeQuery();			
			while(rs.next()){
				user = new User(
						rs.getString("admin_name"),
						rs.getString("password")
				);
			}
		}finally{
			rs.close();
			ps.close();
			con.close();
		}
		return user;
	}
//－－－－－－修改指定用户的密码－－－－－－－－－－
	public int modifyPassword(User user) throws SQLException{		
		Connection con = null;
		PreparedStatement ps = null;
		try{
			con = ConnectionFactory.getConnection();
			String sql = "UPDATE admin SET password=? WHERE admin_name=?";
			ps = con.prepareStatement(sql);
			ps.setString(1, user.getPassword());
			ps.setString(2, user.getUsername());
			return ps.executeUpdate();
		}finally{
			ps.close();
			con.close();
		}
	}	
}