java oracle demo_jdbc for oracle demo

package com.huawei.oracle;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class OracleTest {

public static void main(String[] args) throws SQLException {

Connection conn = null;

PreparedStatement stmt = null;

ResultSet rs = null;

try {

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

conn = DriverManager.getConnection(

"jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");

stmt = conn.prepareStatement("select * from emp where deptno=?");

stmt.setInt(1, 10);

rs = stmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getInt("empno"));

System.out.println(rs.getString("ename"));

System.out.println(rs.getString("job"));

System.out.println(rs.getInt("mgr"));

System.out.println(rs.getDate("hiredate"));

System.out.println(rs.getInt("sal"));

System.out.println(rs.getInt("comm"));

System.out.println(rs.getInt("deptno"));

System.out.println("----------------------------");

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

finally

{

if(rs!= null) rs.close();

if(stmt!= null) stmt.close();

if(conn != null) conn.close();

}

}

}