package db;
import java.sql.*;
public class ConnSQL {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ghyghost";
String user = "sa";
String password = "";
Connection connect = null;
ResultSet rs = null; public ConnSQL() {
try {
Class.forName(sDBDriver);
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
connect = DriverManager.getConnection(url, user, password);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
} public int executeUpdate(String sql) {
int result = 0;
try {
connect = DriverManager.getConnection(url, user, password);
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}
}
import java.sql.*;
public class ConnSQL {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ghyghost";
String user = "sa";
String password = "";
Connection connect = null;
ResultSet rs = null; public ConnSQL() {
try {
Class.forName(sDBDriver);
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
connect = DriverManager.getConnection(url, user, password);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
} public int executeUpdate(String sql) {
int result = 0;
try {
connect = DriverManager.getConnection(url, user, password);
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}
}
我重启一下ECLIPSE看看
第三行的话,那就是public class ConnSQL中的类名与文件名不一致造成的.