dbconnection.java

jsp实现的购物车功能

package jspcart.conn;
import java.sql.*;
public class DBConnection {
  private Connection con=null;
  MyConnection myconnt=new MyConnection();
  public DBConnection() {
    con=myconnt.getConnection();
  }
  public ResultSet Execsql(String sql){
    ResultSet rst=null;
    Statement stmt=null;
    try {
      stmt=con.createStatement();
      rst=stmt.executeQuery(sql);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  return rst;
  }
  public int openSql(String sql){
    int cnt=0;
    Statement stmt=null;
    try {
      stmt=con.createStatement();
      cnt=stmt.executeUpdate(sql);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return cnt;
  }
}