dbquerybean.java

来自「这是一个在线订购的例子」· Java 代码 · 共 56 行

package mybeans;
import java.util.*;
import java.sql.*;
public class DBQueryBean
{
   public Connection getConnection(){
     Connection dctx = null;
     try{
     Class.forName("org.gjt.mm.mysql.Driver");
     dctx = DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&useUnicode=true&characterEncoding=gb2312");
	}catch(Exception e)
{
	System.out.println(e.toString());
	}
     return dctx;
	}
        /*查询全部用户*/ 
   public Vector DBResult1()
   {  
    Vector vc = new Vector();      
     try{
/*建立数据库连接*/  
         DBQueryBean db = new DBQueryBean();
         Connection dctx = db.getConnection();
         Statement bm1 = dctx.createStatement();
     ResultSet rs1 = bm1.executeQuery("select name from custominfo");
      while(rs1.next())
      vc.addElement(rs1.getString(1));
      dctx.close();
   	}catch(SQLException e)
        {
           System.out.println(e.toString());
   		}
    return vc;	
  }
          /*查询指定用户所购买的商品*/
  public Vector DBResult2(String name)
   {
  	 Vector vc = new Vector();      
     try{  
 /*建立数据库连接*/
         DBQueryBean db = new DBQueryBean();
         Connection dctx = db.getConnection();
         Statement bm1 = dctx.createStatement();
     ResultSet rs1 = bm1.executeQuery("select items from items where name='"+name+"'");
      while(rs1.next())
      vc.addElement(rs1.getString(1));
      dctx.close();
   	}catch(SQLException e)
        {
           System.out.println(e.toString());
   	    }
    return vc;	
	}
}