为什么我把数据库连接写到javabean里回出错?
朋友别哭 2004-06-16 11:11:29 连接的是SQL2000.把驱动程序和连接写在JSP是可以的.但是放在javabean里就出错
package db;
import java.sql.*;
public class SQLBridge
{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db";
String userID ="sa";
String passwd="";
Connection con;
Statement stmt;
ResultSet rs;
public SQLBridge(){}
public String conn()
{
try
{
Class.forName(driverName).newInstance();
return "驱动加载成功!";
}
catch(Exception e)
{
e.printStackTrace();
return "驱动加载失败!";
}
}
public String select()
{
try
{
con=DriverManager.getConnection(url,userID,passwd);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from tbl");
// while (rs.next())
// {
// rs.getString(3);
// rs.getString(4);
// rs.getString(5);
// }
rs.close();
stmt.close();
con.close();
return "数据库连接成功!";
}
catch(SQLException e)
{
return "连接数据库错误"+"SQLExcception:"+e.getMessage();
}
}
public static void main(String args[])
{
SQLBridge some=new SQLBridge();
some.conn();
some.select();
}
}
运行了一下提示是:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at db.SQLBridge.conn(SQLBridge.java:19)
at db.SQLBridge.main(SQLBridge.java:55)