package dbconn;
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class conndb {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public conndb() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.print(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try {
conn = DriverManager.getConnection("jdbc.odbc.mydb", "sa", "sa");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql); } catch (SQLException ex) {
System.err.print(ex.getMessage()); }
return rs;
}
public int executeUpdate(String sql){
int result = 0;
try{
conn=DriverManager.getConnection("jdbc.odbc.mydb","sa","sa");
stmt=conn.createStatement();
result=stmt.executeUpdate(sql);
}catch(SQLException ex){
result=0;
}
return result;
}
public void close(){
try{
if(rs!=null)rs.close();}
catch(Exception e){
e.printStackTrace(System.err);
}
try{
if(stmt!=null)stmt.close();
}catch(Exception e){
e.printStackTrace(System.err);
}
try{
if(conn!=null){
conn.close();
}
}catch(Exception e){
e.printStackTrace(System.err);
}
}
}
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class conndb {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public conndb() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.print(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try {
conn = DriverManager.getConnection("jdbc.odbc.mydb", "sa", "sa");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql); } catch (SQLException ex) {
System.err.print(ex.getMessage()); }
return rs;
}
public int executeUpdate(String sql){
int result = 0;
try{
conn=DriverManager.getConnection("jdbc.odbc.mydb","sa","sa");
stmt=conn.createStatement();
result=stmt.executeUpdate(sql);
}catch(SQLException ex){
result=0;
}
return result;
}
public void close(){
try{
if(rs!=null)rs.close();}
catch(Exception e){
e.printStackTrace(System.err);
}
try{
if(stmt!=null)stmt.close();
}catch(Exception e){
e.printStackTrace(System.err);
}
try{
if(conn!=null){
conn.close();
}
}catch(Exception e){
e.printStackTrace(System.err);
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货