//建立连接数据库的的包程序
package work.com.data;
import java.sql.*;
public class opendb
{
//定义连接字符传jdbc-odbc桥
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String SCon="jdbc:odbc:db1:test";
Connection conn=null;
ResultSet rs=null;
Statement stmt;
//定义打开数据库连接程序
public opendb(){
try {
Class.forName(sDBDriver);
}
//异常处理
catch(java.lang.ClassNotFoundException e){
System.err.println("opendb():"+e.getMessage());
}
}
//定义sql查询语句
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(SCon);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
//异常处理
catch(SQLException ex){
}
return rs;
};
public boolean executeUpdate(String sql)
{
try
{
conn=DriverManager.getConnection(SCon);
stmt=conn.createStatement();
conn.setAutoCommit(true);
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
return false;
}
return true;
}}
这个写法对马
package work.com.data;
import java.sql.*;
public class opendb
{
//定义连接字符传jdbc-odbc桥
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String SCon="jdbc:odbc:db1:test";
Connection conn=null;
ResultSet rs=null;
Statement stmt;
//定义打开数据库连接程序
public opendb(){
try {
Class.forName(sDBDriver);
}
//异常处理
catch(java.lang.ClassNotFoundException e){
System.err.println("opendb():"+e.getMessage());
}
}
//定义sql查询语句
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(SCon);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
//异常处理
catch(SQLException ex){
}
return rs;
};
public boolean executeUpdate(String sql)
{
try
{
conn=DriverManager.getConnection(SCon);
stmt=conn.createStatement();
conn.setAutoCommit(true);
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
return false;
}
return true;
}}
这个写法对马
先设ODBC数据源
然后在程序中
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = java.sql.DriverManager.getConnection(url, user, password);
我现在地问题,就是有两台机器,我这里装了客户端,对方的机器放着数据库
我建立了db1数据原,在这个数据原下面,有个数据库test 他下面有个city表我现在想访问他
对了用户名是sa 密码是password
jdk1.3下面不是有一个jdbc-odbc驱动程序马,我用这个来访问sqlserver数据库
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = java.sql.DriverManager.getConnection(url, user, password);
其中的url是什么东西
我现在想建立一个javabean来访问数据库
我该怎么样做啦,我不清楚,能够和我说说吗
package dBConn;
import java.sql.*;
public class nbbit_connect
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String sDBDrive = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@ll:1521:ll"; private String sUsername = "bit_user";/*登录数据库的用户名*/
private String sPassword = "bit_user";/*登录口令*/ public nbbit_connect()
{
try
{
Class.forName(sDBDrive);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database():"+e.getMessage());
}
}
public Statement dBConnect()
{
try
{
// Class.forName(sDBDrive);
con = DriverManager.getConnection(sConnStr,sUsername,sPassword);
stmt = con.createStatement (); }
catch(SQLException e)
{
System.err.println("database():"+e.getMessage());
}
return stmt;
} public Statement dBConnect_pages()
{
try
{
//Class.forName(sDBDrive);
con = DriverManager.getConnection(sConnStr,sUsername,sPassword);
stmt = con.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
catch(SQLException e)
{
System.err.println("database():"+e.getMessage());
}
return stmt;
} public PreparedStatement prepareStatement(String sql)/*可用于select处理*/
{
PreparedStatement PreSql = null;
try
{
PreSql = con.prepareStatement(sql);
}
catch(SQLException e)
{
System.err.println("database.executeQuery():"+e.getMessage());
}
return PreSql;
} public ResultSet executeQuery(String sql)/*可用于select处理*/
{
ResultSet rrs = null;
try
{
//con = DriverManager.getConnection(sConnStr,sUsername,sPassword);
//stmt = con.createStatement();
rrs = stmt.executeQuery(sql);
}
catch(SQLException e)
{
System.err.println("database.executeQuery():"+e.getMessage());
}
return rrs;
} public int executeUpdate(String sql)/*可用于insert,update处理*/
{
int rowCount = 0;
try
{
//con = DriverManager.getConnection(sConnStr,sUsername,sPassword);
//stmt = con.createStatement();
rowCount = stmt.executeUpdate(sql);
}
catch(SQLException e)
{
System.err.println("database.executeUpdate():"+e.getMessage());
}
return rowCount;
}
}