addgrade.java

本源码主要从数据库的开发过程出发

package Source;

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

public class addGrade extends HttpServlet {

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        HttpSession session = request.getSession();
        
        JDBCBean jdbcbean = new JDBCBean();
        ResultSet rs = null;
        
        userInf userinf = (userInf) session.getAttribute("userinf");
        String[] SNo = request.getParameterValues("SNo");
        String[] CG = request.getParameterValues("CG");
        String CNo = request.getParameter("select");
        int credit = Integer.parseInt(request.getParameter("credit"));
        String Tno = userinf.getUserID();
        String inf = "";
       
        try {
            for (int i = 0; i < SNo.length; i++) {
                System.out.println(i+"  :"+SNo[i]);
                if (SNo[i] != null && !SNo[i].equals("")) {
                    rs = jdbcbean.executeQuery("select * from student where userId='" + SNo[i] + "'");
                    if (rs.next()) {
                        jdbcbean.executeUpdate("insert into grade values('" + SNo[i] + "','" + CNo + "'," + credit + ",'" + CG[i] + "','" + Tno + "')");
                        inf += "瀛﹀彿" + SNo[i] + " :鎴愮哗澧炲姞鎴愬姛<BR>";
                    } else {
                        inf += "瀛﹀彿" + SNo[i] + ":涓嶅瓨鍦