checkbean.java

sql+struts+jsp 提供考试的一般需求

package manage;
import java.sql.*;
import javax.sql.*;
public class checkBean {
    Connection conn=null;
    Statement stmt=null;
    ResultSet rst=null;
    public checkBean(DataSource ds)throws Exception{
        conn=ds.getConnection();
    }
   public boolean insert(String sql){
        try{
            stmt=conn.createStatement();
            if(stmt.executeUpdate(sql)!=1){
                return false;
            }

        }catch(SQLException e){
            e.printStackTrace();
        }
      return true;
    }
   public boolean delete(String sql){
         try{
             stmt=conn.createStatement();
             if(stmt.executeUpdate(sql)!=1){
                 return false;
             }

         }catch(SQLException e){}
             return true;
     }
}