java 连接oracle数据库

.1.下载ojdbc14.jar包

package dateconverttool;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class OracleConn  {
//dbUrl数据库连接串信息，其中“1521”为端口，“orcl”为sid 
String dbUrl = "jdbc:oracle:thin:@127.185.51.78:1500:orcl"; 
//String dbUrl = "jdbc:oracle:thin:@localhost:1521:orcl"; 
//theUser为数据库用户名 
String theUser = "mhjy"; 
//thePw为数据库密码 
String thePw = "mhjy"; 
//几个数据库变量 
Connection c = null; 
Statement conn; 
ResultSet rs = null; 
//初始化连接 
public OracleConn() 
{ 
try
{ 
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
//与url指定的数据源建立连接 
c = DriverManager.getConnection(dbUrl, theUser, thePw); 
//采用Statement进行查询 
conn = c.createStatement(); 
} 
catch (Exception e)
{ 
e.printStackTrace(); 
} 
} 
public ResultSet executeQuery(String sql) 
{ 
rs = null; 
try { 
rs = conn.executeQuery(sql); 
} 
catch (SQLException e)
{ 
e.printStackTrace(); 
} 
return rs; 
} 
public void execute(String sql) 
{ 

try { 
conn.execute(sql);
} 
catch (SQLException e)
{ 
e.printStackTrace(); 
} 

} 
public void close() 
{ 


try { 
conn.close(); 
c.close(); 
} 
catch (Exception e) 
{ 
e.printStackTrace(); 
} 
} 
}