📄 news.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%
request.setCharacterEncoding("gb2312");
//第2句和第4句用于解决不能用中文登录的问题
%>
<%@ page language="java" import="java.sql.*"%>
<jsp:directive.page import="news.sql_data"/>
<jsp:directive.page import="java.text.SimpleDateFormat"/>
<jsp:directive.page import="java.util.*"/>
<jsp:directive.page import="java.util.Date"/>
<HTML>
<HEAD>
<TITLE>news.jsp</TITLE>
<link rel="stylesheet" href="m_style.css" type="text/css">
</HEAD>
<SCRIPT LANGUAGE="JavaScript">
function btnClick(type){
var fm=document.form1
if(type=='add'){
fm.c.value=1;
return true;
}else if(type=='edt'){
fm.c.value=2;
return true;
}else if(type=='del'){
fm.c.value=3;
return true;
}
}
function login(){
window.location="login.jsp"
}
function radio() {
l=document.getElementsByName("radio")
for(i=0;i<l.length;i++) {
if(l[i].checked)
document.form1.dataid.value=l[i].value
}
}
function radio(){
var l=document.getElementsByName("radio");
for(i=0;i<l.length;i++){
if(l[i].checked){
var s=l[i].value;
var ss=new Array();
ss=s.split(",");
document.getElementById("dataid").value=ss[0];
document.getElementById("id").value=ss[1];
document.getElementById("cnname").value=ss[2];
document.getElementById("password").value=ss[3];
document.getElementById("oldenname").value=ss[4];
document.getElementById("sex").value=ss[5];
document.getElementById("birthday").value=ss[6];
document.getElementById("nativeplace").value=ss[7];
document.getElementById("edu").value=ss[8];
document.getElementById("nation").value=ss[9];
document.getElementById("officetel").value=ss[10];
document.getElementById("mobile").value=ss[11];
document.getElementById("hometel").value=ss[12];
document.getElementById("certificatetype").value=ss[13];
document.getElementById("certificateno").value=ss[14];
document.getElementById("email").value=ss[15];
document.getElementById("politicalstatus").value=ss[16];
document.getElementById("aboardtime").value=ss[17];
document.getElementById("visano").value=ss[18];
document.getElementById("speciality").value=ss[19];
document.getElementById("studyabroad_country").value=ss[20];
document.getElementById("company").value=ss[21];
document.getElementById("studyabroad_type").value=ss[22];
document.getElementById("address").value=ss[23];
document.getElementById("company_addr").value=ss[24];
document.getElementById("finishschool").value=ss[25];
document.getElementById("remark").value=ss[26];
document.getElementById("photo").value=ss[27];
document.getElementById("inputtime").value=ss[28];
document.getElementById("inputmancode").value=ss[29];
document.getElementById("impman").value=ss[30];
document.getElementById("addtime").value=ss[31];
document.getElementById("edittime").value=ss[32];
document.getElementById("preserve1").value=ss[33];
document.getElementById("preserve2").value=ss[34];
document.getElementById("preserve3").value=ss[35];
document.getElementById("preserve4").value=ss[36];
document.getElementById("preserve5").value=ss[37];
document.getElementById("comments").value=ss[38];
document.getElementById("datasrc").value=ss[39];
document.getElementById("cnname_pinyin").value=ss[40];
document.getElementById("oldenname_pinyin").value=ss[41];
}
}
}
function aaa(){//用于检查radio的value是否已经接受
var l=document.getElementsByName("radio");
for(i=0;i<l.length;i++){
if(l[i].checked)
document.getElementById("in").value=l[i].value;
}
}
</SCRIPT>
<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;
}
%>
<% try{
//SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd", Locale.CHINA);
//我想用这个来向数据库中插入data类型的数据
String parm = request.getParameter("c");
if(parm==null)
{
parm="";
}
// request.setCharacterEncoding("gb2312");
// request.setCharacterEncoding("GBK");
String dataid=request.getParameter("dataid");
String id=request.getParameter("id");
String cnname=request.getParameter("cnname");
String password=request.getParameter("password");
String oldenname=request.getParameter("oldenname");
String sex=request.getParameter("sex");
String birthday=request.getParameter("birthday");
String nativeplace=request.getParameter("nativeplace");
String edu=request.getParameter("edu");
String nation=request.getParameter("nation");
String officetel=request.getParameter("officetel");
String mobile=request.getParameter("mobile");
String hometel=request.getParameter("hometel");
String certificatetype=request.getParameter("certificatetype");
String certificateno=request.getParameter("certificateno");
String email=request.getParameter("email");
String politicalstatus=request.getParameter("politicalstatus");
String aboardtime=request.getParameter("aboardtime");
String visano=request.getParameter("visano");
String speciality=request.getParameter("speciality");
String studyabroad_country=request.getParameter("studyabroad_country");
String company=request.getParameter("company");
String studyabroad_type=request.getParameter("studyabroad_type");
String address=request.getParameter("address");
String company_addr=request.getParameter("company_addr");
String finishschool=request.getParameter("finishschool");
String remark=request.getParameter("remark");
String photo=request.getParameter("photo");
String inputtime=request.getParameter("inputtime");
String inputmancode=request.getParameter("inputmancode");
String impman=request.getParameter("impman");
String addtime=request.getParameter("addtime");
String edittime=request.getParameter("edittime");
String preserve1=request.getParameter("preserve1");
String preserve2=request.getParameter("preserve2");
String preserve3=request.getParameter("preserve3");
String preserve4=request.getParameter("preserve4");
String preserve5=request.getParameter("preserve5");
String comments=request.getParameter("comments");
String datasrc=request.getParameter("datasrc");
String cnname_pinyin=request.getParameter("cnname_pinyin");
String oldenname_pinyin=request.getParameter("oldenname_pinyin");
if (parm.equals("1")) {
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 +"')";
// String mysql="insert into news_table(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) 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+"#')";
db.executeUpdate(mysql);
}else if (parm.equals("2")) {
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;
db.executeUpdate(mysql);
} else if(parm.equals("3")){
String mysql = "delete from news_table where dataid="+dataid;
db.executeUpdate(mysql);
}
ResultSet rs=db.executeQuery("select * from news_table where dataid="+session.getAttribute("dataid"));
%>
<%
if(session.getAttribute("name")==null){%>
<script language="JavaScript">
window.location="login.jsp"
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -