public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//1.:首先要把编码全部改为utf-8
request.setCharacterEncoding("utf-8");
//响应
request.setCharacterEncoding("utf-8");
//显示格式
response.setContentType("textml");
//处理请求
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
Connection conn =DBUtil.getconn();
String sql = "select * from student";
ResultSet rs = null;
PreparedStatement ps =null;
try{
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
out.println("<tr>"+
"<td>"+rs.getInt("id")+"</td>"+
"<td>"+rs.getString("name")+"</td>"+
"<td>"+rs.getInt("age")+"</td>"+
"<td>"+rs.getString("user_name")+"</td>"+
"<td>"+rs.getString("pwd")+"</td>"+
"</tr>");
}
}catch(SQLException e){
e.printStackTrace();
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
private void prepareStatement(String sql) {
// TODO Auto-generated method stub
}
<body>
<!-- 这是HTML注释 -->
<%--这个是JSP注释 --%>
<%
//这个是Java代码注释
/**
* 这个是Java代码多行注释
*/
String name ="zhangsna";
int i = 9;
%>
<%--表达式 输出name --%>
这个是名字:<%=name %>
</body>