userlist.java

提供房屋出租信息

package cwnu.com.userData;


import java.sql.*;
import java.util.*;

import javax.sound.midi.MidiDevice.Info;
import javax.swing.JOptionPane;

import cwnu.com.dbconnect.conn;

public class userList {
	
	private Connection myconnection =null;
	private Statement myst=null;
	private ResultSet myrs=null;
	private conn myconn=null;
	private userInfoVo myInfoVo=null;
	
	ArrayList<userInfoVo>  ulist=new ArrayList<userInfoVo>();
	
	public userList()
	{
		myconn = new conn();
		
	}
	
	
	
	public ArrayList<userInfoVo> getlist()
	{
		try
		{		
		    myconnection = myconn.getConn();
		    myst = myconnection.createStatement();
		    myrs = myst.executeQuery("select * from UserInfo");
		    while(myrs.next())
		    {

		    		     myInfoVo = new userInfoVo();
		    		     myInfoVo.setID(myrs.getString(1));
		    		     myInfoVo.setUserName(myrs.getString(2));
		    		     myInfoVo.setPassWord(myrs.getString(3));
		    		     myInfoVo.setPassWordQuestion(myrs.getString(4));
		    		     myInfoVo.setPassWordAnswer(myrs.getString(5));
		    		     myInfoVo.setTrueName(myrs.getString(6));
		    		     myInfoVo.setGender(myrs.getString(7));
		    		     myInfoVo.setAddress(myrs.getString(8));
		    		     myInfoVo.setTelephoneNumber(myrs.getString(9));
		    		     myInfoVo.setEmail(myrs.getString(10));
		    		     myInfoVo.setCreditCard(myrs.getString(11));
		    		     myInfoVo.setCardType(myrs.getString(12));
		    		     myInfoVo.setBirthday(myrs.getString(13));
		    		     
		    		     ulist.add(myInfoVo);

		    }
		    myrs.close();
		    myst.close();
		    myconnection.close();
		}catch (Exception e) {
			System.out.println(e);
		}	
		return ulist;
	}

}