问卷调查网站制作-前后端开发

前端使用jQuery，后端使用servlet制作一个简单问卷调查网站，使用的开发工具为eclipse。实现的功能：能够将读取MySQL数据库中的基本信息，并显示在网页中，用户评价后将用户的基本信息和评价信息传回到数据库。具体步骤如下：

1.首先在Eclipse中新建项目并读取MySQL数据库中的信息并在HTML中展示

详情请参考我的另一篇文章Servlet读取MySQL数据库并在前端调用

2.调查问卷界面设计

界面设计

前端数据解析

3.前端HTML代码编写

4.后台servlet传入数据库

package practice;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class write extends HttpServlet {

    public void destroy() {

        super.destroy();

    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

            doPost(request,response);

    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        response.setContentType("text/html");

        PrintWriter out = response.getWriter();

        request.setCharacterEncoding("utf-8");

        response.setCharacterEncoding("utf-8");

        Connection conn = null;

        PreparedStatement stmt = null;

        ResultSet rs = null;

        String address=request.getParameter("address");

        String marriage=request.getParameter("marriage");

        String level=request.getParameter("level");

        String occupation=request.getParameter("occupation");

        String degree=request.getParameter("degree");

        String age=request.getParameter("age");

        String sex=request.getParameter("sex");

        String c_id=request.getParameter("c_id");

        String multitext=request.getParameter("multitext");

String income=request.getParameter("income");

String score=request.getParameter("score");

String c_id2=request.getParameter("c_id2");

String score15=request.getParameter("score15");

        String drive = "com.mysql.jdbc.Driver";

        System.out.println("ajax后台交互成功"); 

        try{

            Class.forName(drive);

            conn = DriverManager    //"jdbc:mysql://123.206.81.238:3306/envix?serverTimezone=GMT%2B8&useSSL=true","envAdmin","envGIS1!"

                    .getConnection("jdbc:mysql://123.206.81.238:3306/envix?serverTimezone=GMT%2B8&useSSL=true","envAdmin","envGIS1!");

            System.out.println("数据库连接成功");

            String sql="insert  into wenjuan(address, marriage,level, occupation, degree, age, sex, c_id, multitext, income, score,c_id2, score15)";

            sql+=" values(?,?,?,?,?,?,?,?,?,?,?,?,?)";

            stmt = conn.prepareStatement(sql);

            stmt.setString(1,address);

            stmt.setString(2,marriage);

            stmt.setString(3,level);

            stmt.setString(4,occupation);

            stmt.setString(5,degree);

            stmt.setString(6,age);

            stmt.setString(7,sex);

            stmt.setString(8,c_id);

            stmt.setString(9,multitext);

stmt.setString(10,income);

stmt.setString(11,score);

stmt.setString(12,c_id2);

stmt.setString(53,score15);

            stmt.executeUpdate();

            System.out.println("success");

    }catch (ClassNotFoundException e) {

            e.printStackTrace();

        } catch (SQLException e) {

            e.printStackTrace();

        }finally {

            try {

                    if (rs != null) {

                        rs.close();

                    }

                    if (stmt != null) {

                        stmt.close();

                    }

                    if (conn != null) {

                        conn.close();

                    }

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

    }

   public void init() throws ServletException {

    }

}

5.写入到数据库最终结果

写入到MySQL数据