import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JavaConnectOracle
{
private static ResultSet rs = null;
private static PreparedStatement ps = null ;
private static Connection conn = null;
private static String username = "scott";
private static String password = "tiger";
public static void main(String[] args) throws SQLException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver"); //装载驱动
}
catch (ClassNotFoundException e)
{
System.out.println("注册失败");
}
try
{
//orcl是数据库名 username是数据库的用户 password是数据库用户的密码 1521是端口号 @localhost是贝蒂主机
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl",username,password);
}
catch (SQLException e)
{
System.out.println("建立连接失败");
}
try
{
ps = conn.prepareStatement("SELECT * FROM EMP"); //注意这边的SQL语句没有分号的!!!!!!
}
catch (SQLException e)
{
e.printStackTrace();
}
try
{
rs = ps.executeQuery();
}
catch(Exception e )
{
System.out.println("aaa");
}
System.out.println("编号 \t 姓名 \t 工资");
while(rs.next())
{
System.out.println(rs.getString("EMPNO") + "\t" + rs.getString("ENAME") + "\t" + rs.getString("SAL"));
}
if(null != rs )
{
rs.close();
}
if(null != ps)
{
ps.close();
}
if(null != conn)
{
conn.close();
}
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JavaConnectOracle
{
private static ResultSet rs = null;
private static PreparedStatement ps = null ;
private static Connection conn = null;
private static String username = "scott";
private static String password = "tiger";
public static void main(String[] args) throws SQLException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver"); //装载驱动
}
catch (ClassNotFoundException e)
{
System.out.println("注册失败");
}
try
{
//orcl是数据库名 username是数据库的用户 password是数据库用户的密码 1521是端口号 @localhost是贝蒂主机
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl",username,password);
}
catch (SQLException e)
{
System.out.println("建立连接失败");
}
try
{
ps = conn.prepareStatement("SELECT * FROM EMP"); //注意这边的SQL语句没有分号的!!!!!!
}
catch (SQLException e)
{
e.printStackTrace();
}
try
{
rs = ps.executeQuery();
}
catch(Exception e )
{
System.out.println("aaa");
}
System.out.println("编号 \t 姓名 \t 工资");
while(rs.next())
{
System.out.println(rs.getString("EMPNO") + "\t" + rs.getString("ENAME") + "\t" + rs.getString("SAL"));
}
if(null != rs )
{
rs.close();
}
if(null != ps)
{
ps.close();
}
if(null != conn)
{
conn.close();
}
}
}