dbcon.java

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

package bb;

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

public class Dbcon 
{
  Connection con=null;
  ResultSet rs=null;

  public Connection getConn()
  {
	  try{
	  Class.forName("oracle.jdbc.driver.OracleDriver");
      con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:smarket","tpb","111");
	  return con;
	  }
	  catch(Exception e){
		  return con;
	  }
  }
  public void Close()
  {
      try
      {
    	  con.close();
          con = null;
      } catch(SQLException ex){}
  }
  public String getStr(String str)//返回中文字符
	{
	    try
		  {
	        String temp_p = str;
			    byte[] temp_t = temp_p.getBytes("ISO8859-1");
			    String temp = new String(temp_t,"gb2312");
			    return temp;
		  }
		      catch(Exception e)
		  {
		      return null;
		  }
	}
}