import java.sql.*;
public class OracleConn
{
Connection conn;
public OracleConn()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String urlname = "jdbc:oracle:thin:@localhost:1521:hcm";
String user ="system";
String pw = "manager";
conn = DriverManager(urlname,user,pw).getConnection();
}
catch(Exception ep)
{
ep.printStackTrace();
conn = null;
}
}
public ResultSet getRS(String sql)
{
try
{
Statement stm = con.creatStatement();
ResultSet rs = stm.executeQuery(sql);
return rs;
}catch (Exception e)
{
e.printStackTrace();
return null;
}
}
public class OracleConn
{
Connection conn;
public OracleConn()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String urlname = "jdbc:oracle:thin:@localhost:1521:hcm";
String user ="system";
String pw = "manager";
conn = DriverManager(urlname,user,pw).getConnection();
}
catch(Exception ep)
{
ep.printStackTrace();
conn = null;
}
}
public ResultSet getRS(String sql)
{
try
{
Statement stm = con.creatStatement();
ResultSet rs = stm.executeQuery(sql);
return rs;
}catch (Exception e)
{
e.printStackTrace();
return null;
}
}