bkdispose.java

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

package exambk;
import javax.sql.DataSource;
import java.sql.*;

public class bkdispose {
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;
    public bkdispose(DataSource ds){
        try{
            conn=ds.getConnection();
        }catch(Exception e){}
    }

    public boolean bkinsert(String stuno,String stuname,String sex,String idnum,String subject,String phone,String photo){
        boolean flag=false;
        String sel="select * from bkinfo where stuno='"+stuno+"'";
        String sql="insert into bkinfo values('"+stuno+"','"+stuname+"','"+sex+"','"+idnum+"','"+subject+"','"+phone+"','"+photo+"')";
        try{
            stmt=conn.createStatement();
            rs=stmt.executeQuery(sel);
            if(!rs.next()){
                stmt.executeUpdate(sql);
                flag=true;
            }
        }catch(Exception e){}
        return flag;
    }

    public ResultSet queryinfo(String stuno){
        String sql = "select * from bkinfo where stuno='" + stuno + "'";
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {}
        return rs;
    }
}