lookup.java

教材订购系统

package program;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

public class LookUp {
	
	public LookUp(String tname) throws ClassNotFoundException, SQLException
	{
		String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		String connectionStr="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:/Java_Work/BookManager/program/db/bookmanage.mdb";
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
	 
		Class.forName(DBDriver);	 //加载驱动器
		con=DriverManager.getConnection(connectionStr,"",""); //连接数据库
	
		stmt=con.createStatement();   //创建Statement对象
	    if(tname.equals("购书")) 
	    	tname = "缺书";
		if(tname.equals("书_inf"))
			rs=stmt.executeQuery("Select * From 书_inf Order By 书号"); 
		else if(tname.equals("订_inf"))
			rs=stmt.executeQuery("Select 书_inf.书号,书_inf.书名,书_inf.价格,订_inf.班号,订_inf.数量,书_inf.出版社 From 订_inf,书_inf Where 订_inf.书号=书_inf.书号 Order By 订_inf.班号");  //查询表
		else
			rs=stmt.executeQuery("Select 书_inf.书号,书_inf.书名,书_inf.价格,"+tname+".数量,书_inf.出版社 From "+tname+",书_inf Where "+tname+".书号=书_inf.书号  Order By 书_inf.书号");  //查询表
			  
		ResultSetMetaData rsmd = rs.getMetaData(); 
		int numberOfColumns=rsmd.getColumnCount(); 
		int b=1; 
	    ResultTebal result=new ResultTebal(tname);
		
		while(b<=numberOfColumns)         
		{
			result.dt.addColumn(rsmd.getColumnName(b)); 
			b++; 
		};
	  
		Vector<String> newRow=null;
		
		while(rs.next()) 
		{
			
			newRow=new Vector<String>(); 
			int c=1; 
			while(c<=numberOfColumns) 
			{ 
				newRow.addElement(rs.getString(c)); 
				c++; 
			} 
				result.dt.addRow(newRow); 

		} 
		result.setVisible(true);      
		stmt.close();    //关闭语句
		con.close();   //关闭连接	  
	}
	

}