userdao.java

BBS系统

package bbs.dao;
import java.lang.annotation.*;
import java.util.ArrayList;

import java.sql.*;

import bbs.bean.useBean;

public class userDao {
	public ArrayList<useBean> getUser(){
		ArrayList<useBean> ar=new ArrayList<useBean>();
		PreparedStatement pt=null;
		ResultSet rs=null;
		
		Connection con=conn.getInstance();
		try {
			pt=con.prepareStatement("select * from BBSUserInfo");
			rs=pt.executeQuery();
			while(rs.next()){
				useBean th=new useBean();
				
				
				th.setIcon(rs.getInt(6));
				th.setPostCnt(rs.getInt(5));
				th.setRewards(rs.getInt(4));
				th.setSex(rs.getString(3));
				th.setUserid(rs.getInt(1));
				th.setUserNickName(rs.getString(2));
				th.setU_name(rs.getString(7));
				th.setU_password(rs.getString(8));
				
				ar.add(th);	
			}
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				pt.close();
				con.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		return ar;
	}
	public ArrayList<useBean> getUser(int id){
		ArrayList<useBean> ar=new ArrayList<useBean>();
		PreparedStatement pt=null;
		ResultSet rs=null;
		
		Connection con=conn.getInstance();
		try {
			pt=con.prepareStatement("select * from BBSUserInfo where userid=?");
			pt.setInt(1, id);
			rs=pt.executeQuery();
			while(rs.next()){
				useBean th=new useBean();
				
				
				th.setIcon(rs.getInt(6));
				th.setPostCnt(rs.getInt(5));
				th.setRewards(rs.getInt(4));
				th.setSex(rs.getString(3));
				th.setUserid(rs.getInt(1));
				th.setUserNickName(rs.getString(2));
				th.setU_name(rs.getString(7));
				th.setU_password(rs.getString(8));
				
				ar.add(th);	
			}
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				pt.close();
				con.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		return ar;
	}
	public String getUsertwo(int id){
		String ar="";
		PreparedStatement pt=null;
		ResultSet rs=null;
		
		Connection con=conn.getInstance();
		try {
			pt=con.prepareStatement("select * from BBSUserInfo where userid=?");
			pt.setInt(1, id);
			rs=pt.executeQuery();
			while(rs.next()){
				
				
				
				
				ar=rs.getString(2);
				
				
				
				
			}
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				pt.close();
				con.close();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		return ar;
	}

	

}