问题补充:
加载错误!
失败
JAVA.SQL.SQLEXCEPTION: NO SUITABLE DRIVER FOUND FOR JDBC:SQLSERVER://LOCALHOST:1433;DATABASENAME=SYETEMZG
AT JAVA.SQL.DRIVERMANAGER.GETCONNECTION(DRIVERMANAGER.JAVA:602)
AT JAVA.SQL.DRIVERMANAGER.GETCONNECTION(DRIVERMANAGER.JAVA:185)
AT SYSTEMZG.DBCONN.CONN(DBCONN.JAVA:31)
AT SYSTEMZG.TEST.MAIN(TEST.JAVA:14)
Exception in thread "main" java.lang.NullPointerException
at systemZG.Test.main(Test.java:17)
代码一:
public class DBconn {
// private UserBean userBean;
protected Statement stmt;
protected ResultSet rs;
protected Connection conn;
public Connection conn() {
String driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;databaseName=SyetemZG";
String password = "123456";
String user1 = "wu12";
conn = null;
try {
Class.forName(driverClassName);
} catch (ClassNotFoundException ex) {
System.out.println("加载错误!");
}
try {
conn = DriverManager.getConnection(url, user1, password);
stmt=conn.createStatement();
System.out.println("成功");
} catch (SQLException ex1) {
System.out.println("失败");
StringWriter sw = new StringWriter();
PrintWriter pw = new PrintWriter(sw);
ex1.printStackTrace(pw);
System.out.println(sw.toString().toUpperCase());
}
return conn;
}
代码二:
package systemZG;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
DBconn con=new DBconn();
Statement stmt=null;
Connection conn = con.conn();
ResultSet rs=null;
try {
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT * FROM 职工基本信息 order by name");
} catch (SQLException e1) {
e1.printStackTrace();
}
try {
while(rs.next()) {
/*System.out.printf(rs.getString(1));
System.out.printf(rs.getString(2));
System.out.printf(rs.getString(3));
System.out.print(rs.getString(4));
System.out.printf(rs.getString(5)+"\n");
//System.out.printf(rs.getString(6));
*/}
} catch (SQLException e) {
e.printStackTrace();
}
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}