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

📄 stumana.jsp

📁 高校科研论文管理系统 (cskang@126.com)
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>学生个人信息维护</title>
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
body {
	background-image: url(image/bg_002.gif);
}
-->
</style></head>

<script language="JavaScript" type="text/JavaScript">
function checkBig()
{
  if (document.form1.sPass.value=="")
  {
    alert("密码不能为空！");
    document.form1.sPass.focus();
    return false;
  }
  else if (document.form1.sPassagn.value=="")
  {
    alert("再次输入密码！");
    document.form1.sPassagn.focus();
    return false;
  }
  else if (document.form1.sPass.value!=document.form1.sPassagn.value)
  {
    alert("两次密码不同！");
    document.form1.sPass.focus();
    return false;
  }
}

function setDis()
{
  document.forms[0].sId.disabled = true;
  document.forms[0].sName.disabled = true;
}
</script>
<body onload="setDis()">
<%
String loginNum=(String)session.getAttribute("lnum");
String name=(String)session.getAttribute("name");
session.setAttribute("lnum",loginNum);
session.setAttribute("name",name);
	Connection conn=null;
	Statement stmt=null;
	ResultSet rs=null;
	String sId=null;
	String sName=null;
	String dId=null;
	String cId=null;
	String dName=null;
	String userSex=null;
	String userEmail=null;
	String userMobile=null;
	String userTel=null;
	String userPost=null;
	String userAddress=null;
	String userLike=null;
	String userMovie=null;
	String userGame=null;
	String userBook=null;
	String userUnion=null;
	String userSelf=null;
	String userSport=null;
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn=DriverManager.getConnection("jdbc:odbc:xk","sa","");
		String sql="select * from student,stuDetail where student.sId='"+name+"' and stuDetail.userID ='"+name+"'";
		System.out.println(sql);
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		if(rs.next())
		{
			sId=rs.getString("sId");
			sName=rs.getString("sName");
			dId=rs.getString("dId");
			cId=rs.getString("cId");
			 userSex=rs.getString("userSex");
			 userEmail=rs.getString("userEmail");
			 userMobile=rs.getString("userMobil");
			 userTel=rs.getString("userTel");
			 userPost=rs.getString("userPost");
			 userAddress=rs.getString("userAddress");
			 userLike=rs.getString("userLike");
			 userMovie=rs.getString("userMovie");
			 userGame=rs.getString("userGame");
			 userBook=rs.getString("userBook");
			 userUnion=rs.getString("userUnion");
			 userSelf=rs.getString("userSelf");
			 userSport=rs.getString("userSport");
		}
		Connection connd=null;
		Statement stmtd=null;
		ResultSet rsd=null;
		connd=DriverManager.getConnection("jdbc:odbc:xk","sa","");
		stmtd=connd.createStatement();
		rsd=stmtd.executeQuery("select dName from department where dId='"+dId+"'");
		if(rsd.next())
		{
			dName=rsd.getString(1);
		}
	}
	catch(Exception e)
	{
		out.println(e);
	}
if(loginNum.equals("1"))
{
%>
 <form name="form1" method="post" action="stuManaInfo.jsp" onsubmit="">
<table width="350" border="0" align="center" cellpadding="0" cellspacing="2" class="border">
  <tr bgcolor="#999999" class="title">
    <td height="25" colspan="2" align="center"><strong>学生个人信息维护</strong></td>
  </tr>
   <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>证件号：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="sId" type="text" id="sId" value="<%=sId %>" size="20" maxlength="30" />
    </div></td>
  </tr>
  <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>姓名：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="sName" type="text" id="sName" value="<%=sName %>"size="20" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>性别：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <select name="userSex">
<%
  if(userSex.equals("男        "))
  {
	  out.println(" <option value=男 selected>男</option>");
	  out.println("<option value=女>女</option>");
  }
  else{
	  out.println(" <option value=男 >男</option>");
	  out.println("<option value=女 selected>女</option>");
  }
%>

      </select>
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>邮箱：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userEmail" type="text" id="userEmail" value="<%=userEmail %>" size="20" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>移动电话：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userMobile" type="text" id="userMobile" value="<%=userMobile %>" size="20" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>固定电话：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userTel" type="text" id="userTel" value="<%=userTel %>" size="20" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>邮编：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userPost" type="text" id="userPost" value="<%=userPost %>"size="20" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>住址：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userAddress" type="text" id="userAddress" value="<%=userAddress %>" size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>个人爱好：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userLike" type="text" id="userLike" value="<%=userLike %>" size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>爱看的影视：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userMovie" type="text" id="userMovie" value="<%=userMovie%>" size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>爱玩的游戏：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userGame" type="text" id="userGame" value="<%=userGame %>" size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>爱看的书：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userBook" type="text" id="userBook" value="<%=userBook %>"size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>加入的社团：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userUnion" type="text" id="userUnion" value="<%=userUnion %>"size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>喜爱的运动：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userSport" type="text" id="userSport" value="<%=userSport %>" size="30" maxlength="30" />
    </div></td>
  </tr>
     <tr bgcolor="#E3E3E3" class="tdbg">
    <td width="101" height="22" bgcolor="#C0C0C0"><div align="left"><strong>自我评价：</strong></div></td>
    <td width="243" bgcolor="#E3E3E3"><div align="left">
      <input name="userSelf" type="text" id="userSelf" size="30" value="<%=userSelf %>"maxlength="30" />
    </div></td>
  </tr>
  <tr bgcolor="#C0C0C0" class="tdbg">
    <td height="22" align="center" bgcolor="#C0C0C0">&nbsp;</td>
    <td height="22" align="center" bgcolor="#E3E3E3"><div align="left">
      <input name="Add" type="submit" value=" 修 改 " />
    </div></td>
  </tr>
</table>
</form>
<%
}
else
{out.println("请先登陆.....");
out.print("<a href=../index.jsp>登陆页面</a>");
}
%>
</body>
</html>

⌨️ 快捷键说明

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