userdao.java

来自「JSP源代码 主要实现网页的交互功能 刚学JAVA」· Java 代码 · 共 63 行

package com.dao;
import com.model.TabUser;
import com.conn.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class UserDao {
	public TabUser findUser(String name,String pass){
		Connection conn=null;
		PreparedStatement ment=null;
		ResultSet set=null;
		TabUser user=null;
		try{
			String sql="select * from TabUser where name=? and pass=?";
			conn=ConnectionManager.getConnection();
			ment=conn.prepareStatement(sql);
			ment.setString(1, name);
			ment.setString(2, pass);
			set=ment.executeQuery();
			if(set.next()){
				String uName=set.getString(1);
				String uPass=set.getString(2);
				user=new TabUser(uName,uPass);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			ConnectionManager.closeResultSet(set);
			ConnectionManager.closeStatement(ment);
			ConnectionManager.closeConnection(conn);
		}
		return user;
	}
	
	public List showUserList(){
		Connection conn=null;
		PreparedStatement ment=null;
		ResultSet set=null;
		TabUser user=null;
		List userList=new ArrayList();
		try{
			String sql="select * from TabUser";
			conn=ConnectionManager.getConnection();
			ment=conn.prepareStatement(sql);
			
			set=ment.executeQuery();
			while(set.next()){
				String uName=set.getString(1);
				String uPass=set.getString(2);
				user=new TabUser(uName,uPass);
				userList.add(user);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			ConnectionManager.closeResultSet(set);
			ConnectionManager.closeStatement(ment);
			ConnectionManager.closeConnection(conn);
		}
		return userList;
	}
}