odbcbridge.java

该源程序是自做的一个简单的学籍管理系统

//如何用JAVA实现对Access数据库的访问

import java.io.BufferedReader; 
import java.io.InputStreamReader; 
import java.sql.*; 

public class ODBCBridge { 

public static void main(String[] args) { 
String url="jdbc:odbc:GLSystem"; 
Statement sm=null; 
String command=null; 
ResultSet rs=null; 
String tableName=null; 
String cName=null; 
String result=null; 
BufferedReader input=new BufferedReader(new InputStreamReader(System.in)); 
try { 
try { 
Class.forName("GLSystem.jdbc.odbc.JdbcOdbcDriver"); //加载驱动 
}catch(ClassNotFoundException e){ 
System.out.println("Can not load Jdbc-Odbc Bridge Driver"); 
System.err.print("ClassNotFoundException:"); 
System.err.println(e.getMessage()); 
} 
Connection con=DriverManager.getConnection(url,"USER","PASSWORD"); //使用SQL-SERVER2000认证 
DatabaseMetaData dmd=con.getMetaData(); //DMD为连接的相应情况 
System.out.println("连接的数据库:"+dmd.getURL()); 
System.out.println("驱动程序:"+dmd.getDriverName()); 
sm=con.createStatement(); 
System.out.println("输入表名"); 
tableName=input.readLine(); 
//while(true) { 
System.out.println("输入列名(为空时程序结束):"); 
cName="姓名";//input.readLine(); 
// if(cName.equalsIgnoreCase("")) 
// break; 
// command="select "+cName+" from "+tableName; 
rs=sm.executeQuery("select * from "+tableName);//(command); //执行查询 
if(!rs.next()) 
System.out.println("表名或列名输入有误"); 
else { 
System.out.println("查询结果为:"); 
do 
{ 
result=rs.getString(1)+" "+rs.getString(2)+" " 
+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5); 
//数据库语言设置为中文，不用转换编码 
//result=new String(result.getBytes("ISO-8859-1"),"GB2312"); 
System.out.println(result); 
}while(rs.next()); 
String s="insert into login(用户名,密码,性别,年龄,邮箱) values('蔡辉','2063','男',20,'583558404163.com')"; 
sm.executeUpdate(s); 
} 
rs.close(); 
con.close(); 
// } 
}catch(SQLException ex) { 
System.out.println("SQLException:"); 
while(ex!=null) { 
System.out.println("Message:"+ex.getMessage()); 
ex=ex.getNextException(); 
} 
}catch(Exception e) { 
System.out.println("IOException"); 
} 
} 
}