📄 m_modify2.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<jsp:useBean id="db" scope="session" class="news.sql_data"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'M_modify2.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<link rel="stylesheet" href="m_style.css" type="text/css">
<body>
<%!
public String Bytes(String str)
{
try{
String str_1=str;
byte[] str_2=str_1.getBytes("ISO8859-1");
String bytes=new String(str_2);
return bytes;
}catch(Exception ex){
System.out.println("中文乱码解决问题出错"+ex.getMessage());
}
return null;
}
%>
<% try{
String dataid=request.getParameter("dataid");
String id=request.getParameter("id");
String cnname=Bytes(request.getParameter("cnname"));
String password=request.getParameter("password");
String oldenname=Bytes(request.getParameter("oldenname"));
String sex=Bytes(request.getParameter("sex"));
String birthday=request.getParameter("birthday");
String nativeplace=Bytes(request.getParameter("nativeplace"));
String edu=Bytes(request.getParameter("edu"));
String nation=Bytes(request.getParameter("nation"));
String officetel=request.getParameter("officetel");
String mobile=request.getParameter("mobile");
String hometel=request.getParameter("hometel");
String certificatetype=Bytes(request.getParameter("certificatetype"));
String certificateno=request.getParameter("certificateno");
String email=request.getParameter("email");
String politicalstatus=Bytes(request.getParameter("politicalstatus"));
String aboardtime=request.getParameter("aboardtime");
String visano=request.getParameter("visano");
String speciality=Bytes(request.getParameter("speciality"));
String studyabroad_country=Bytes(request.getParameter("studyabroad_country"));
String company=Bytes(request.getParameter("company"));
String studyabroad_type=Bytes(request.getParameter("studyabroad_type"));
String address=Bytes(request.getParameter("address"));
String company_addr=Bytes(request.getParameter("company_addr"));
String finishschool=request.getParameter("finishschool");
String remark=Bytes(request.getParameter("remark"));
String photo=request.getParameter("photo");
String inputtime=request.getParameter("inputtime");
String inputmancode=request.getParameter("inputmancode");
String impman=Bytes(request.getParameter("impman"));
String addtime=request.getParameter("addtime");
String edittime=request.getParameter("edittime");
String preserve1=Bytes(request.getParameter("preserve1"));
String preserve2=Bytes(request.getParameter("preserve2"));
String preserve3=Bytes(request.getParameter("preserve3"));
String preserve4=Bytes(request.getParameter("preserve4"));
String preserve5=Bytes(request.getParameter("preserve5"));
String comments=Bytes(request.getParameter("comments"));
String datasrc=Bytes(request.getParameter("datasrc"));
String cnname_pinyin=request.getParameter("cnname_pinyin");
String oldenname_pinyin=request.getParameter("oldenname_pinyin");
// String mysql = "update news_table set id='" +id+"',cnname='" +cnname+"',password='"+password+"',oldenname='"+oldenname+"',sex='"+sex+"',birthday="
// +birthday+",nativeplace='"+nativeplace+"',edu='"+edu+"',nation='"+nation+"',officetel='"+officetel+"',mobile='"+mobile+"',hometel='"+hometel
// +"',certificatetype='"+certificatetype+"',certificateno='"+certificateno+"',email='"+email+"',politicalstatus='"+politicalstatus
// +"',aboardtime='"+aboardtime+"',visano='"+visano+"',speciality='"+speciality+"',studyabroad_country='"+studyabroad_country+"',company='"+company
// +"',studyabroad_type='"+studyabroad_type+"',address='"+address+"',company_addr='"+company_addr+"',finishschool='"+finishschool+"',remark='"+remark
// +"',photo='"+photo+"',inputtime='"+inputtime+"',inputmancode='"+inputmancode+"',impman='"+impman+"',addtime='"+addtime+"',edittime='"+edittime
// +"',preserve1='"+preserve1+"',preserve2='"+preserve2+"',preserve3='"+preserve3+"',preserve4='"+preserve4+"',preserve5='"+preserve5+"',comments='"+comments
// +"',datasrc='"+datasrc+"',cnname_pinyin='"+cnname_pinyin+"',oldenname_pinyin='"+oldenname_pinyin+"'where dataid="+dataid;
String mysql = "update news_table set id='" +id+"',cnname='" +cnname+"',password='"+password+"',oldenname='"+oldenname+"',sex='"+sex+"',birthday="
+birthday+",nativeplace='"+nativeplace+"',edu='"+edu+"',nation='"+nation+"',officetel='"+officetel+"',mobile='"+mobile+"',hometel='"+hometel
+"',certificatetype='"+certificatetype+"',certificateno='"+certificateno+"',email='"+email+"',politicalstatus='"+politicalstatus
+"',aboardtime='"+aboardtime+"',visano='"+visano+"',speciality='"+speciality+"',studyabroad_country='"+studyabroad_country+"',company='"+company
+"',studyabroad_type='"+studyabroad_type+"',address='"+address+"',company_addr='"+company_addr+"',finishschool='"+finishschool+"',remark='"+remark
+"',photo='"+photo+"',inputtime='"+inputtime+"',edittime='"+edittime+"',preserve1='"+preserve1+"',preserve2='"+preserve2+"',preserve3='"+preserve3+"',preserve4='"+preserve4+
"',preserve5='"+preserve5+"',comments='"+comments +"',datasrc='"+datasrc+"',cnname_pinyin='"+cnname_pinyin+"',oldenname_pinyin='"+oldenname_pinyin+
"'where dataid="+dataid;
db.executeUpdate(mysql);
out.println("修改成功!<a href='manager/M_showinfo.jsp'>返回");
}catch(Exception e){
out.println("修改失败："+e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -