⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 new.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意: 1. 本书中的案例提供的数据库环境不同
💻 JSP
📖 第 1 页 / 共 2 页
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.util.*,java.text.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id='db' scope='request' class='Base.DataBean.DefaultDataBean' />
<%
	com.util.DealString ds = new com.util.DealString();
	com.db.CommonBean myBean = new com.db.CommonBean();
	String sql = "";

	String strthisname = ds.toGBK(ds.toString((String)request.getParameter("name")));
	String strthisworkid = ds.toGBK(ds.toString((String)request.getParameter("workid")));
	String strthispassword = ds.toGBK(ds.toString((String)request.getParameter("password")));
	String strthisrole = ds.toGBK(ds.toString((String)request.getParameter("role")));
	String strthissex = ds.toGBK(ds.toString((String)request.getParameter("sex")));
	String strthisnation = ds.toGBK(ds.toString((String)request.getParameter("nation")));
	String strthispolitics = ds.toGBK(ds.toString((String)request.getParameter("politics")));
	String strthiscertid = ds.toGBK(ds.toString((String)request.getParameter("certid")));
	String strthisfromschool = ds.toGBK(ds.toString((String)request.getParameter("fromschool")));
	String strthisschooltime = ds.toGBK(ds.toString((String)request.getParameter("schooltime")));
	String strthisbirth = ds.toGBK(ds.toString((String)request.getParameter("birth")));
	String strthisaddr = ds.toGBK(ds.toString((String)request.getParameter("addr")));
	String strthisspeciality = ds.toGBK(ds.toString((String)request.getParameter("speciality")));
	String strthiseducation = ds.toGBK(ds.toString((String)request.getParameter("education")));
	String strthispost = ds.toGBK(ds.toString((String)request.getParameter("post")));
	String strthisofficetel = ds.toGBK(ds.toString((String)request.getParameter("officetel")));
	String strthismobile = ds.toGBK(ds.toString((String)request.getParameter("mobile")));
	String strthishometel = ds.toGBK(ds.toString((String)request.getParameter("hometel")));
	String strthisemail = ds.toGBK(ds.toString((String)request.getParameter("email")));
	String strthiscollege = ds.toGBK(ds.toString((String)request.getParameter("college")));
	String strthisgroup = ds.toGBK(ds.toString((String)request.getParameter("group")));
	String strthisdepartment = ds.toGBK(ds.toString((String)request.getParameter("department")));
	String strthisorient = ds.toGBK(ds.toString((String)request.getParameter("orient")));
	String strthistxt_fxmc = ds.toGBK(ds.toString((String)request.getParameter("txt_fxmc")));
	String strthisproject = ds.toGBK(ds.toString((String)request.getParameter("project")));
	String strthistasks = ds.toGBK(ds.toString((String)request.getParameter("tasks")));
	String strthisprize = ds.toGBK(ds.toString((String)request.getParameter("prize")));
	String strthisdescs = ds.toGBK(ds.toString((String)request.getParameter("descs")));

	Vector vectrole = new Vector();
	Vector vectcollege = new Vector();
	Vector vectgroup = new Vector();
	Vector vectdepartment = new Vector();
	Vector vectproject = new Vector();
	Vector vecttask = new Vector();

	//所有角色
	sql = "select * from kjc_role";
	vectrole =(Vector)myBean.getDataBySql(sql);

	//所有学院
	sql = "select * from kjc_college";
	vectcollege = (Vector)myBean.getDataBySql(sql);
	Hashtable hashtempcollege = (Hashtable)vectcollege.get(0);
	if(strthiscollege.equals("")){
		strthiscollege = ds.toString((String)hashtempcollege.get("id"));
	}

	//所有梯队
	sql = "select * from kjc_group where college="+strthiscollege+"";
	vectgroup = (Vector)myBean.getDataBySql(sql);

	//所有科室
	sql = "select * from kjc_department where college="+strthiscollege+"";
	vectdepartment = (Vector)myBean.getDataBySql(sql);

	//所有纵向项目
	sql = "select * from kjc_project";
	vectproject = (Vector)myBean.getDataBySql(sql);

	//所有横向课题
	sql = "select * from kjc_task";
	vecttask = (Vector)myBean.getDataBySql(sql);


%>
<html>
<head>
<link rel=stylesheet href="../index.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户配置</title>
  <script language="javascript">
	  function gochange(){
		document.all.form1.action = "../user/new.jsp";
		document.all.form1.submit();
	  }


	  function go(){
		 if(document.all.name.value==""
			||document.all.workid.value==""
			||document.all.password.value=="")
		  {
				alert("姓名、工号、密码必填!");
		  }
		  else if(document.all.college[document.all.college.selectedIndex].value=="0"
			||document.all.department[document.all.department.selectedIndex].value=="0")
		  {
				alert("请检查学院、梯队、科室是否选择,为必填项!");
		  }
		  else
		  {
			  document.all.form1.action="add.cgi";
			  document.all.form1.submit();
		  }
	  }
  </script>
</head>

<body>
      <td>&nbsp;</td>
<form name="form1" method="post" action="add.cgi">
  <table width="100%" height="20"  border="0" cellpadding="0" cellspacing="0">
    <tr>
    </tr>
  </table>
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="40">&nbsp;</td>
      <td width="910"><table width="100%" height="20"  border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="20" class="title_s"><img src="../pics/login.gif" width=50>&nbsp;欢迎您>><%=(String)session.getAttribute("NAME")%> </td>
          </tr>
          <tr>
            <td height="5" bgcolor="#C8F8BA"></td>
          </tr>
          <tr>
            <td height="1" bgcolor="#2E990F"></td>
          </tr>
      </table></td>
      <td width="50">&nbsp;</td>
    </tr>
  </table>
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="40">&nbsp;</td>
      <td width="910">
        <table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
          <tr bgcolor="#FFFFFF" class="title_s">
            <td height="20" colspan="2"><div align="center">添加用户</div>
                <div align="center"></div></td>
          </tr>
          <tr class="title_s">
            <td width="45%" height="20"><div align="center" class="title_s">
                <div align="center">用户姓名:</div>
            </div></td>
            <td width="55%" height="20" class="main_w">
              <div align="left">
                <input name="name" type="text" id="name" value="<%=strthisname%>">
            *</div></td>
          </tr>
          <tr>
            <td height="20" class="title_s"><div align="center" class="title_s">学号:</div></td>
            <td height="20"><div align="center" class="title_s">
                <div align="left">
                  <input name="workid" type="text" id="workid" value="<%=strthisworkid%>">
                *</div>
            </div></td>
          </tr>
          <tr>
            <td height="20" class="title_s"><div align="center">密&nbsp;&nbsp;&nbsp; 码:</div></td>
            <td height="20">              <div align="left">
                <input name="password" type="password" id="password" value="<%=strthispassword%>">
                <span class="title_s">*</span></div></td>
          </tr>
          <tr>
            <td height="20" class="title_s"><div align="center">用户角色:</div></td>
            <td height="20"><select name="role">
				<%
				for(int i=0;i<vectrole.size();i++){
					Hashtable hashrole = (Hashtable)vectrole.get(i);
					String strtempid = ds.toString((String)hashrole.get("id"));
					String strtempname = ds.toString((String)hashrole.get("name"));
				%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -