//我的数据库连接类：（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)