controltable.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 Controltable {
	
	public Controltable(String str) throws ClassNotFoundException, SQLException
	{
		System.out.println(str);
		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对象
	    stmt.executeUpdate(str);
	}

}