package system;
import java.sql.*;
public class DateBase {
private String db;
private String uname;
private String pwd;
private Connection conn;
private Statement stat;
DateBase(String db,String uname,String pwd) {
this.db = db;
this.uname = uname;
this.pwd = pwd;
} public ResultSet executeQuery(String sql) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
return null;
}
try {
conn = DriverManager.getConnection("jdbc:odbc:" + this.db, "sa", "sa");
if(conn==null) {
return null;
} else {
stat = conn.createStatement();
return stat.executeQuery(sql);
}
}
catch (SQLException ex1) {
ex1.printStackTrace();
return null;
} }
}
为什么一运行就是
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的描述器索引
初学JDBC,请高手指教!
import java.sql.*;
public class DateBase {
private String db;
private String uname;
private String pwd;
private Connection conn;
private Statement stat;
DateBase(String db,String uname,String pwd) {
this.db = db;
this.uname = uname;
this.pwd = pwd;
} public ResultSet executeQuery(String sql) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
return null;
}
try {
conn = DriverManager.getConnection("jdbc:odbc:" + this.db, "sa", "sa");
if(conn==null) {
return null;
} else {
stat = conn.createStatement();
return stat.executeQuery(sql);
}
}
catch (SQLException ex1) {
ex1.printStackTrace();
return null;
} }
}
为什么一运行就是
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的描述器索引
初学JDBC,请高手指教!
public ResultSet lookUp(String sql){
try{
connect = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XDF","scott","tiger");
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(Exception e){
e.printStackTrace();
}
return rs;
}
public static void main(String[]args){
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:micorsoft:sqlserver://localhost:1433;databasename=test","sa","sa");
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM student";
rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(1));
}
}
}