📄 userregisterservlet.java
字号:
package com.allanlxf.serv.basic;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.allanlxf.jdbc.util.ConnectionFactory;
import com.allanlxf.jdbc.util.JdbcUtil;
public class UserRegisterServlet extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
String userName = request.getParameter("userName");
String password = request.getParameter("password");
String province = request.getParameter("province");
String gender = request.getParameter("gender");
String[] hobbies = request.getParameterValues("hobbies");
String str = "";
if(hobbies != null)
{
str = "";
for(int i = 0; i < hobbies.length; i++)
{
if(i > 0)
{
str += ",";
}
str += hobbies[i];
}
}
String introduction = request.getParameter("introduction");
String message = "congratulations";
Connection con = null;
PreparedStatement ps = null;
try
{
con = ConnectionFactory.getConnection();
String sql = "insert into user_serv(id, username, pwd, province, gender, hobbies, introduction)";
sql += " values(user_serv_seq.nextval,?,?,?,?,?, ?)";
ps = con.prepareStatement(sql);
int index = 1;
ps.setString(index++, userName);
ps.setString(index++, password);
ps.setString(index++, province);
ps.setString(index++, gender);
ps.setString(index++, str);
ps.setString(index++, introduction);
ps.executeUpdate();
}catch(SQLException e)
{
e.printStackTrace();
message = "sorry";
}finally
{
JdbcUtil.close(ps, con);
}
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>register</title>");
out.println("</head>");
out.println("<body>");
out.println("<h3 align=\"center\">System Message</h3>");
out.println("<hr>");
out.println("<center>" + message + "</center>");
out.println("<a href=\"/serv-app/user/list\">view users</a>");
out.println("</body>");
out.println("</html>");
out.close();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -