📄 m_add2.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page contentType="text/html; charset=gb2312" %>
<jsp:directive.page import="news.sql_data"/>
<jsp:directive.page import="java.sql.*"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'M_add.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">
-->
<link rel="stylesheet" href="m_style.css" type="text/css">
</head>
<jsp:useBean id="db" scope="session" class="news.sql_data"/>
<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;
}
%>
<%
// request.setCharacterEncoding("GBK");
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");
try{
// String mysql = "insert into news_table values (" +dataid+",'"+id+"','"+cnname+"','"+password+"','"+oldenname+"','"+sex+"',"+birthday+",'"+nativeplace+"','"+edu+"','"+nation+"','"+officetel+
// "','"+mobile+"','"+hometel+"','" + certificatetype+ "','" + certificateno+ "','" + email+ "','" + politicalstatus+ "','" + aboardtime+ "','" + visano
// + "','" + speciality+ "','" + studyabroad_country+ "','" + company+ "','" + studyabroad_type+ "','" + address+ "','" + company_addr+ "','" + finishschool
// + "','" + remark+ "','" + photo+ "','" + inputtime+ "','" + inputmancode+ "','" + impman+ "','" + addtime+ "','" + edittime
// + "','" + preserve1+ "','" + preserve2+ "','" + preserve3+ "','" + preserve4+ "','" + preserve5+ "','" + comments+ "','" + datasrc + "','"
// +cnname_pinyin+ "','" +oldenname_pinyin +"')"; //access数据库sql语句
// String mysql = "insert into news_table values ('"+id+"','"+cnname+"','"+password+"','"+oldenname+"','"+sex+"',"+birthday+",'"+nativeplace+"','"+edu+"','"+nation+"','"+officetel+
//"','"+mobile+"','"+hometel+"','" + certificatetype+ "','" + certificateno+ "','" + email+ "','" + politicalstatus+ "','" + aboardtime+ "','" + visano
// + "','" + speciality+ "','" + studyabroad_country+ "','" + company+ "','" + studyabroad_type+ "','" + address+ "','" + company_addr+ "','" + finishschool
// + "','" + remark+ "','" + photo+ "','" + inputtime+ "','" + inputmancode+ "','" + impman+ "','" + addtime+ "','" + edittime
// + "','" + preserve1+ "','" + preserve2+ "','" + preserve3+ "','" + preserve4+ "','" + preserve5+ "','" + comments+ "','" + datasrc + "','"
// +cnname_pinyin+ "','" +oldenname_pinyin +"')"; //sql数据库sql语句
String mysql = "insert into news_table(id,cnname,password,oldenname,sex,birthday,nativeplace,edu,nation,officetel,mobile,"+
"hometel,certificatetype,certificateno,email,politicalstatus,aboardtime,visano,speciality,studyabroad_country,company,"+
"studyabroad_type,address,company_addr,finishschool,remark,photo,inputmancode,impman,addtime,preserve1,preserve2,"+
"preserve3,preserve4,preserve5,comments,datasrc,cnname_pinyin,oldenname_pinyin ) values ('"+id+"','"+cnname+"','"+
password+"','"+oldenname+"','"+sex+"',"+birthday+",'"+nativeplace+"','"+edu+"','"+nation+"','"+officetel+"','"+mobile+
"','"+hometel+"','" + certificatetype+ "','" + certificateno+ "','" + email+ "','" + politicalstatus+ "','" + aboardtime+
"','" + visano+ "','" + speciality+ "','" + studyabroad_country+ "','" + company+ "','" + studyabroad_type+ "','" +
address+ "','" + company_addr+ "','" + finishschool+ "','" + remark+ "','" + photo+ "','" +inputmancode+ "','" + impman+
"','" + addtime+ "','" + preserve1+ "','" + preserve2+ "','" + preserve3+ "','" + preserve4+ "','" + preserve5+ "','" +
comments+ "','" + datasrc + "','"+cnname_pinyin+ "','"+oldenname_pinyin +"')"; //sql数据库sql语句
db.executeUpdate(mysql);
out.println("新增用户成功！");
}catch(Exception e){
out.println("新增用户失败！"+e.getMessage());//为什么不能捕获异常？
}
%>
<input type="button" value="返回"onclick="history.go(-1)">
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -