jsp连接oracle（javabean）

最新推荐文章于 2022-09-22 23:14:48 发布

hntyzgn2010

最新推荐文章于 2022-09-22 23:14:48 发布

阅读量951

点赞数

文章标签： oracle jsp string exception null jdbc

本文链接：https://blog.csdn.net/hntyzgn2010/article/details/5540532

版权

package DBbean;
import java.sql.*;
public class ConnBean
{
private Connection con;
//初始化连接。
public ConnBean()
{

  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   String url="jdbc:oracle:thin:@localhost:1521:orcl";
         String user="scott";
         String password="tiger";
         con= DriverManager.getConnection(url,user,password);
  }
  catch (InstantiationException e)
  {
      e.printStackTrace();
  } catch (IllegalAccessException e)
  {
      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;
}
}