instructions.txt

jsp做的购物网站

the jsp pages are files are at ROOT/jspD
the java source files are at ROOT/jspD/source
the classes files are at ROOT/WEB-INF/[folder]





java.util.Date time1=new java.util.Date();//获得系统当前时间 

数据库结构：
users:		name(char256)	pwd(char256)	type(int4)	email(char128)	tgh(char256) ID(int4)
			NOKIA/SIEMENS/BIRD(商家)
product:	pName(char256)	producer(char256)	price(float8)	  quantity(int4)  
			maxQuantity(int4)   busiEmail(char20)	ID(int4) 
cart:		JCH(char128)	productName(char256)	producer(char128)	userName(char128)	
			quantity(char128)	time(char20)	userEmail(char20)	busiEmail(char20)
sendTGDB:	pName(char256)	producer(char256)	state(char10)	
			
package jspD; 
public class User{
	private String id;
	private String name;
	private String pwd;
	private int type;
	private String email;	
	
	public void setName(String name){
		this.name=name;
	}
	
	public String getName(){
		return this.name;
	}
	
	public void setType(int type){
		this.type=type;
	}
	public int getType(){
		return this.type;
	}
	
	
	public void setPwd(String pwd){
		this.pwd=pwd;
	}
	public String getPwd(){
		return this.pwd;
	}
	
	
	public void setEmail(String email){
		this.email=email;
	}
	
	public String getEmail(){
		return this.email;
	}
}
CLASSPATH=.;H:\Program Files\j2sdk1.4.2_10\lib;H:\Program Files\j2sdk1.4.2_10\lib\dt.jar;H:\Program Files\j2sdk1.4.2_10\lib\tools.jar;H:\Program Files\Apache Software Foundation\Tomcat 5.0\common\lib\servlet.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
//class Product//////////////////////////////////////////////////////////
public class Product implements Serializable{
	private String pName;
	private String producer;
	private float price;
	private int quantity;
	private int ID;
	
	public void setPName(String pName){
	    this.pName = pName;
	}
	
	public String getPName(){
	    return this.pName;
	}
	
	public void setProducer(String producer){
	    this.producer = producer;
	}
	
	public String getProducer(){
	    return this.producer;
	}
	
	public void setPrice(float price){
	    this.price = price;
	}
	
	public float getPrice(){
	    return this.price;
	}
	
	public void setQuantity(int quantity){
	    this.quantity = quantity;
	}
	
	public int getQuantity(){
	    return this.quantity;
	}
}


//class DBLink//////////////////////////////////////////////////////////
public class DBLink{
	String url,user,password;
	private Connection conn; 
	private Statement stmt;
	private ResultSet rs=null;
	
	
	public ResultSet getRS(){
		return rs;
	}
	
	public DBLink() {
		url="jdbc:microsoft:sqlserver://localhost:1499;DatabaseName=jspDB";
		user="sa";
		password="sa";
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
		}catch(Exception e){		//it can't use SQLException!!
			e.printStackTrace();
		}
	}
	//It can return the ResultSet
	public ResultSet executeQuery(String sql){
		rs=null;
		try{
			conn=DriverManager.getConnection(url,user,password);
			stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
		}catch(Exception e){
			System.err.println("!!sqldata.executeQuery:"+e.getMessage());
		}
		return rs;			
	}
	//It can insert,delete,update
	public boolean executeUpdate(String sql){
		
		try{
			conn=DriverManager.getConnection(url,user,password);
			stmt=conn.createStatement();
			stmt.executeUpdate(sql);	//it return a int 
		}catch(Exception e){
			System.err.println("!!sqldata.executeInsert:"+e.getMessage());
			return false;
		}
		return true;
	}
	
	public boolean hasUser(){
	/*	try{
			if(rs.next())
				return true;			
		}catch(Exception e){
			e.printStackTrace();
		}*/
		return false;
	}
	public void disConn(){
		try{
			rs.close();
			stmt.close();
			conn.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
}