jdbcodbcconn.java

是一个电子词典

package SqlConnection;
import java.sql.*;

public class JdbcOdbcConn {
	//驱动程序名
	String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	public String conn="jdbc:odbc:aa";
	Connection constr=null;
	Statement stmt;
	ResultSet rs;
//......................................................................
//----------------用JdbcOdbcConn构造函数与数据库进行连接---------------------
	public JdbcOdbcConn(){	
		stmt=null;
	    try{		
		//加载数据库驱动程序
		Class.forName(DBDriver);
		constr=DriverManager.getConnection(conn,"","");
	    }catch(SQLException en){
	    	System.out.println(en.toString());
	    }catch(java.lang.ClassNotFoundException ev){
		System.err.println("DBconnection():"+ev.getMessage());
	    }
	 }//end JdbcOdbcConn 
	
//........................................................................
//------------------执行查询语句，返回结果集-----------------------------------
	public ResultSet exeSql(String sql){
		try{
			stmt=constr.createStatement();
			rs=stmt.executeQuery(sql);	
		}catch(Exception ee){
			System.out.println(ee.toString());
			return null;
		}
		return rs;
	}//end of exeSql
	
//	........................................................................
//	------------------执行插入语句---------------------------------------------
	public void InsertSql(String sql){
		try{
			stmt=constr.createStatement();
			int i=stmt.executeUpdate(sql);
			System.out.println("+++++++"+i);
		}catch(Exception ee){
			System.out.println(ee.toString());			
		}
	}//end of InsertSql
	
//........................................................................
//------------------执行修改词条语句-----------------------------------－－－－	－－－	
		public void UpdateSql(String sql){
			try{
				stmt=constr.createStatement();
				int i=stmt.executeUpdate(sql);
				System.out.println(i);
			}catch(Exception ee){
				System.out.println(ee.toString());
			}
		}//end of UpdateSql
		
//........................................................................
//------------------执行删除词条语句-----------------------------------－－－－	－－－
		public void DeleteSql(String sql){
			try{
				stmt=constr.createStatement();
				int i=stmt.executeUpdate(sql);
			}catch (Exception ee){
				
			}
		}//end of DeleteSql
		
//............................................................................
//-------------------------关闭结果集-------------------------------------------
	public void close(ResultSet rs){
		try{
			if(rs!=null){		
			rs.close();
		}}catch(SQLException sqlerr){
			sqlerr.printStackTrace();
		}
	}//end of close
	
//...............................................................................
//------------------------关闭语句集-----------------------------------------------
	public void closestat(){
		try{
			if(stmt!=null){
				stmt.close();
			}
		}catch(SQLException sqler){
			sqler.printStackTrace();
		}
	}//end of statement close
//..................................................................................
//-----------------------关闭连接----------------------------------------------------
	public void closeconn(){
		try{
			if(constr!=null){
				constr.close();
			}
		}catch(SQLException sqle){
			sqle.printStackTrace();
		}
	}//end of closeconn
	}