studentadd.java

学生管理系统

package cn.jl.student.servlet;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.io.PrintWriter;

/**
 * Created by IntelliJ IDEA.
 * User: liubing
 * Date: 2008-8-19
 * Time: 19:46:03
 * To change this template use File | Settings | File Templates.
 */
public class StudentAdd extends HttpServlet {

    public void doPost(HttpServletRequest request, HttpServletResponse response){

        response.setContentType("text/html;charset=gbk");
        PrintWriter out = null;

        Context ctx     = null;
        DataSource ds   = null;
        Connection conn = null;
        Statement stmt  = null;

        String sql            = "";
        String studentId      = "";
        String studentName    = "";
        String studentAge     = "";
        String studentSex     = "";
        String degreeId       = "";
        String studentAddress = "";
        String memo           = "";
        String[] studentHobbies = null;
        StringBuffer sqlSb = new StringBuffer();

        try {
            out = response.getWriter();
            request.setCharacterEncoding("gbk");

            //获取表单数据
            studentId      = request.getParameter("studentId");
            studentName    = request.getParameter("studentName");
            studentAge     = request.getParameter("studentAge");
            studentSex     = request.getParameter("studentSex");
            degreeId       = request.getParameter("degreeId");
            studentAddress = request.getParameter("studentAddress");
            memo           = request.getParameter("memo");
            studentHobbies = request.getParameterValues("hobby");

            //连接数据库
            ctx = new InitialContext();
            ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydatasource");
            conn = ds.getConnection();
            stmt = conn.createStatement();
            conn.setAutoCommit(false);

            sqlSb.append(" insert into StudentT (StudentId,StudentName,StudentAge,StudentSex,DegreeId,StudentAddress,Memo)" +
                    " values (" + studentId + ",'" + studentName + "'," + studentAge + "," + studentSex + "," + degreeId + ",'" + studentAddress + "','" + memo +"')");

            //stmt.executeUpdate(sql);

            for(int i = 0 , n = studentHobbies.length; i < n ; i++){
                sqlSb.append(" insert into StudentHobbyT (StudentId,HobbyId) values (" + studentId + "," + studentHobbies[i] + ")");

            }

            stmt.executeUpdate(sqlSb.toString());

            conn.commit();
            out.println("<script language='javascript'>");
            out.println("   alert(\"增加成功！\"); ");
            out.println("   window.location = \"/stu/StudentList\"; ");
            out.println("</script>");

        } catch (Exception e) {
            out.println("<script language='javascript'>");
            out.println("   alert(\"增加失败！\"); ");
            out.println("   window.history.back(); ");
            out.println("</script>");
            try {
                conn.rollback();
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
            e.printStackTrace();
        } finally{
            try{
                if(stmt != null) stmt.close();
                if(conn != null) conn.close();
            }
            catch(Exception e){}
        }

    }

}