帮帮我啊为什么总报java.sql.SQLException: No suitable driver异常？

0 0

帮帮我啊为什么总报java.sql.SQLException: No suitable driver异常？25

[align=center][/align]package jdbcts;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcTest {
public static void main(String[] args) {
String ClassForName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String DriM="jdbc:microsoft:sqlsever://localhost:1433;DatabaseName=jdbc";

String username="sa";
String password="sasa";

//1-加载数据库驱动类
try {
Class.forName(ClassForName);

} catch (ClassNotFoundException e) {
System.out.println("无法找到驱动类");
}
//2-建立指定数据库的连接
Connection conn=null;
try {
conn=DriverManager.getConnection(DriM,username,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

Statement st=null;
try {

st=conn.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String sql="select * from userinfo";
ResultSet rs=null;
try {
rs=st.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//5-解析结果集对象
try {
while (rs.next()) {
int id = rs.getInt(1);
String name = rs.getString("user_name");
String pass = rs.getString("user_password");
System.out.println(id + "\t" + name + "\t"+pass);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}
总是报这样的异常
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlsever://localhost:1433;DatabaseName=jdbc
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at jdbcts.JdbcTest.main(JdbcTest.java:32)
Exception in thread "main" java.lang.NullPointerException
at jdbcts.JdbcTest.main(JdbcTest.java:41)

三个驱动类我已经打了，并且SP4补丁也打了。我重新装了系统也不行 XP4的系统

DAO