/**************2004-04-21**************from wj*/ /*****oracle数据库接口***********/ package CMCC; import java.sql.*; import java.util.*; import java.text.*; import java.io.*; import oracle.jdbc.driver.*;
public class jdbc_oracle_test { /* public static void main( String args[] ){ jdbc_oracle db = new jdbc_oracle(); String Str; int id; ResultSet re = null; re = db.query("select * from test"); try{ int i=0; while(re.next() && i<10){ Str = re.getString("id"); System.out.println(Str); i++; } } catch(Exception e){ System.out.println("error!"); } db.closestmt(); db.closeconn(); } //*/ //String conn_str="jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=test";//---------数据库 String conn_str="jdbc:oracle:thin:@127.0.0.1:1521:test"; String username="test";//---------------数据库用户名 String password="test";//-------------数据库密码 private Connection conn=null; private Statement stmt=null; ResultSet rs=null; //----------------------数据库链接---------------- public jdbc_oracle_test() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch(java.lang.ClassNotFoundException e) {System.err.println("dbclass():"+e.getMessage());} try { conn=DriverManager.getConnection(conn_str,username,password); } catch(SQLException ex) { System.err.println("dbclass():"+ex.getMessage());} } //---------------------取得数据库连接------------- public Connection getConn() { return conn; } //---------------------数据库查询-----------------
public ResultSet query(String sql) { try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql);} catch(SQLException ex) {System.err.println("query():"+ex.getMessage());} return rs; } //－－－－－－－－－－－数据库修改－－－－－－－－－ public void update(String sql) { try { stmt=conn.createStatement(); stmt.executeUpdate(sql);} catch(SQLException ex) {System.err.println("update():"+ex.getMessage());} } //－－－－－－－－－－关闭数据源－－－－－－－ public void closestmt() { try{stmt.close();} catch(SQLException ex) {System.err.println("closestmt():"+ex.getMessage());} } //－－－－－－－－－－关闭链接－－－－－－－－－ public void closeconn() { try{conn.close();} catch(SQLException ex) {System.err.println("closeconn()"+ex.getMessage());} } //---------------------转换中文 public String toChinese(String s) { if(s==null) return null; try { String convert=new String(s.getBytes("ISO8859-1"),"gb2312"); return convert; } catch(Exception e){} return null; } //--------------------分页 public String page1(int num,int line,int page_line,int start,int page,String search,String filename) { int pagetotal=line*page_line;//所要显示的总条数 int pagestart;// int pagenum;// int total=(num-start+line-1)/line;//取得总页数 int total_start=(num+pagetotal-1)/pagetotal;//取得总偏移数 String returnstr=""; if(start!=0) { int old_start=start-pagetotal; returnstr+=" <a href="+filename+"?page=0&start="+old_start+search+"><<</a>"; } pagestart=start/pagetotal*page_line;//取得当前页数 for(int i=0;i<total&&i<page_line;i++) { pagenum=pagestart+i+1; returnstr+=" <a href="+filename+"?page="+i+"&start="+start+search+">"+pagenum+"</a>"; } if(total_start!=(start/pagetotal+1)&&num!=0) { int new_start=start+pagetotal; returnstr+=" <a href="+filename+"?page=0&start="+new_start+search+">>></a>"; } return returnstr; }
//-------------------------------取得时间 public String GetPath() { String dateString="123"; try { java.text.SimpleDateFormat formatter=new java.text.SimpleDateFormat("yyyy-MM"); java.util.Date currentTime_1=new java.util.Date(); dateString=formatter.format(currentTime_1); } catch(Exception e) { } return dateString; }
//-------------------------------取得时间 public String strNowtime() { String dateString="123"; try { java.text.SimpleDateFormat formatter=new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); java.util.Date currentTime_1=new java.util.Date(); dateString=formatter.format(currentTime_1); } catch(Exception e) { } return dateString; }
//--------------------------去掉html--------------------------- public String HTMLEncode(String Str) { Str=ebbReplace(Str,"<","<"); Str=ebbReplace(Str,">",">"); Str=ebbReplace(Str,"\n","<BR>"); return Str; } //--------------------------替换变量--------------------------- public String ebbReplace(String Str,String oldStr,String newStr) { String ReturnStr=""; int i,j,t,m,n; n=0; j=oldStr.length(); if (Str.indexOf(oldStr)>-1) { while(Str.indexOf(oldStr,n)>-1) { i=Str.length(); if (Str.indexOf(oldStr)==0) Str=newStr+Str.substring(j,i); else { t=Str.indexOf(oldStr); m=(t+j); Str=Str.substring(0,t)+newStr+Str.substring(m,i); n=t+newStr.length()-j+1; } } } ReturnStr=Str; return ReturnStr; } //----------------------------ubb替换-------------------------- public String LCReplace(String Str,String BStr,String EStr,String ReStr) { String ReturnStr="",Str1="",Str2=""; int i,j,n; n=0; if ((Str.indexOf(BStr)>-1)&&((Str.indexOf(EStr)>-1))) { while(Str.indexOf(BStr,n)>-1) { i=Str.indexOf(BStr); j=Str.indexOf(EStr); Str1=Str.substring((i+BStr.length()),j); Str2=ebbReplace(ReStr,"$lichao$",Str1); Str1=BStr+Str1+EStr; Str=ebbReplace(Str,Str1,Str2); n=i+Str2.length()-Str1.length(); } } ReturnStr=Str; return ReturnStr; } }
|
