java直接用jdbc操作oracle数据库

第一步：将ojdbc6.jar加入到项目属性Java Build Path的Libraries中，此jar在安装oracle的目录下

第二步：java代码

public class jdbcCon {

	private Connection con = null;
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		jdbcCon jdbccon = new jdbcCon();
		Connection conn = jdbccon.getCon();
		if(conn != null)
		{
			System.out.println("conncet success");
		}
		else
		{
			System.out.println("connect failed");
		}

		jdbccon.getData();

	}

	public Connection getCon()
	{
		try{
			Class.forName("oracle.jdbc.OracleDriver");
		}catch(ClassNotFoundException e){
			System.out.println("load driver failed");
		}

		try{
			con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE",
					"user",
					"password");
		}catch(SQLException e){
			System.out.println(e.toString());
		}

		return con;
	}

	public void getData()
	{
		if(con == null)
		{
			return;
		}
		Statement sql;
		try {
			sql = con.createStatement();
			ResultSet ret = sql.executeQuery("select * from RCNUMBERS");
			while(ret.next())
			{
				String num = ret.getString(1);
				System.out.println(num);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}



	}
}