Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.atos.java.jdbc;
- import java.sql.*;
- public class JDBCdemo {
- private static final String DB_URL= "jdbc:oracle:thin:@localhost:1521:xe";
- private static final String USER_ID = "hr";
- private static final String PASSWORD = "hr";
- public static void main(String[] args)
- {
- // TODO Auto-generated method stub
- //final String sql = "Select COUNTRY_ID, COUNTRY_NAME from COUNTRIES";
- final String sql1="update COUNTRIES set COUNTRY_NAME='Pakistan' where COUNTRY_ID = 'PK'";
- Connection conn= null;
- try
- {
- Class.forName("oracle.jdbc.OracleDriver");
- conn= DriverManager.getConnection(DB_URL, USER_ID, PASSWORD);
- Statement statement=conn.createStatement();
- statement.executeUpdate(sql1);
- Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
- ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT);
- final String sql = "Select COUNTRY_ID, COUNTRY_NAME from COUNTRIES";
- ResultSet result=statement.executeQuery(sql);
- result.next();
- ResultSetMetaData resultmd = result.getMetaData();
- int n = resultmd.getColumnCount();
- for(int i=1;i<=n;i++)
- {
- System.out.println(resultmd.getColumnName(i)+" "
- +resultmd.getColumnTypeName(i));
- }
- System.out.println(resultmd.getTableName(3));
- String id= result.getString("COUNTRY_ID");
- String name= result.getString("COUNTRY_NAME");
- System.out.println(id+" "+name);
- //while(result.next())
- // {
- // String id= result.getString("COUNTRY_ID");
- //String name= result.getString("COUNTRY_NAME");
- //System.out.println(id+" "+name);
- //}
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- catch(ClassNotFoundException e)
- {
- e.printStackTrace();
- }
- finally
- {
- try
- {
- conn.close();
- }
- catch(SQLException e)
- {
- e.printStackTrace();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement