dbconnector.java

来自「是一个简化的学校教职工管理系统」· Java 代码 · 共 44 行

import java.sql.*;


public class DBConnector {
  public static Connection getConnection(String driverName,String url,String user,String passwd) throws ClassNotFoundException, SQLException{
	  Connection con;
	  Class.forName(driverName);
	  con=DriverManager.getConnection(url, user, passwd);
	  return con;
	  
	  
  }
  public static Connection getAccessConnection(String dbName,String user,String passwd) throws ClassNotFoundException, SQLException{
	  
	  String url="jdbc:odbc:"+dbName;
	  String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
	  
	  return getConnection(driverName,url,user,passwd);
	  
	  
	  
  }
  public static void main(String[] args){
	  
	  
	  try{
		  
		  Connection con=DBConnector.getAccessConnection("teacher", null, null);
		  Statement stat=con.createStatement();
		  ResultSet rs=stat.executeQuery("select * from tinfo");
		  int no;
		  String name;
		  rs.next();
		  no=rs.getInt(1);
		  name=rs.getString("name");
		  System.out.println(no+"\n"+name);
	  }catch(Exception e){
		  
		  e.printStackTrace();
	  }
	  
  }
}