Tip2: How to execute query

Example file name: PROJECT1.java

import java.sql.*;

…

public class PROJECT1 {

Connection conn=null;

Statement stmt=null;

String tName = "";

String aName = "";

String iName = "";

…

public PROJECT1() {

DBConnection();

insertData();

…

}

public void DBConnection(){

String url = "jdbc:oracle:thin:@omega.uta.edu:1521:CSE1";

// URL = type of DBMS + address of sever + port + SID

String db_id="your ID";

String db_pwd="your Oracle Password";

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

conn=DriverManager.getConnection(url, db_id, db_pwd);

// JDBC manager tries to connect

System.out.println("Successful Conncetion to ORACLE");

}catch(ClassNotFoundException e){

System.out.println("LOADING ERROR:"+e.toString());

}catch(SQLException se){

System.out.println("FAIL OF DB CONNECTION : "+se.toString());

}

}

public void insertData(){

try{

stmt=conn.createStatement();

String sql=" INSERT INTO employee VALUES

('James', 'E', 'Borg', '888665555', '10-NOV-27', '450 Stone,Houston,TX', 'M', 55000, null, 1)”;

ResultSet rs=stmt.executeQuery(sql);

rs.close();

stmt.close();

}catch(Exception ex){}

}

…

}