import java.sql.*;public class conSql {
public static void main(String[] args) {
ResultSet rs;
Statement stmt;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); }
catch (ClassNotFoundException e){
System.out.print(" "+e);}
try{
String url="jdbc:microsoft:sqlserver://510B1209F7E9460;DatabaseName=asset";
String user="asset";
String password="asset00";
Connection conn= DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();
String sql="select * from password";
rs=stmt.executeQuery(sql);
while(rs.next()) {
String name =rs.getString(1);
String number=rs.getString(2);
System.out.println("name"+name);
System.out.println("number"+number);
}
rs.close();
stmt.close();
conn.close();
}
catch (SQLException e){} }
}
在JSP中运行可以通过 为什么在JAVA 文件中却报错。
elipse3.1 WindowsXp 2
错误信息:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
哪错了?
TO: baoxiaozhe(飘扬的旗帜)
爱死你了
THANK YOU!
解决了!
?
而是把JDBC的三个驱动包直接放到jdk安装目录下的JRE\LIB\EXT下
谁知道?
THANK YOU!
又学一招