jdbc连接问题，新手提问！！！
//我的数据库连接类：（main()用于测试）
package bookshop;
import java.sql.*;
import java.io.*;
public class DBConn
{
//String sDBDriver= "com.microsoft.jdbc.sqlserver.SQLServerDriver ";
String sDBDriver= "net.sourceforge.jtds.jdbc.Driver ";
//String sConnStr= "jdbc:microsoft:sqlserver://192.168.150.190:1433;DatabaseName=bookshop ";
String sConnStr= "jdbc:jtds:sqlserver://192.168.150.190:1433/bookshop ";
private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null;
public DBConn()
{
try
{//注册数据库驱动程序
Class.forName(sDBDriver);
System.out.println( "Success loading Mysql Driver! ");
}
//catch(java.lang.ClassNotFoundException e)
//{
//System.err.println(e.getMessage());
//}
catch(Exception e)
{
System.out.print( "Failed to load driver! ");
e.printStackTrace();
}
}
//建立数据库连接及定义数据查询
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr, "sa ", "sa ");//创建数据库联接对象
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println( "aq.executeQuery: "+ex.getMessage());
}
return rs;
}
//定义数据操作
public void executeUpdate(String sql)
{
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr, "sa ", " ");//创建数据库联接对象
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ee)
{
System.err.println( "aq.executeUpdate: "+ee.getMessage());
}
}
//关闭数据库联接
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void main(String arg[])
{
String userid= "sjl ";
String password= "sjl ";
try
{
DBConn dbConn=new DBConn();
String sql= "select * from [users] where USER_ID= ' "+userid+ " ' and USER_PASSWORD= ' "+password+ " ' ";
ResultSet rs=dbConn.executeQuery(sql);
if(rs.next())
{
System.out.println( "Successful! ");
}
}
catch(SQLException e)
{
System.out.print(e);
}
}
}
---------------------------------------------------
eclipse下debug出现如下错误：
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at bookshop.DBConn. <init> (DBConn.java:18)
at bookshop.DBConn.main(DBConn.java:95)
aq.executeQuery:No suitable driver
[解决办法]
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
//你没有把jtds的jar包加进你的工程 在你的工程的Properties-> Java Build Path-> Libraries-> Add External JARs
[解决办法]
smyl9989(小新:小白,挠小鸡鸡...) 说得对，你的驱动包没有导入
