setgljh.java

中学教学管理系统

package servlets;
import utility.DBConnection;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class SetGLJH extends HttpServlet {

	public SetGLJH() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		HttpSession session = request.getSession();
		
		
		//设定编码类型，避免传递中文参数出现乱码
		request.setCharacterEncoding("gb2312");
		
		String jihuaNo = request.getParameter("jihua");
		String teacherNo = request.getParameter("teacherNumber");
		String fileName = request.getParameter("jiHuaName");
		
		if(jihuaNo==null || teacherNo==null || fileName==null|| jihuaNo.equals("") || teacherNo.equals("") || fileName.equals(""))
		{
			response.sendRedirect("/TeacherManager/manageSchedule/set_gljh.jsp");
			return;
		}
		
		//处理上传文件
		
		
		//插入数据库
		try{
			Connection con = DBConnection.getConnection();
			Statement st = con.createStatement();
			String update = "insert into plan values('"+jihuaNo+"','"+teacherNo+"','"+fileName+"')";
			st.executeUpdate(update);
			
			con.close();
			
		}catch(Exception e)
		{
			e.printStackTrace();
			response.sendRedirect("/TeacherManager/manageSchedule/set_gljh.jsp");
			return;
		}
		
		
		
		response.sendRedirect("/TeacherManager/manageSchedule/set_gljh.jsp?suc=true");
		return;
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}

	public void init() throws ServletException {
		// Put your code here
	}

}