noticebean.java

此jsp/javabean数据库开发包功能强大

package notice;
import java.lang.*;
import java.util.*;
import java.io.*;
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import common.all.*;

public class noticeBean
{
    public String departmentType[] ;
    String stor_cd,stor_nm,opr_nm,opr_cd,newpwd_first,old_pwd,newopr_nm,snoticeId,snoticeDate;
    String txtname,txtphone,txtemail,txtAddress,txtTitle,txtContent,reply,noticetype;
    public String noticeContent[]=new String[10] ;

    String sWhere="";
    public  int err_num=0;

    HttpServletRequest req;
    HttpServletResponse res;
    HttpSession ses;

    QueryBean a=new QueryBean();
    public Check check=new Check();



    public void SubProcess(HttpServletRequest request, HttpServletResponse response, HttpSession session)
            throws IOException
    {
        req=request;
        res=response;
        ses=session;
    }


     public int Addnotice()
    {
        String sqlstr;


        sqlstr= " insert into notice (title, content, author, IssueDate, NoticeLevel,photo)" +
                " values ('测试记录','这是一条测试记录','王伟东',Date(),'高级','1.jpg')";
        a.setQuery(sqlstr);
        if(!a.doSQL() ){ err_num=a.err_number ;return 1;}

        return 0;


    }
    public int DBOper()
    {

        String delflag="";
        delflag=check.DealNULL(req.getParameter("delflag"));
        if(delflag.equals("1")) return Delnotice();
        else if(delflag.equals("2")) return Addnotice();
        return 99;
    }
    public int Delnotice()
    {
        String checkType[] ;
        String sqlstr="",in_back_flag="",textfield="";
        boolean transferFlag=false;
        String sid;

        checkType=(req.getParameterValues("checkdel"));

              a.DBConnect();

              for( int i=0;i<checkType.length ;i++)
                {
                   sqlstr="delete from notice where id="+checkType[i];
                   a.setQuery(sqlstr) ;
                  if(!a.doTransaction()) {err_num=a.err_number ;return 1;}

                 }
              a.Commit() ;
              a.DisConnect() ;


          return 0;

    }






}