student_add.java

一个JSP写的学生选课系统

package test;

import java.io.*;
import javax.servlet.http.*;
import javax.servlet.ServletException;
import javax.sql.DataSource;
import javax.naming.*;
import java.sql.*;
import java.util.*;

public class Student_add extends HttpServlet
{
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException, IOException
    {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html;charset=gb2312");
		DbBean dbBean = (DbBean)request.getSession().getAttribute("DbBean");
		String sid = request.getSession().getAttribute("g_sid").toString();
		String cid = request.getParameter("cid");
			response.getWriter().print(cid);
			String sql = "insert into course_student values('" + sid + "','" + cid + "',0,0)";
		
			try
			{
			   dbBean.Update(sql);
			}
			catch (Exception e)
			{
			}
			response.sendRedirect("sselect.jsp");		
	}

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