public class DataVo {
    long dms_id;

    public long getDms_id() {
        return this.dms_id;
    }

    public void setDms_id(long str) {
        this.dms_id = str;
    }

    String dms_title;

    public String getDms_title() {
        return this.dms_title;
    }

    public void setDms_title(String str) {
        this.dms_title = str;
    }

    java.sql.Date dms_addtime;

    public java.sql.Date getDms_addtime() {
        return this.dms_addtime;
    }

    public void setDms_addtime(java.sql.Date str) {
        this.dms_addtime = str;
    }

    String dms_content;

    public String getDms_content() {
        return this.dms_content;
    }

    public void setDms_content(String str) {
        this.dms_content = str;
    }

    long nodeId;

    public long getNodeId() {
        return this.nodeId;
    }

    public void setNodeId(long str) {
        this.nodeId = str;
    }
    
    String text;
    
    public String getText() {
        return this.text;
    }
    
    public void setText(String str){
        this.text=str;
    }

    String parm = "dms_id,dms_title,dms_addtime,dms_content,nodeId";

    public String getParm() {
        return parm;
    }

    public void setParm(String parm) {
        this.parm = parm;
    }

    String parm1 = "dms_title,dms_content,nodeId";

    public String getParm1() {
        return parm1;
    }

    public void setParm1(String parm1) {
        this.parm1 = parm1;
    }

    String parm2 = "dms_title=?,dms_content=?,nodeId=? where dms_id=?";

    public String getParm2() {
        return parm2;
    }

    public void setParm2(String parm2) {
        this.parm2 = parm2;
    }
}

import java.sql.Connection;
import java.util.List;
import java.util.Vector;

import common.jiangbin.dms.DBConnection;
import common.jiangbin.dms.SplitPageCommon;


public class DataBiz {
    public void insert(DataVo vo) {
        DBConnection dbc = new DBConnection();
        if (dbc.getConnect()) {
            Connection conn = dbc.getConn();
            try {
                DataDao dao = new DataDao();
                dao.insert(conn, vo);
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    if (conn != null) {
                        conn.close();
                        conn = null;
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        } else {
            System.out.println("数据库连接失败!");
        }
    }

    public List findbyAll(SplitPageCommon spvo,String sqlw) {
        Vector v = new Vector();
        DBConnection dbc = new DBConnection();
        if (dbc.getConnect()) {
            Connection conn = dbc.getConn();
            try {
                DataDao dao = new DataDao();
                v = dao.findbyAll(conn,spvo,sqlw);
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    if (conn != null) {
                        conn.close();
                        conn = null;
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        } else {
            System.out.println("数据库连接失败!");
        }
        return v;
    }

    public DataVo findbykey(DataVo vo) {
        DataVo dvo = new DataVo();
        DBConnection dbc = new DBConnection();
        if (dbc.getConnect()) {
            Connection conn = dbc.getConn();
            try {
                DataDao dao = new DataDao();
                dvo = dao.findbykey(conn, vo);
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    if (conn != null) {
                        conn.close();
                        conn = null;
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        } else {
            System.out.println("数据库连接失败!");
        }
        return dvo;
    }

    public void update(DataVo vo) {
        DBConnection dbc = new DBConnection();
        if (dbc.getConnect()) {
            Connection conn = dbc.getConn();
            try {
                DataDao dao = new DataDao();
                dao.update(conn, vo);
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    if (conn != null) {
                        conn.close();
                        conn = null;
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        } else {
            System.out.println("数据库连接失败!");
        }
    }

    public void delete(DataVo vo) {
        DBConnection dbc = new DBConnection();
        if (dbc.getConnect()) {
            Connection conn = dbc.getConn();
            try {
                DataDao dao = new DataDao();
                dao.delete(conn, vo);
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                try {
                    if (conn != null) {
                        conn.close();
                        conn = null;
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        } else {
            System.out.println("数据库连接失败!");
        }
    }
}

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import common.dms.SplitPageCommon;


public class DataServlet extends HttpServlet {
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        int _act = 1;
        String act = request.getParameter("act");
        if (act != null && !act.equals("")) {
            _act = Integer.parseInt(act);
        } else {
            _act = 1;
        }
        switch (_act) {
        case 1: // 添加资料
            this.insert(request, response);
            break;
        case 2: // 修改某条记录
            this.update(request, response);
            break;
        case 3: // 删除某一条数据
            this.delete(request, response);
            break;
        }
    }
    //1:添加资料
    public void insert(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        String dms_title=request.getParameter("dms_title");
        String dms_content=request.getParameter("dms_content");
        String nodeId=request.getParameter("nodeId");
        DataVo vo=new DataVo();
        vo.setDms_title(dms_title);
        vo.setDms_content(dms_content);
        vo.setNodeId(Long.parseLong(nodeId));
        DataBiz biz=new DataBiz();
        biz.insert(vo);
        //request.getRequestDispatcher("DataDervlet?act=2&nodeId="+nodeId).forward(request, response);
        String path = request.getContextPath();
        response.sendRedirect(path+"/DataServlet?act=2&nodeId="+nodeId);
    }
    //2:修改某条记录
    public void update(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        String dms_id=request.getParameter("dms_id");
        String dms_title=request.getParameter("dms_title");
        String dms_content=request.getParameter("dms_content");
        String nodeId=request.getParameter("nodeId");
        DataVo vo=new DataVo();
        vo.setDms_title(dms_title);
        vo.setDms_content(dms_content);
        vo.setNodeId(Long.parseLong(nodeId));
        vo.setDms_id(Long.parseLong(dms_id));
        DataBiz biz=new DataBiz();
        biz.update(vo);
        String path = request.getContextPath();
        response.sendRedirect(path+"/TreeServlet?act=2&type=3&nodeId="+nodeId);
    }
    //3:删除某条记录
    public void delete(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        String nodeId=request.getParameter("nodeId");
        String dms_id=request.getParameter("dms_id");
        DataVo vo=new DataVo();
        vo.setDms_id(Long.parseLong(dms_id));
        DataBiz biz=new DataBiz();
        biz.delete(vo);
        String path = request.getContextPath();
        response.sendRedirect(path+"/TreeServlet?act=2&type=3&nodeId="+nodeId);
    }
}