【求助】
本人初学JAVA,主要想学JAVA WEB端开发,现在写代码如下,想测试数据库是否连通,但是出现报错,望大家帮忙看看。
我的代码:
package tool;
import java.sql.*;
public class ConnectDB {
public Connection conn=null;
public Statement stmt=null;
public ResultSet rs=null;
private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String URL="jdbc:sqlserver://localhost:1433;DatabaseName=khzl";
private static String user="sa";
private static String password="1";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(URL, user, password);
if(!conn.isClosed()){
System.out.println("Succeeded connecting DB");
}
}
catch (Exception ee){
ee.printStackTrace();
}
if (conn == null) {
//System.err.println("Wrong user password");
}
return conn;
}
public ResultSet executeQuery(String sql) { //sql query as an argument
try {
conn = getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch (SQLException ex){
System.out.println(ex.getMessage());
}
//System.out.println(sql);
return rs; //return result
}
public void close() {
try {
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String args[]){
getConnection();
}
}
-----------------------------------------------------------RUN ON SERVER 后(用的是tomcat9.0)-----------------------------
查过网上资料,404一般是路径错误,但是我手工输成正确的路径,还是报错如上,请高手指教!