📄 firsthttpservlet.java
字号:
package org.inspure.testservletpro.servlet;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class FirstHttpServlet extends HttpServlet {
private Connection conn;
private String url;
private String username;
private String password;
public void init(ServletConfig config) throws ServletException {
ServletContext context = config.getServletContext();
this.url = context.getInitParameter("url");
this.username = context.getInitParameter("username");
this.password = context.getInitParameter("password");
String className = context.getInitParameter("driver_manager");
// this.url = config.getInitParameter("url");
// this.username = config.getInitParameter("username");
// this.password = config.getInitParameter("password");
// String className = config.getInitParameter("driver_manager");
try {
Class.forName(className);
this.conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void doGet(HttpServletRequest resqust, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html;charset=GBK");
PrintWriter out = response.getWriter();
Statement stmt = null;
ResultSet rs = null;
try {
stmt = this.conn.createStatement();
String sql = "SELECT name,password FROM t_user1";
rs = stmt.executeQuery(sql);
if (rs != null) {
while (rs.next()) {
out.println("用户名：" + rs.getString("name")+"-------");
out.println("密码：" + rs.getString("password") + "</br>");
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
stmt = null;
rs = null;
}
out.println("<html>");
out.println(" <head>");
out.println(" <title>");
out.println(" 登录");
out.println(" </title>");
out.println(" </head>");
out.println(" <body>");
out.println("<form action=\"http\" method=\"post\">");
out.println(" <table border=1>");
out.println(" <tr>");
out.println(" <td>用户名:</td>");
out.println(" <td><input type=text name=\"txtUsername\"></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>密码:</td>");
out.println(" <td><input type=password name=\"txtPassword\"></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>确认密码:</td>");
out.println(" <td><input type=password name=\"contxtPassword\"></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>性别:</td>");
out.println(" <td><input type=\"radio\" name=1 checked value=\"男\">男");
out.println(" <input type=\"radio\" name=1 value=\"女\">女");
out.println(" <input type=\"radio\" name=1>未知");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>所在省:</td>");
out.println(" <td><select name=\"se\">");
out.println(" <option value=\"山东省\">山东省</option>");
out.println(" <option value=\"四川省\">四川省</option>");
out.println(" <option value=\"湖南省\">湖南省</option>");
out.println(" </select>");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>爱好</td>");
out.println(" <td>");
out
.println(" <input type=\"checkbox\" name=\"hobbies\" value=\"反恐\">反恐");
out
.println(" <input type=\"checkbox\" name=\"hobbies\" value=\"唱歌\">唱歌");
out
.println(" <input type=\"checkbox\" name=\"hobbies\" value=\"游戏\">游戏");
out
.println(" <input type=\"checkbox\" name=\"hobbies\" value=\"游泳\">游泳");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>备注</td>");
out.println(" <td>");
out.println(" <textarea id=\"ta\" rows=4 cols=27></textarea>");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td colspan=2>");
out.println(" <input type=\"submit\" value=\"保存\">");
out.println(" <input type=\"reset\" value=\"取消\">");
out.println(" </td>");
out.println(" </tr>");
out.println(" </table>");
out.println(" </form>");
out.println(" </body>");
out.println("</html>");
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
request.setCharacterEncoding("GBK");
// response.setCharacterEncoding("GBK");
response.setContentType("text/html;charset=GBK");
PrintWriter out = response.getWriter();
String username = request.getParameter("txtUsername");
String password = request.getParameter("txtPassword");
String connpassword = request.getParameter("contxtPassword");
String[] hobbies = request.getParameterValues("hobbies");
String _hobbies = "";
for (String temp : hobbies) {
_hobbies += temp + ";";
}
String[] pro = request.getParameterValues("se");
String _pro = "";
for (String temp : pro) {
_pro += temp;
}
String[] sex = request.getParameterValues("1");
String _sex = "";
for (String temp : sex) {
_sex += temp;
}
out.println("用户名：" + username + "<br>");
out.println("密码：" + password + "<br>");
out.println("确认密码：" + connpassword + "<br>");
out.println("性别：" + _sex + "<br>");
out.println("所在省：" + _pro + "<br>");
out.println("爱好：" + _hobbies);
// response.sendRedirect("wang/wang.html");
request.getRequestDispatcher("/wang/wang.html").forward(request, response);
}
public void destroy() {
try {
this.conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -