checkbean.java

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

package ks;
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 void insert(String stuno,String name,String sex,String idnum,String subject,String distin,String phone){
        String sql="insert into pxbaoming values('"+stuno+"','"+name+"','"+ sex +"','"+idnum+"','"+subject+"','"+distin+"','"+phone+"')";
        try{
            stmt=conn.createStatement();
            stmt.executeUpdate(sql);
       }catch(SQLException e){
           e.printStackTrace();
       }
    }
}