import java.sql.*;
...
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//注册DRIVER
Connection conn1 = DriverManager.getConnection("jdbc:odbc:javaaccess","","password");//建立连接 Statement state= conn1.createStatement();//如连接成功返回STATEMENT对象
ResultSet set = state.executeQuery("SELECT * FROM Orders");
while(set.next()){
...
}
}catch (SQLException e){
System.out.println(e.getErrorCode());
}
catch (ClassNotFoundException e){
System.out.println("class not found");
}
}
...
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//注册DRIVER
Connection conn1 = DriverManager.getConnection("jdbc:odbc:javaaccess","","password");//建立连接 Statement state= conn1.createStatement();//如连接成功返回STATEMENT对象
ResultSet set = state.executeQuery("SELECT * FROM Orders");
while(set.next()){
...
}
}catch (SQLException e){
System.out.println(e.getErrorCode());
}
catch (ClassNotFoundException e){
System.out.println("class not found");
}
}
解决方案 »
- 求高手指教一二..
- 问个android preference的问题
- 今天远光的面试官提问:“try括住过多的代码有什么优点什么缺点”
- 请问如何在java应用程序当中实现打印功能?
- 问一个关于编程格式的问题
- socket连接的服务器端怎么控制Client的IP地址?
- 关于APPLET中坐标移动连接数据库的问题,请各位进来看看!
- 一个资源竞争的问题,赐教高手!!!!!!
- 想问高手,在java应用程序中,用PreparedStatement.setString(1,"中国"),然后PreparedStatement.executeUpdate(),是乱码,请问如何解决!
- 请问怎么下载Java 开放的源代码?
- 请问:Java开发数据库应用软件合适吗?
- 线程问题
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;public class db {String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String ConnStr = "jdbc:odbc:DB_SecInfo";ResultSet rs = null;public void db() {
try {
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e){}
}public ResultSet executeQuery(String sql) {
RS = null;
try {
conn = DriverManager.getConnection(ConnStr);
Statement stmt = conn.createStatement();
RS = stmt.executeQuery(sql);
}
}