JDBC连接到Oracle数据库的小demo

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();
}






}

}