jdbc

     import java.sql.*;
import java.util.ArrayList;
public class Testjdbc {
 
 public Testjdbc(){
  
 }
 
 public Connection connection=null;
 public Statement statement=null;
 public ResultSet resultSet=null;
 
 public Connection getConnection(){
  String url="jdbc:oracle:thin:@localhost:1521:oracle";
  String user="system";
  String password="oracle";
  String driverName="oracle.jdbc.driver.OracleDriver";
  try{
   Class.forName(driverName);
   connection=DriverManager.getConnection(url,user,password);
  }catch (Exception e) {
   // TODO: handle exception
  }
  
  return connection;
 }
 
 public int add(String sql){
  int result=-1;
  try{
   connection=getConnection();
   statement=connection.createStatement();
   result=statement.executeUpdate(sql); 
  }catch (Exception e) {
   // TODO: handle exception
  }
  return result;
 }
 
 public int delete(String sql){
  int result=-1;
  try{
   connection=getConnection();
   statement=connection.createStatement();
   result=statement.executeUpdate(sql); 
  }catch (Exception e) {
   // TODO: handle exception
  }
  return result;
  
 }
 
 public ArrayList select(String sql){
  ArrayList arrayList=new ArrayList();
  connection=getConnection();
  try{
   statement=connection.createStatement(); 
   resultSet=statement.executeQuery(sql);
   while (resultSet.next()) {
    Student student=new Student();
    student.setStudentid(resultSet.getInt("id"));
    student.setName(resultSet.getString("name"));
    student.setSex(resultSet.getString("sex"));
    student.setFromdate(resultSet.getDate("fromdate"));
    arrayList.add(student);
   }
  }catch (Exception e) {
   // TODO: handle exception
  }
  return arrayList;
 }
 
 public void close(){
  
  try{
   if(resultSet!=null){
    resultSet.close();
    if(statement!=null){
     statement.close(); 
     if(connection!=null){
      connection.close();
     }
   } 
  } 
}catch (Exception e) {
 // TODO: handle exception
}
  
  
 }
public static void main(String args[]){
 Testjdbc testjdbc=new Testjdbc();
 String sql="select * from student";
 ArrayList arrayList=new ArrayList();
 arrayList=testjdbc.select(sql);
 for(int i=0;i<arrayList.size();i++){
  Student student=(Student)arrayList.get(i);
  System.out.println(student.getStudentid());
  System.out.println(student.getName());
  System.out.println(student.getSex());
  System.out.println(student.getFromdate());
 }
}
}