package com.jspsql;
import java.sql.*;
import java.util.*;public class SqlConnect{
private String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
private String connStr="jdbc:odbc:";
private Connection conn=null;
private Statement stmt=null;
private String username=null;
private String password=null;
private ResultSet rs=null; private void init() throws SQLException{
try{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(connStr,username,password);
stmt=conn.createStatement();
}
catch(java.lang.ClassNotFoundException e){
System.err.println("沒有JDBC-ODBC驅動!");
}
} public void connect(String odbc,String username,String password) throws SQLException{
connStr+=odbc;
this.username=username;
this.password=password;
init();
} public void connect(String odbc) throws SQLException{
connStr+=odbc;
init();
} public ResultSet executeQuery(String sqlStatement){
rs=null;
try{
rs=stmt.executeQuery(sqlStatement);
}
catch(SQLException ex){
System.err.println("SQLRun:"+ex.getMessage());
}
return rs;
} public void executeUpdate(String sqlStatement){
try{
stmt.executeUpdate(sqlStatement);
}
catch(SQLException ex){
System.err.println("SQLRun:"+ex.getMessage());
}
} public void close(){
try{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
}
catch(SQLException ex){
}
}}
import java.sql.*;
import java.util.*;public class SqlConnect{
private String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
private String connStr="jdbc:odbc:";
private Connection conn=null;
private Statement stmt=null;
private String username=null;
private String password=null;
private ResultSet rs=null; private void init() throws SQLException{
try{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(connStr,username,password);
stmt=conn.createStatement();
}
catch(java.lang.ClassNotFoundException e){
System.err.println("沒有JDBC-ODBC驅動!");
}
} public void connect(String odbc,String username,String password) throws SQLException{
connStr+=odbc;
this.username=username;
this.password=password;
init();
} public void connect(String odbc) throws SQLException{
connStr+=odbc;
init();
} public ResultSet executeQuery(String sqlStatement){
rs=null;
try{
rs=stmt.executeQuery(sqlStatement);
}
catch(SQLException ex){
System.err.println("SQLRun:"+ex.getMessage());
}
return rs;
} public void executeUpdate(String sqlStatement){
try{
stmt.executeUpdate(sqlStatement);
}
catch(SQLException ex){
System.err.println("SQLRun:"+ex.getMessage());
}
} public void close(){
try{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
}
catch(SQLException ex){
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货