我在this.gConnect = DriverManager.getConnection(lUrl, lUserName, lPassWord);
设置了保护。系统在次捕获了SQLException异常。
设置了保护。系统在次捕获了SQLException异常。
解决方案 »
- Unable to load configuration. - bean - jar:file:/C:/Program%20Files/Apache%20Sof
- 你们的struts是怎么学习的?我感觉自己学的太慢了!!!
- 帮我把 一个字符转换的asp方法 改长jsp的吧谢谢 急死我了,就20分了,
- 请各位大哥帮忙啊,老板要我在一个礼拜之内给公司做一个网站啊,急死我了!
- Jsp处理中文文件的问题
- servlet的错误
- 100份,求教,如何在jbuilder一个下,新建立一个包,然后把别的程序上的类导入使用
- [源码]医药管理系统中英文版本
- 关于httpservlet,为什么我import的时候总是出错。555555555
- 关于数据库插入的问题
- 同样的句子会出错????????
- 一个数据库连接问题
还有,又没有正常装入驱动程序。
用驱动应该是设在“sa用户名验证”的
//package
package InfoDatabase;
//import
import java.sql.*;public class OpenDatabase
{
//define connection string for db: jdbc.odbc bridge
String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=door.mdb";
//DSN=2004.mdb";
//
//String strurl = "jdbc:odbc:infodb";
Connection conn = null;
ResultSet rs = null;
Statement stmt;
//open database_connection
public OpenDatabase(){
try{
Class.forName(strDBDriver);
conn = DriverManager.getConnection( strurl, "", "" );
stmt = conn.createStatement();
// System.err.println("Opendb is visited.");
}
catch( java.lang.ClassNotFoundException e ){
System.err.println( "opendb(): " + e.getMessage() );
}
catch( java.sql.SQLException e1 ){
System.err.println( "aq.executeQuery: " + e1.getMessage() );
}
}
//execute sql query: select
public ResultSet executeQuery( String sql ){
rs = null;
try{
rs = stmt.executeQuery( sql );
}
catch( SQLException e ){
System.err.println( "aq.executeQuery: " + e.getMessage() );
}
return rs;
} //execute sql update: insert, delete
public boolean executeUpdate( String sql ){
try{
stmt.executeUpdate( sql );
return true;
}
catch( SQLException e ){
System.err.println( "aq.executeUpdate: " + e.getMessage() );
}
return false;
} //execute sql count: count
public int executeCount( String sql ){
rs = null;
try{
int nCount = 0;
rs = stmt.executeQuery( sql );
while( rs.next() ){
nCount ++;
}
return nCount;
}
catch( SQLException e ){
System.err.println( "aq.executeCount: " + e.getMessage() );
}
return -1;
} //end of class Opendb
public void close(){
try{
rs.close();
stmt.close();
}
catch( Exception e ){
System.err.println( e.toString() );
}
}
//destruction
public void finalize(){
try{
rs.close();
stmt.close();
conn.close();
}
catch( Exception e ){
System.err.println( e.toString() );
}
}
}
sun.jdbc.odbc.JdbcOdbcDriver
前提是先建一个数据源或者用第三方提供的JDBC驱动
第三方freetds
http://lists.ibiblio.org/pipermail/freetds/2001q3/004995.html
//package
package InfoDatabase;
//import
import java.sql.*;public class OpenDatabase
{
//define connection string for db: jdbc.odbc bridge
String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String strConnStr = "jdbc:odbc:INFODATABASE";
Connection conn = null;
ResultSet rs = null;
Statement stmt;
//open database_connection
public OpenDatabase(){
try{
Class.forName(strDBDriver);
conn = DriverManager.getConnection( strConnStr, "infodb", "infodb" );
stmt = conn.createStatement();
// System.err.println("Opendb is visited.");
}
catch( java.lang.ClassNotFoundException e ){
System.err.println( "opendb(): " + e.getMessage() );
}
catch( java.sql.SQLException e1 ){
System.err.println( "aq.executeQuery: " + e1.getMessage() );
}
}
//execute sql query: select
public ResultSet executeQuery( String sql ){
rs = null;
try{
rs = stmt.executeQuery( sql );
}
catch( SQLException e ){
System.err.println( "aq.executeQuery: " + e.getMessage() );
}
return rs;
} //execute sql update: insert, delete
public boolean executeUpdate( String sql ){
try{
stmt.executeUpdate( sql );
return true;
}
catch( SQLException e ){
System.err.println( "aq.executeUpdate: " + e.getMessage() );
}
return false;
} //execute sql count: count
public int executeCount( String sql ){
rs = null;
try{
int nCount = 0;
rs = stmt.executeQuery( sql );
while( rs.next() ){
nCount ++;
}
return nCount;
}
catch( SQLException e ){
System.err.println( "aq.executeCount: " + e.getMessage() );
}
return -1;
} //end of class Opendb
public void close(){
try{
rs.close();
stmt.close();
}
catch( Exception e ){
System.err.println( e.toString() );
}
}
//destruction
public void finalize(){
try{
rs.close();
stmt.close();
conn.close();
}
catch( Exception e ){
System.err.println( e.toString() );
}
}
}