import java.sql.*;
public class UsersAccess {
private Connection conn=null;
private Statement stmt;
private ResultSet userSet=null;
private String connStr="jdbc:oracle:OCI8@192.168.0.114:1521:PHOTO";
private String username="SYSTEM";
private String password="admin";
private String sDBDriver="oracle.jdbc.driver.OracleDriver";
public UsersAccess(){
}
public ResultSet GetUserList(String queay)
throws SQLException,java.lang.ClassNotFoundException{
try{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(connStr,username,password );
stmt=conn.createStatement();
userSet=stmt.executeQuery(queay);
return userSet;
}
注:红色部分表示URL,该URL是无效的,检查一下URL是否写对。