datemesservlet.java

oa源码哈

package edu.scfc;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;

public class DateMesServlet extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    private ConnDB conndb=new ConnDB();
    private Connection con;
    private Statement st;
    private ResultSet rs;
    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        request.setCharacterEncoding("GBK");
        response.setCharacterEncoding("GBK");
        PrintWriter out = response.getWriter();
        String title=request.getParameter("标题").trim();
        String content=request.getParameter("content").trim();
        String ReceiveDept=request.getParameter("userdept").trim();
        HttpSession session=request.getSession();
        String realName=session.getAttribute("realName").toString();
        String SendDept = (String)session.getAttribute("dept");
        Vector vc=this.getVc(ReceiveDept);
        for(int i=0;i<vc.size();i++)
        {
            String ReceiveName=vc.get(i).toString().trim();
            this.insert(title,content,realName,ReceiveDept,ReceiveName);
            this.insert1(title,content,ReceiveName,SendDept,realName);
        }
        out.print(
                    "<script>alert('发送信息成功....');location.href='sendRegister.jsp';</script>");
    }
    public Vector getVc(String Dept)
    {
        Vector v=new Vector();
        try
        {
           this.con=conndb.getConnection();
           this.st=con.createStatement();
           this.rs=st.executeQuery("select RealName from TB_Personnel where Dept='"+Dept+"'");
           while(rs.next())
           {
               v.add(rs.getString("RealName"));
           }

        }catch(Exception ex)
        {
            System.out.println("getVc()-->"+ex.getMessage());
        }
        return v;
    }
    public void insert(String title,String Content,String SendUName,String ReleaseDept,String ReceiveName)
    {
        try
        {
            String sql="insert into TB_SendMes(Title,Content,SendUName,ReceiveDept,ReceiveUName)";
           sql+="values('"+title+"','"+Content+"','"+SendUName+"','"+ReleaseDept+"','"+ReceiveName+"')";
            this.con=conndb.getConnection();
            this.st=con.createStatement();
            st.executeUpdate(sql);
        }catch(Exception ex)
        {
            System.out.println("insert()-->"+ex.getMessage());
        }

    }
    public void insert1(String Title,String Content,String ReceiveUName,String SendDept,String SendUName) {
         this.con=conndb.getConnection();
        try {
            this.st = con.createStatement();
             st.executeUpdate("insert into TB_ReceiveMes(Title,Content,ReceiveUName,SendDept,SendUName) values('"+Title+"','"+Content+"','"+ReceiveUName+"','"+SendDept+"','"+SendUName+"')");
        } catch (SQLException ex)
        {
            System.out.println("insert1-->"+ex.getMessage());
        }

    }


    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        doGet(request, response);
    }

    //Clean up resources
    public void destroy() {
    }
}