00221f8b6c84001c19739512d9660e50

一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现

package bb;

import java.sql.*;
import java.io.*;

public class Dbcon 
{
  Connection con=null;
  public void Conn()
  {
	  try 
      {
          Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
          con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.102:1521;DatabaseName=sumarket","sbt","111");
      } catch(Exception ex)
      {
          System.out.println(ex.toString());
      }  
  }
  public Connection getConn()
  {
	  if(con==null)
		  Conn();
	  return con;
  }
  public void Close()
  {
      try
      {
    	  con.close();
          con = null;
      } catch(SQLException ex){}
  }
}