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