conn.java

JSP页面和oracle9i数据库的源代码

package beans;
import java.sql.*;
public class conn
{Connection con=null;
 Statement sql=null;
 ResultSet rs=null;
 String condition=null;
 public String setcondition(String newcondition)
 {condition=newcondition;
  try
  {Class.forName("oracle.jdbc.driver.OracleDriver");
   con=DriverManager.getConnection("jdbc:oracle:thin:@espfatcat:1521:mysw","BGZDH","sysman");
   sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  }
  catch(Exception e){return "连接数据库失败,请于网管联系";}
  return "数据库连接成功";
 }
 public ResultSet getrs()
 { try{rs=sql.executeQuery(condition);}
   catch(SQLException e){return rs=null;} 
   return rs;
 }
  public String update()
 { try{sql.executeUpdate(condition);}
   catch(SQLException e){return "更新失败,请于网管联系!";}
   return "更新成功";
 }
 public String toChinese()
 { try{
   byte b[]=condition.getBytes("ISO-8859-1");
   condition=new String(b);
   }
   catch(Exception e){return "转换文字格式失败,请于网管联系!";}
   return condition;
 }
}