conndb.java

一个简单的JDBC操作

package li.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class connDB {
 
 private Connection conn=null;
 private ResultSet rs = null;
 public connDB(String DBDRIVER ,String DBURL,String DBUSER,String DBPASSWORD)
 {
    try {
		Class.forName(DBDRIVER);
		this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	 
 }
 
  public  Connection getConnection()
  {
	 return this.conn;
  }
  public ResultSet executeQuery(String sql)
  {
	 
	  try {
		Statement stmt=conn.createStatement();
		  rs=stmt.executeQuery(sql);
	  } catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	  }
	  return rs;
  }
  public int executeUpdate(String sql)
  {
	  int re=0;
        try {
		   Statement stmt=conn.createStatement();
		   re=stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	return re;
  }
  public boolean insert(String sql)
  {
	  boolean suc=false;
	  try {
		   Statement stmt=conn.createStatement();
		  suc=stmt.execute(sql);
       } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
	   }
      return suc;
  }
  public boolean delete(String sql)
  {
	  boolean suc=false;
	  try {
		   Statement stmt=conn.createStatement();
		   suc=stmt.execute(sql);
       } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
	   }
      return suc;
  }
  public void close()
  {
	 try {
		if(rs!=null)
		{
	      rs.close();
		}
		if(conn!=null)
		{
		this.conn.close();
		}
	 } catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	 }
  }
}