usersdao.java

應用java技術中的jsf技術對用戶登陸進行代碼編寫

package com.xaccp.dao;

import java.sql.*;
import com.xaccp.dbm.DBManager;
import com.xaccp.vo.UsersVo;

public class UsersDao {

	public UsersVo findByNameAndPass(String name,String pass){
		String sql="select * from users where username=? and userpass=?";
		Connection conn=DBManager.getConn();
		try {
			PreparedStatement ps=conn.prepareStatement(sql);
			ps.setString(1, name);
			ps.setString(2, pass);
			ResultSet rs=ps.executeQuery();
			while(rs.next()){
				UsersVo uvo=new UsersVo();
				uvo.setUsername(rs.getString(1));
				uvo.setUserpass(rs.getString(2));
				uvo.setUserrole(rs.getString(3));
				uvo.setSalary(rs.getInt(4));
				return uvo;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}		
		return null;
	}
}