conndb.java

这是jsp论坛

package db;
import java.io.*;
import java.sql.*;
import javax.sql.*;
public class ConnDB{
	String sDBDriver= "sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr= "jdbc:odbc:DB";
	Connection connect = null;
	ResultSet rs = null;
	Statement stmt=null;
	public ConnDB(){
		try{
			Class.forName(sDBDriver);
		}catch( java.lang.ClassNotFoundException e){
			System.err.println( e.getMessage() );
		}
	}
	
	public ResultSet executeQuery( String sql ){
		try{
			connect = DriverManager.getConnection(sConnStr,"sa","1");
		    stmt = connect.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		   
			rs = stmt.executeQuery( sql );
		}catch( SQLException ex){
			System.err.println( ex.getMessage() );
		}
		
		return rs;
	}
	
	public int executeUpdate( String sql ){
		int result = 0;
		try{
			connect = DriverManager.getConnection(sConnStr);
			stmt = connect.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		    //stmt = connect.createStatement();
			result = stmt.executeUpdate( sql );
		}catch( SQLException ex){
			System.err.println( ex.getMessage() );
		}
		return result;
	}
	public void close(){
		try{
			
			if(rs!=null){
				rs.close();
			}
			if(stmt!=null){
				stmt.close();
			}
			if(connect!=null){
				connect.close();
			}
		}catch(Exception e){
			System.err.println(e.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-mm-dd hh:ss") ;
           java.util.Date date = new java.util.Date() ;
           datestr = df.format(new java.util.Date()) ;
        }
        catch (Exception ex) {
        }
        return datestr ;
    }
    
    	
}