记录----一个连接oracle的jdbc测试

有注意点哦

public static void main(String args[]) {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@13.52.165.21:1521/snstga";
			Connection c = DriverManager.getConnection(url, "root", "rootname");
			Statement stmt = c.createStatement();
			String sql = "select * from T_SOMP_FAVORITE_DESTINATION t where 1=1  and t.id='0001'";
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				// 注意这里re.getString
				System.out.println("ip: " + rs.getString("ip"));
			}
			stmt.close();
			c.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}