liuyanben.zip_JDBC连接oracle_jsp_jsp oracle_oracle

package liuyan; import java.sql.*; public class jdbc { public jdbc() { } Connection conn = null ; String re = "" ; //设置你的数据库ip String dbip = "localhost" ; //设置你的数据库用户名和密码： String user = "jerry" ; String pass = "123456" ; public java.sql.Connection getConn(){ try{ Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url ="jdbc:oracle:thin:@"+dbip+":1521:ORACLE"; conn= DriverManager.getConnection(url,user,pass); } catch(Exception e){ e.printStackTrace(); } return this.conn ; } public String ex_chinese(String str){ if(str==null){ str ="" ; } else{ try { str = new String(str.getBytes("iso-8859-1"),"gb2312") ; } catch (Exception ex) { } } return str ; } public String gettime() { String datestr = "" ; try { java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy年MM月dd日 HH点ss分") ; java.util.Date date = new java.util.Date() ; datestr = df.format(new java.util.Date()) ; } catch (Exception ex) { } return datestr ; } }