customerbean.java

JAVA网上书店的程序原代码,希望对大家偶用

package ebookshop.bean;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import ebookshop.common.DataConnect;

public class CustomerBean implements Serializable
{	
	private String userName;
	private String passWord;
	private int cid;
	
	public CustomerBean(String userName,String passWord)
	{
		this.userName=userName;
		this.passWord=passWord;
	}
	
	public CustomerBean()
	{
		
	}
	
	public String getUserName(){return this.userName;}
	public String getPassWord(){return this.passWord;}
	public int getCid() {return this.cid;}
	
	public void setUserName(String userName){this.userName=userName;}
	public void setPassWord(String passWord){this.passWord=passWord;}
	public void setCid(int cid) {this.cid=cid;}
	
	public int cidByUserName(String userName)
	{
		String sql="select cid from customer where userName='"+userName+"'";
		Connection con=DataConnect.getConnection("netbookdata");
		Statement st =null;
		ResultSet rs =null;
		int cid=0;
		try 
		{
			st = con.createStatement();
			rs=st.executeQuery(sql);			
			while(rs.next())
			{
				cid=rs.getInt("cid");
				System.out.println("-----------------"+cid);
			}
			rs.close();
			st.close();
			con.close();
		}
		catch (SQLException e) {
			
			e.printStackTrace();
			//return;
			
		}
		return cid;
		
	}
	
	public String toString()
	{
		return userName+"\t"+passWord;
	}
}