jdbc.java

jsp+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 ;
  }
}