jdbc.java

论坛元程序

package yy;
import java.io.*;
import java.sql.*;
public class jdbc {
	
 public jdbc() { }
 Connection conn = null ;
 ResultSet rs=null;
 Statement stmt=null;
 
 public java.sql.Connection getConn(){
    try{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
     conn= DriverManager.getConnection("jdbc:odbc:yyForum","lixu","810215");
  	
	}
    catch(Exception e){
    e.printStackTrace();
    System.out.println("LICHAO");
    }
    return this.conn ;
  }
  
  public ResultSet executeQuery(String sql)
  {
  	try{
    conn=getConn();
    stmt=conn.createStatement();
    rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{System.out.println(ex.getMessage());}
return rs;
  	}

  public void executeUpdate(String sql)
  {
  	try{
    conn=getConn();
    stmt=conn.createStatement();
    stmt.executeUpdate(sql);
}
catch(SQLException ex)
{System.out.println(ex.getMessage());}
}

 public void closeConn()
 {
 	try{
 	if(rs!=null)
 	rs.close();
 	if(stmt!=null)
 	stmt.close();
 	if(conn!=null)
 	conn.close();
}
catch(SQLException ex)
{System.out.println(ex.getMessage());}
}

  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-M-d HH:ss") ;
    java.util.Date date = new java.util.Date() ;
    datestr = df.format(new java.util.Date()) ;
    }
    catch (Exception ex) {
    }
    return datestr ;
  }
}