jdbc odbc mysql_odbc 链接数据库mysql代码（jdbc能改成odbc的嘛）

importjava.io.*;importjava.sql.*;publicclasssqlBean{publicConnectionconn=null;publicResultSetrs=null;privateStringDatabaseDriver="sun.jdbc.odbc.JdbcodbcDriver";privateStr...

import java.io.*;

import java.sql.*;

public class sqlBean {

public Connection conn=null;

public ResultSet rs=null;

private String DatabaseDriver="sun.jdbc.odbc.JdbcodbcDriver";

private String DatabaseConnStr="jdbc:odbc:yj,'yj',";

public void setDatabaseDriver(String Driver){

this.DatabaseDriver=Driver;

}

public String getDatabaseDriver(){

return(this.DatabaseDriver);

}

public void setDatabaseconnStr(String ConnStr){

this.DatabaseConnStr=ConnStr;

}

public String getDatabaseConnStr(){

return (this.DatabaseConnStr);

}

public sqlBean(){

try{

Class.forName(DatabaseDriver);

}

catch(java.lang.ClassNotFoundException e){

System.err.println("加载驱动器有错误:"+e.getMessage());

System.out.print("执行插入有错误:"+e.getMessage());

}

}

public int executeInsert(String sql){

int num=0;

try{

conn=DriverManager.getConnection("jdbc:odbc:yj","yj","");

Statement stmt=conn.createStatement();

num=stmt.executeUpdate(sql);

}

catch(SQLException ex){

System.err.println("执行插入有错误:"+ex.getMessage());

System.out.print("执行插入有错误："+ex.getMessage());

}

CloseDataBase();

return num;

}

public ResultSet executeQuery(String sql){

rs=null;

try{

conn = DriverManager.getConnection("jdbc:odbc:yj","yj","");

Statement stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

}

catch(SQLException ex){

System.err.println("执行查询有错误："+ex.getMessage());

System.out.println("执行查询有错误："+ex.getMessage());

}

return rs;

}

public int executeDelete(String sql){

int num=0;

try{

conn=DriverManager.getConnection("jdbc:odbc:yj","yj","");

Statement stmt=conn.createStatement();

num=stmt.executeUpdate(sql);

}

catch(SQLException ex){

System.err.println("执行删除有错误:"+ex.getMessage());

}

CloseDataBase();

return num;

}

public void CloseDataBase(){

try{

conn.close();

}

catch(Exception end){

System.err.println("执行关闭Connection对象有错误:"+end.getMessage());

System.out.print("执行关闭Connection对象有错误："+end.getMessage());

}

}

}

展开