Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.ctli.training.database.example;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class TestDatabase {
- public static void main(String[] args){
- Connection con=null;
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- } catch (ClassNotFoundException e) {
- System.out.println("Please add driver jar in classpath");
- }
- try{
- con=DriverManager.getConnection("jdbc:oracle:thin:@10.140.4.104:1578:training","training","enter_password_here");
- } catch (SQLException e){
- e.printStackTrace();
- }
- Statement stmt=null;
- try{
- stmt=con.createStatement();
- } catch(SQLException e){
- e.printStackTrace();
- }
- ResultSet rs=null;
- try{
- rs= stmt.executeQuery("select * from rishabh_login_data where uname='admin'");
- } catch(SQLException e){
- e.printStackTrace();
- }
- try{
- while(rs.next()){
- System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5));
- }
- } catch(SQLException e1){
- e1.printStackTrace();
- }
- try{
- con.close();
- } catch(SQLException e){
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement