bouquetbean.java

基于JSP的网上花店系统。工作量符合本科毕业设计水准1

package bouquetbean;
import java.sql.*;
public class BouquetBean {
	private String bouquetid = null;		
	private String bouquetname = null;		
	private String classify = null;		
	private String price = null;			
	private int  storage = 0;			
	private String meaning = null;
	private String discript = null;	
	private String image = null;				
	private static String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	private static String strDBUrl = "jdbc:odbc:sun";
	private Connection conn =null;
	private ResultSet rs = null;	
	public String getString(String s) {
            if(s == null)   s = "";
            try{
                 byte a[] = s.getBytes("ISO-8859-1");
                       s = new String(a);
                } 
            catch(Exception e) {  }
            return s;
          }
	
	public  BouquetBean(){
		//加载驱动
		try {
			Class.forName(strDBDriver);
		}
		catch(java.lang.ClassNotFoundException e){
			System.err.println("BouquetBean ():" + e.getMessage());
		}	
	}
	//取当前库中全部信息
    	public ResultSet getBouquetList(){
		String strSql = null;
		try{
			//建立与数据库的连接
			conn = DriverManager.getConnection(strDBUrl,"sa","");
			Statement stmt = conn.createStatement();
			strSql = "select * from bouquet";
			rs = stmt.executeQuery(strSql);		
		
		}
		//捕获异常
		    catch(SQLException e){
			System.err.println("BouquetBean.getBouquetList():" + e.getMessage());
		}
		return rs ;
	}
	//根据编号给其他信息赋值
	 public  ResultSet  getBouquetInfo(String ID){
		String strSql="" ;
		String bouquetname="";
		String classify="" ;
		String price="" ;
		String meaning="" ;
		String discript="";
		String image="";
		try{
			//建立和数据库的连接
			conn=DriverManager.getConnection(strDBUrl,"sa","");
			Statement stmt = conn.createStatement();
			strSql = "select * from bouquet where bouquetid = "+"'" + ID+ "'";
		   	rs = stmt.executeQuery(strSql);			
		//	while (rs.next()){
			//	bouquetname=rs.getString("bouquetname");
			//	classify=rs.getString("classify");
			//	price=rs.getString("price");
			//	meaning=rs.getString("meaning");
			//	discript=rs.getString("discript");
		    //	image=rs.getString("image");
        //	}
		}
		//捕获异常
		catch(SQLException e){
			System.err.println("BouquetBean.getBouquetList():" + e.getMessage());
		}		
       	return rs ;     
	}
public  void setBouquetID (String ID){
		this.bouquetid =ID;
		getBouquetInfo(bouquetid);
	}
	//取图书编号
	public  String getBouquetID (){
		return bouquetid ;
	}	
	//取书名
	public String getBouquetName(){
		return bouquetname ;
	}
	//取作者信息
	public String getClassify(){
		return classify;
	}
	//取出版社信息
	public int getStorage(){
		return storage;
	}
	//取图书简介
	public String  getPrice(){
		return price;
	}
	//取图书价格
	public String getMeaning(){
		return meaning;
	}	
	public String getDiscript(){
		return discript;
	}	
	public String getImage(){
		return image;
	}	
			
	//将Bean作为一个application进行测试用
	public  static void main(String args[]){
		BouquetBean bouquet = new BouquetBean();
		bouquet.setBouquetID("02061202");
		 System.out.println(bouquet.getBouquetName());
	     System.out.println(bouquet.getClassify());
		 System.out.println(bouquet.getPrice());
		 System.out.println(bouquet.getMeaning());
     	 System.out.println(bouquet.getDiscript());
		try{
			ResultSet tmpRS = bouquet.getBouquetList();
			while (tmpRS.next()){	
				System.out.println(tmpRS.getString("bouquetname"));
			    System.out.println(tmpRS.getString("discript"));
				
			}
			tmpRS.close();
		}
		//捕获异常
		catch(Exception e){
			System.err.println("main()" + e.getMessage());
		}
	}	

}