intemp.java

教材订购系统

package program;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Intemp {
	
	public void intemp(String bclass,String bno,String bcount) 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;
		int kucun,sheng;
	
		Getdate now =new Getdate();
		Class.forName(DBDriver);	 //加载驱动器
		con=DriverManager.getConnection(connectionStr,"",""); //连接数据库
		stmt=con.createStatement();   //创建Statement对象
	
		stmt.executeUpdate("INSERT INTO Temp(班号,书号,数量) VALUES " +
					 "('"+bclass+"','"+bno+"',"+bcount+")");
//	添加Temp表
	}
	
}