我编写的类如下:
import java.sql.*;
public class Access1 {
private Connection conn;
private Statement stmt;
private ResultSet rs;
private int rscount=0;
/**
*构造函数(连接数据库)
*@param 1用户名称:username 2 用户密码:pass
*@return exception
*@exception SQLException
*@author sun
*/
public Access1(){}
public Access1(String username,String pass) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch (Exception se) {
se.printStackTrace();
}
String url =
"jdbc:microsoft:sqlserver://202.113.121.35:1433;DatabaseName=SAT";
try {
conn = DriverManager.getConnection(url, username, pass);
}
catch (SQLException se) {
se.printStackTrace();
}
}
/**
* 执行数据库查询select语句
* @param sql
* @return resultset
* @throws SQLException
*@author sunyuanyuan
*/
public String executeQuery() throws SQLException{
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE ) ;
String selectsql="select * from BookView where Subject=english"; String printstr="";
Access1 db=new Access1("sa","sa");
ResultSet result;
try{
result=stmt.executeQuery(selectsql);
int count=0;
while(result.next() ){
result.next() ;
count++;
}
// java.sql.ResultSetMetaData meta=result.getMetaData(); System.out.print("subject=englist 的纪录有"+count);
printstr="subject=englist 的纪录有"+count;
}catch(SQLException e){
e.printStackTrace() ;
}
return printstr;
} public static void main(String args[]){
try{ Access1 db=new Access1("sa","sa");
System.out.println("---------"+db.executeQuery());
}catch(SQLException e){
e.printStackTrace() ;
}
}
}
但是在cmd下编译成功了,可是运行 java -classpath d:\jws\ Access1 时,他报错java.lang.ClassNotFoundException com.microsoft.jdbc.sqlserver driver
我已经在jdk1.4.2\lib下添加了包mssqlserver.jar,msbase.jar了 在 环境变量里classpath增加了这个路径
各位大侠 请问怎么解决呢
import java.sql.*;
public class Access1 {
private Connection conn;
private Statement stmt;
private ResultSet rs;
private int rscount=0;
/**
*构造函数(连接数据库)
*@param 1用户名称:username 2 用户密码:pass
*@return exception
*@exception SQLException
*@author sun
*/
public Access1(){}
public Access1(String username,String pass) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch (Exception se) {
se.printStackTrace();
}
String url =
"jdbc:microsoft:sqlserver://202.113.121.35:1433;DatabaseName=SAT";
try {
conn = DriverManager.getConnection(url, username, pass);
}
catch (SQLException se) {
se.printStackTrace();
}
}
/**
* 执行数据库查询select语句
* @param sql
* @return resultset
* @throws SQLException
*@author sunyuanyuan
*/
public String executeQuery() throws SQLException{
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE ) ;
String selectsql="select * from BookView where Subject=english"; String printstr="";
Access1 db=new Access1("sa","sa");
ResultSet result;
try{
result=stmt.executeQuery(selectsql);
int count=0;
while(result.next() ){
result.next() ;
count++;
}
// java.sql.ResultSetMetaData meta=result.getMetaData(); System.out.print("subject=englist 的纪录有"+count);
printstr="subject=englist 的纪录有"+count;
}catch(SQLException e){
e.printStackTrace() ;
}
return printstr;
} public static void main(String args[]){
try{ Access1 db=new Access1("sa","sa");
System.out.println("---------"+db.executeQuery());
}catch(SQLException e){
e.printStackTrace() ;
}
}
}
但是在cmd下编译成功了,可是运行 java -classpath d:\jws\ Access1 时,他报错java.lang.ClassNotFoundException com.microsoft.jdbc.sqlserver driver
我已经在jdk1.4.2\lib下添加了包mssqlserver.jar,msbase.jar了 在 环境变量里classpath增加了这个路径
各位大侠 请问怎么解决呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货