re: "java.lang.NoClassDefFoundError"錯誤——一個關于classpath設置的問題
2006-11-19 16:10 |
這是我拷的一個例子,在編譯的時候可以通過,但在執行的時候去總出現先您那樣的錯誤。不知如何解決。我是一個初學者還請您多多指點。
package stuman;
import java.io.*;
import java.sql.*;
public class sqlBean{///
public Connection conn=null;
public ResultSet rs=null;
private String DatabaseDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String DatabaseConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=educationi,'edu','edu'";
private String strcon = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=educationi";
private String strusr = "edu";
private String stupwd = "edu";
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(strcon,strusr,stupwd);
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("執行插入有錯誤:"+ex.getMessage() );
System.out.print("執行插入有錯誤:"+ex.getMessage());//輸出到客戶端
}
CloseDataBase();
return num;
}
// display data
public ResultSet executeQuery(String sql){
rs=null;
try{
conn = DriverManager.getConnection(strcon,strusr,stupwd);
Statement stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("執行查詢有錯誤:"+ex.getMessage() );
System.out.print("執行查詢有錯誤:"+ex.getMessage()); //輸出到客戶端
}
return rs;
}
// delete data
public int executeDelete(String sql){
int num=0;
try{
conn = DriverManager.getConnection(strcon,strusr,stupwd);
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 void CloseDataBase(){
try{
conn.close();
}
catch(Exception end){
System.err.println("執行關閉Connection對象有錯誤:"+end.getMessage( ) );
System.out.print("執行執行關閉Connection對象有錯誤:有錯誤:"+end.getMessage()); //輸出到客戶端
}
}
}
回復 更多評論