op_student.java

软件设计大赛的作品,学生登陆系统.包含数据库

/*
*功能：添加参赛的组的信息
 *参数：request 类型：private javax.servlet.http.HttpServletRequest ; //建立页面请求
 *方法： public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest);
        public boolean insert() ;
 */
package wsbm.run;

import wsbm.util.*;
import wsbm.student.*;
import javax.servlet.http.HttpServletRequest;

public class op_student extends DataBase
{
    private javax.servlet.http.HttpServletRequest request; //建立页面请求
    private student astudents = new student();
    private boolean sqlflag = true; //对接收到的数据是否正确

    public String to_String(String str) {
        try {
            return new String(str.getBytes("ISO8859-1"));
        } catch (Exception e) {
            return str;
        }
    }

    public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
        boolean flag = false;
        try {
            request = newrequest;
            String baiji = request.getParameter("class");
         // System.out.println("++++++++++++"+baiji);
            if (baiji == null || baiji.equals("")) {
                baiji = "";
                sqlflag = false;
            }
            astudents.setBaiJi(to_String(baiji));

            String zzname = request.getParameter("teamc");
            if (zzname == null || zzname.equals("")) {
                zzname = "";
                sqlflag = false;
            }
            astudents.setZzName(to_String(zzname));

            String zzdianhua = request.getParameter("phone");
            if (zzdianhua == null || zzdianhua.equals("")) {
                zzdianhua = "";
                sqlflag = false;
            }
            astudents.setZzNum(to_String(zzdianhua));

            String zyname = request.getParameter("teamm");
            if (zyname == null || zyname.equals("")) {
                zyname = "";
                sqlflag = false;
            }
            astudents.setZyName(to_String(zyname));

            String zytype = request.getParameter("item"); //类型
            if (zytype == null || zytype.equals("")) {
                zytype="";
                sqlflag = false;
            }
            astudents.setPjType(to_String(zytype));

            String zpname = request.getParameter("workname");
            if (zpname == null || zpname.equals("")) {
                zpname = "";
                sqlflag = false;
            }
            astudents.setPjName(to_String(zpname));

            String zpms = request.getParameter("description");
            if (zpms == null || zpms.equals("")) {
                zpms = "";
                sqlflag = false;
            }
            astudents.setPjDrp(to_String(zpms));

            String zponly = request.getParameter("only");
            if (zponly == null || zponly.equals("")) {
                zponly = "";
                sqlflag = false;
            }
            astudents.setPjOnly(to_String(zponly));


            if (sqlflag)
                flag = true;
            return flag;
        } catch (Exception e) {
            return flag;
        }
    }

    public boolean insert() {

        sqlStr = "insert into student (class,zzname,zznum,zyname,prjtype,prjname,description,prjonly) values('";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getBaiJi()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getZzName()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getZzNum()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getZyName()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getPjType()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getPjName()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getPjDrp()) + "','";
        sqlStr = sqlStr + dataFormat.toSql(astudents.getPjOnly()) + "')";
        // sqlStr="insert into student (class,zzname,zznum,zyname,prjname,description) values('12','123','1234','12345','46','496')";

        try {
            stmt.executeUpdate(sqlStr);
            conn.close();
            return true;
        } catch (Exception sqle) {
            System.out.print(sqle.getMessage());
            return false;
        }
    }


    public boolean delete(javax.servlet.http.HttpServletRequest newrequest) {
        String prj;
        boolean flag = false;
        try {
            request = newrequest;
            prj = request.getParameter("prjname");
            byte b[] = prj.getBytes("ISO-8859-1");
            prj = new String(b);

            if (prj == null || prj.equals("")) {
                prj = "";
                sqlflag = false;
            }
        } catch (Exception e) {
            return flag;
        }

        System.out.print(prj);
        String deleteAll = "DELETE FROM student WHERE prjname='" +
                           dataFormat.toSql(prj) + "'";
        try {

            stmt.executeUpdate(deleteAll);
            System.out.print("success\n");
            conn.close();

            return true;
        } catch (Exception sqle) {
            System.out.print("false\n" + sqle);
            return false;
        }
    }

        public boolean modefy(javax.servlet.http.HttpServletRequest newrequest)
        {  String  prjn;
            boolean flag=false;
         try
         {
        request = newrequest;
        prjn = request.getParameter("ip");
        byte a[]=prjn.getBytes("ISO-8859-1");
        prjn=new String(a);
        System.out.print(prjn);
         if (prjn == null || prjn.equals(""))
          {
             prjn= "";
             sqlflag = false;
           }
         }
        catch(Exception e)
        {
            e.printStackTrace();
            return false;
        }
        String condition1="update student set class='"+dataFormat.toSql(astudents.getBaiJi())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition2="update student set zzname='"+dataFormat.toSql(astudents.getZzName())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition3="update student set zznum='"+dataFormat.toSql(astudents.getZzNum())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition4="update student set zyname='"+dataFormat.toSql(astudents.getZyName())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition5="update student set prjtype='"+dataFormat.toSql(astudents.getPjType())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition6="update student set prjname='"+dataFormat.toSql(astudents.getPjName())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition7="update student set description='"+dataFormat.toSql(astudents.getPjDrp())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        String condition8="update student set prjonly='"+dataFormat.toSql(astudents.getPjOnly())+"'"+" WHERE prjname='"+dataFormat.toSql(prjn)+"'";
        System.out.print(condition1);
        System.out.print(condition2);
        System.out.print(condition7);
        System.out.print(condition8);
        try{
             stmt.executeUpdate(condition1);
             stmt.executeUpdate(condition2);
             stmt.executeUpdate(condition3);
             stmt.executeUpdate(condition4);
             stmt.executeUpdate(condition5);
             stmt.executeUpdate(condition6);
             stmt.executeUpdate(condition7);
             stmt.executeUpdate(condition8);
             conn.close();
             return true;
         }
         catch (Exception sqle){
            System.out.print(sqle.getMessage());
            return false;
         }
        }

        }