jdbc

 

package org.bluedot.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import org.bluedot.model.ClasDM;
import org.bluedot.model.StudentDM;

public class DBCon {
  private static Statement st;
  private static ResultSet rs;
  private static Connection con;
  
  private static void OpenCon()
  {
   try {
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","admin");
   } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  
  private static void CloseCon()
  {
    try {
     if(con!=null)
     {
      con.close();
      con=null;
     }
     if(st!=null)
     {
      st.close();
      st=null;
     }
     if(rs!=null)
     {
      rs.close();
      rs=null;
     }
    } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
  }
  
  //select * from sview;
  public static  ArrayList<StudentDM> getManyStudents(String sql)
  {
   ArrayList<StudentDM> slist = new ArrayList<StudentDM>();
   OpenCon();
   try {
    st = con.createStatement();
    rs = st.executeQuery(sql);
    while(rs.next())
    {
     StudentDM sm = new StudentDM();
     sm.setSid(rs.getInt(1));
     sm.setSname(rs.getString(2));
     sm.setSage(rs.getInt(3));
     sm.setJg(rs.getString(4));
     sm.getCm().setCname(rs.getString(5));
     slist.add(sm);
    }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   CloseCon();
   return slist;
  }
  
  //select * from clas
  public static ArrayList<ClasDM> getManyClas(String sql)
  {
   ArrayList<ClasDM> clist = new ArrayList<ClasDM>();
   OpenCon();
   try {
    st = con.createStatement();
    rs = st.executeQuery(sql);
    while(rs.next())
    {
     ClasDM cm  =  new ClasDM();
     cm.setCid(rs.getInt(1));
     cm.setCname(rs.getString(2));
     clist.add(cm);
    }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   CloseCon();
   return clist;
  }
  
  public static void exeucteNOQuery(String sql)
  {
   OpenCon();
   try {
    st = con.createStatement();
    st.execute(sql);
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   CloseCon();
  }

public static Object getOne(String sql)
  {
   Object  obj = new Object();
   OpenCon();
   try {
    st = con.createStatement();
    rs = st.executeQuery(sql);
    rs.next();
    obj = rs.getObject(1);
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   CloseCon();
   return obj;
  }
}