package com.west163.wlywest.test;
import java.sql.*;public class JdbcCon{
public JdbcCon(){
}

public java.sql.ResultSet ExcuteSQL(String sSQL){
java.sql.ResultSet res;

res = null;
try{
System.out.println("Registering JDBC driver...");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("Connecting to the database...");
Connection jdbclink = DriverManager.getConnection("jdbc:oracle:thin:@uisqds029:1521:orcl","system","manager");
System.out.println("Connect OK...");
Statement stament = jdbclink.createStatement();
System.out.println("Executing Query...");
res = stament.executeQuery(sSQL);
}
catch(SQLException ex){
}
return res;
}
}