前端使用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数据
网友评论