a0beeb96b878001c184b9f13fa0b0754

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

package javabeans;
import java.io.*;
import java.sql.*;

public class Dbcon 
{
  private Connection con=null;
  private String user=null;
  private String password=null;
  private String url=null;
  private ResultSet rs=null;
  public Dbcon(url,user,password)
  {   
	  try 
      {
          Class.forName("com.microsoft.jdbc.splserver.SQLServerDriver").newInstance();
          con = DriverManager.getConnection(url,user,password);
      } catch(Exception ex)
      {
          System.out.println(ex.toString());
      }  
  }
  public Connection getConnection()
  {
      if(con == null)
          BulidConnection();
      return con;
  }
  public void close()
  {
      try
      {
          con.close();
          con = null;
      } catch(SQLException ex){}
  }
  public ResultSet executeQuery(String sql)
  {
	  try
	  {
		  Statement stmt=con.createStatement();
		  rs=stmt.executeQuery(sql);
	  }
	  catch(SQLException ex)
	  {
		  System.err.println(ex.getMessage());
	  }
	  return rs;
  }
  public ResultSet executeUpdate(String sql)
  {
	  try
	  {
		  Statement stmt=con.createStatement();
		  rs=stmt.executeQuery(sql);
	  }
	  catch(SQLException ex)
	  {
		  System.err.println(ex.getMessage());
	  }
	  return rs;
  }
}