📄 xiugai.java
字号:
package project1;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class xiugai extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void service(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>xiugai</title></head>");
out.println("<body>");
//设定编码类型，以便正确解码
request.setCharacterEncoding("GBK");
//验证身份
HttpSession sess = request.getSession();
if((sess.getAttribute("token"))==null){
out.print("对不起，请先登录");
response.setHeader("Refresh","1;URL=login.jsp");
}
else{
//得到参数
String frd_id = request.getParameter("frd_id");
//out.print(frd_id);
String frd_name=request.getParameter("frd_name");
//out.print(frd_name);
String frd_type_id=request.getParameter("update_frd_type_id");
//out.print(frd_type_id);
String frd_tele=request.getParameter("frd_tele");
//out.print(frd_tele);
String frd_sex=request.getParameter("frd_sex");
//out.print(frd_sex);
String frd_email=request.getParameter("frd_email");
//out.print(frd_email);
String frd_birth=request.getParameter("frd_birth");
//out.print(frd_birth);
String frd_describe=request.getParameter("frd_describe");
//out.print(frd_describe);
String sqlString = null;
if(Integer.valueOf(frd_type_id)>0){
//out.print("需要对frd_type_id进行改变");
sqlString="update friends set frd_name='"+frd_name+"',frd_type_id='"+frd_type_id+"',frd_tele='"+frd_tele+"',frd_sex='"+frd_sex+"',frd_email='"+frd_email+"',frd_birth='"+frd_birth+"',frd_describe='"+frd_describe+"' where frd_id="+frd_id;
}
else{
//out.print("不需要对frd_type_id进行改变");
sqlString="update friends set frd_name='"+frd_name+"',frd_tele='"+frd_tele+"',frd_sex='"+frd_sex+"',frd_email='"+frd_email+"',frd_birth='"+frd_birth+"',frd_describe='"+frd_describe+"' where frd_id="+frd_id;
}
//SQL语句
try{
Connection conn;
Statement sql;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:myaddressBook");
sql=conn.createStatement();
sql.executeUpdate(sqlString);
conn.close();
out.print("用户修改资料成功");
response.setHeader("Refresh","1;URL=list_all");
}catch(Exception e1){
out.print(e1);
}
}
out.println("</body></html>");
out.close();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -