database.java

来自「用java编写的c/s结构的网络社区」· Java 代码 · 共 31 行

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

class database{
	Connection con;
	Statement sql;
	ResultSet rs;
	database(String strDBName,String id,String pw){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}catch(ClassNotFoundException ec){
				ec.printStackTrace();
			}
		try{
			con=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+strDBName+".mdb",id,pw);
				
			sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,   
			          ResultSet.CONCUR_UPDATABLE);
			}catch(SQLException ec){
			    ec.printStackTrace();
			}
		
	 
		
	}
}