lunzi

现在要用oracle了,储备点以备后用.
package dbbean;
import java.sql.*;
public class ContactBean
{
 private Connection con;
 //初始化连接。
 public ContactBean()
 {
        
  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   String url="jdbc:oracle:thin:@localhost:1521:hcm"; 
         String user="jspdev"; 
         String password="19831007"; 
         con= DriverManager.getConnection(url,user,password); 
  }
  catch (InstantiationException e)
  {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e)
  {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } 
  catch(ClassNotFoundException e)
   {
    System.out.println("DRIVER NOT FOUND!");
    con=null;
   }
  catch(SQLException e)
   {
    con=null;
   }
    
 }
 //查询数据库
 public  ResultSet getContact(String id)
 {
  try
  {
   Statement stm=con.createStatement();
   ResultSet result=stm.executeQuery("select * from student where id='"+id+"'");
   return result;
  }
  catch(Exception e)
  {
  }
  return null;
 }
}