📄 manager.jsp
字号:
<%@ page contentType="text/html; charset=GB2312"%>
<%@ 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>manager.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(){
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"/>
<jsp:useBean id="PageCt" scope="session" class="util.PageCt"/>
<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=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");
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 rs0 = db.executeQuery("select count(*) from news_table ");
rs0.next();
long data_num=rs0.getLong(1);
long Current_Page = 0;
String currentpage=(String)request.getParameter("currentpage");
if (currentpage != null && !currentpage.equals(""))
{
Current_Page = Integer.parseInt(request.getParameter("currentpage"));
}
String Query_Page=(String)request.getParameter("Query_Page");
if (Query_Page!=null && !Query_Page.equals(""))
{
Current_Page = Integer.parseInt(request.getParameter("Query_Page"))-1;
}
PageCt.Init(Current_Page,data_num);
long l_start = PageCt.getStart();
long l_end = PageCt.getEnd();
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
ResultSet rs=db.executeQuery("select * from news_table");
long i=0;
while((i<l_start) && rs.next())
{
i++;
}
%>
<%
if(session.getAttribute("name")==null){%>
<script language="JavaScript">
window.location="login.jsp"
</script>
<%}
else
{%><table>
<tr>
<td>
用户名：<%=session.getAttribute("name")%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -