public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/json;charset=utf-8");
PrintWriter out=response.getWriter();
try{
Class.forName("com.mysql.cj.jdbc.Driver");
String url="jdbc:mysql://localhost/xinwen?user=root&password=mth6681008&useUnicode=true&characterEncoding=UTF-8";
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String sql;
sql="SELECT * FROM wenzhang";
ResultSet rs=stmt.executeQuery(sql);
JSONArray jsonarray=new JSONArray();
JSONObject jsonobj=new JSONObject();
while(rs.next()){
jsonobj.put("id",rs.getString("id"));
jsonobj.put("title",rs.getString("title"));
jsonobj.put("img",rs.getString("img"));
jsonobj.put("cTime",rs.getString("cTime"));
jsonarray.add(jsonobj);
}
out=response.getWriter();
out.println(jsonarray);
rs.close();
stmt.close();
con.close();
}catch(Exception e){
out.print("get data error!");
e.printStackTrace();
}
}