📄 show.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ 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' />
<jsp:useBean id='dealstring' scope='request' class='com.util.DealString' />
<%	
	com.util.DealString ds = new com.util.DealString();
	com.db.CommonBean myBean = new com.db.CommonBean();
	String strTime = (ds.getDateTime()).substring(0,4);
%>
<html>
<head>
<link rel=stylesheet href="../index.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户配置</title>
</head>
<body>
<%
String orients=null;
String[] ids=dealstring.splitStr(db.getAttributeStr("people.orients"),',');
for(int i=0;i<ids.length;i++){
	for(int j=0;j<db.getCount("orient");j++){
		if(db.getAttributeStr("orient.id",j).equals(ids[i])){
			if(orients!=null){
				orients+=db.getAttributeStr("orient.name",j)+" ";
			}else{
				orients=db.getAttributeStr("orient.name",j)+" ";
			}
		}
	}
}
//取得本年横向项目、纵向项目、鉴定项目、奖励项目
String strThisId = ds.toString((String)db.getAttributeStr("people.id"));
String strThisName = ds.toString((String)db.getAttributeStr("people.name"));
String uid = ds.toString((String)session.getAttribute("ID"));
boolean ifsame = strThisId.equals(uid);
String sql = "";

//取得本年横向项目
sql = " select * from kjc2_crossproject "
	+ " where hzbz='1' "
	+ " and (zywcr='"+strThisId+"' "
	+ " or zywcr like '"+strThisId+",%' "
	+ " or zywcr like '%,"+strThisId+",%' "
	+ " or zywcr like '%,"+strThisId+"') "
	+ " and jtsj like '"+strTime+"%' "
	+ " order by jtsj desc ";
Vector vecth = (Vector)myBean.getDataBySql(sql);

//取得本年纵向项目
sql = " select * from kjc2_crossproject "
	+ " where hzbz='0' "
	+ " and (zywcr='"+strThisId+"' "
	+ " or zywcr like '"+strThisId+",%' "
	+ " or zywcr like '%,"+strThisId+",%' "
	+ " or zywcr like '%,"+strThisId+"') "
	+ " and jtsj like '"+strTime+"%' "
	+ " order by jtsj desc ";
Vector vectz = (Vector)myBean.getDataBySql(sql);

//取得本年奖励项目
sql = "select * from kjc2_prizeproject "
	+ " where wcr='"+strThisName+"' "
	+ " or wcr like '"+strThisName+",%' "
	+ " or wcr like '%,"+strThisName+",%' "
	+ " or wcr like '%,"+strThisName+"' ";
Vector vectprize = (Vector)myBean.getDataBySql(sql);

//取得本年鉴定项目
sql = "select * from kjc2_checkupproject "
	+ " where (wcr='"+strThisId+"' "
	+ " or wcr like '"+strThisId+",%' "
	+ " or wcr like '%,"+strThisId+",%' "
	+ " or wcr like '%,"+strThisId+"') "
	+ " and jdsj like '"+strTime+"%' "
	+ " order by jdsj desc ";
Vector vectcheck = (Vector)myBean.getDataBySql(sql);

//取得论文
sql = "select * from kjc2_paper "
	+ " where zz = '"+strThisName+"'";
Vector vectpaper = (Vector)myBean.getDataBySql(sql);

//取得专著
sql = "select * from kjc2_bookstatistic "
	+ " where zz = '"+strThisName+"'";
Vector vectstatic = (Vector)myBean.getDataBySql(sql);

%>

<table width="100%" height="20"  border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td>&nbsp;</td>
    </tr>
  </table>
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="25">&nbsp;</td>
      <td width="790">
			<table width="100%"  border="0" cellpadding="0" cellspacing="0">
			  <tr>
				<td width="10">&nbsp;</td>
				<td width="*"><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><%if(ifsame){%><td align=right class="title_s">[<a href="../user/modify.cgi?id=<%=strThisId%>">修改个人信息</a>|<a href="../user/modifypsw.cgi?id=<%=strThisId%>">修改密码</a>]</td><%}%>
					</tr>
					<tr>
					  <td height="5" bgcolor="#C8F8BA" colspan=2></td>
					</tr>
					<tr>
					  <td height="1" bgcolor="#2E990F" colspan=2></td>
					</tr>
				</table></td>
				<td width="30">&nbsp;</td>
			  </tr>
			</table>
	</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  colspan="5"><div align="center">个人基本信息</div></td>
          </tr>
          <tr>
            <td height="20" align="left">
			姓名:<%= db.getAttributeStr("people.name")%>
			</td>
			<td height="20" align=left>
			学号:<%= db.getAttributeStr("people.workid")%>
			</td>
			<td height="20" align=left>
			角色:<%
			for(int x=0;x<db.getCount("role");x++){
				if(db.getAttributeStr("role.id",x).equals(db.getAttributeStr("people.role"))){
			%>
					<%= db.getAttributeStr("role.name",x)%>
			<%
				}
			}
			%>
			</td>
			<td height="20" align=left>
			性别:<%
			  if(db.getAttributeStr("people.sex").equals("1")){
			  %>男
                    <%
			  }else if(db.getAttributeStr("people.sex").equals("0")){
			  %>女
                    <%
			  }
			  %>
			</td>
			<td height="20" align=left>
			民族:<%= db.getAttributeStr("people.nation")%>&nbsp;
			</td>

			</td>
          </tr>
          <tr>
            <td height="20" align="left">
			籍贯:<%= db.getAttributeStr("people.addr")%>
			</td>
            <td height="20" align="left">
			出生日期:<%= db.getAttributeStr("people.birth")%>;
			</td>
			<td height="20" align="left">
			政治面貌:<%
			  String a=db.getAttributeStr("people.politics");
			  if(a.equals("1")){
			  %>
                中共党员
                <%
			  }else if(a.equals("2")){
			  %>
                共青团员
                <%
			  }else if(a.equals("3")){
			  %>
                民族党派
                <%
			  }else if(a.equals("4")){
			  %>
                无党派人士
                <%
			  }else if(a.equals("5")){
			  %>
                群众
                <%
			  }
			  %>
			</td>
			<td height="20" align="left">
			身份证号:<%= db.getAttributeStr("people.certid")%>
			</td>
			<td height="20" align="left">
			学历:<%= db.getAttributeStr("people.education")%>
			</td>
			</td>
		</tr>
        <tr>
			<td height="20" align="left">
			所学专业:<%= db.getAttributeStr("people.speciality")%>
			</td>
			<td height="20" align="left">
			毕业学校:<%= db.getAttributeStr("people.fromschool")%>
			</td>
			<td height="20" align="left">
			毕业时间:<%= db.getAttributeStr("people.schooltime")%>
			</td>
			<td height="20" align="left">
			职称:<%= db.getAttributeStr("people.post")%>
			</td>
			<td height="20" align="left">
			办公电话:<%= db.getAttributeStr("people.officetel")%>
			</td>
		 </tr>
         <tr>
			<td height="20" align="left">
			移动电话:<%= db.getAttributeStr("people.mobile")%>
			</td>
			<td height="20" align="left">
			家庭电话:<%= db.getAttributeStr("people.hometel")%>
			</td>
			<td height="20" align="left">
			Email:<%= db.getAttributeStr("people.email")%>
			</td>
			<td height="20" align="left">
			所在学院:<%= db.getAttributeStr("mycollege.name")%>
			</td>
			<td height="20" align="left">
			所在系所:<%= db.getAttributeStr("mydepartment.name")%>
			</td>
		 </tr>

          <tr>
			<td height="20" align="left">
			所在梯队:<%= db.getAttributeStr("mygroup.name")%>
			</td>
			<td height="20" align="left">
			科研方向:<%= dealstring.toString(orients)%>
			</td>
			<td height="20" align="left" colspan=3>
			获奖情况:<%= db.getAttributeStr("people.prize")%>
			</td>
		 </tr>
         <tr>
			<td height="20" align="left" colspan=5>
			备注:<%= db.getAttributeStr("people.descs")%>
			</td>
		</tr>
		</table>
		<br>
		<hr color=#C8F8BA>
		<table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
			  <tr bgcolor="#FFFFFF" class="title_s">
				<td  colspan="6"><div align="center" title="查看本人全部横向项目......"><a href="../user/listhx.cgi?id=<%=strThisId%>">横向项目</a></div></td>
				<!-- <td><div align="right">查看全部</div></td> -->
			  </tr>
          <tr>
            <td height="20" class="title_s">序号</td>
            <td height="20" class="title_s">项目名称</td>
<!--             <td height="20" class="title_s">登记号</td>
            <td height="20" class="title_s">合同号</td>
 -->            <td height="20" class="title_s">项目类型</td>
            <td height="20" class="title_s">项目负责人</td>
            <td height="20" class="title_s">开始时间</td>
            <td height="20" class="title_s">结题时间</td>
          </tr>
			<%
			int sizeh = vecth.size();
			for(int i=0;i<sizeh;i++){
				Hashtable hashh = (Hashtable)vecth.get(i);
				String str_id = ds.toString((String)hashh.get("id"));
				String str_Djh = ds.toString((String)hashh.get("djh"));
				String str_Hth = ds.toString((String)hashh.get("hth"));
				String str_xmmc = ds.toString((String)hashh.get("xmmc"));
				String str_Xmlx = ds.toString((String)hashh.get("xmlx"));
				String str_XmlxName = ds.toString((String)myBean.toName("kjc2_code","id","code_value",str_Xmlx));

				String str_Ktlyd = ds.toString((String)hashh.get("ktlyd"));
				String str_Xy = ds.toString((String)hashh.get("xy"));
				/*String str_Xys[] = str_Xy.split(",");
				str_Xy = "";
				for(int j=0;j<str_Xys.length;j++){
					String strtemp = ds.toString((String)myBean.toName("kjc_college","id","name",str_Xys[j]));
					if(str_Xy.equals("")) str_Xy += strtemp;
					else str_Xy += ","+strtemp;
				}*/

				String str_Xmfzr = ds.toString((String)hashh.get("xmfzr"));//逗号分割人员表id
				String str_Xmfzrs[] = str_Xmfzr.split(",");
				str_Xmfzr = "";
				for(int j=0;j<str_Xmfzrs.length;j++){
					String strtemp = ds.toString((String)myBean.toName("kjc_people","id","name",str_Xmfzrs[j]));
					if(str_Xmfzr.equals("")) str_Xmfzr += strtemp;
					else str_Xmfzr += ","+strtemp;
				}

				String str_Zywcr = ds.toString((String)hashh.get("zywcr"));//逗号分割人员表id
				String str_wcrxh = ds.toString((String)hashh.get("wcrxh"));//1,3,4
				/*String str_Zywcrs[] = str_Zywcr.split(",");
				String str_wcrxhs[] = str_wcrxh.split(",");
				str_Zywcr = "";
				for(int j=0;j<str_Zywcrs.length;j++){
					String strtemp = ds.toString((String)myBean.toName("kjc_people","id","name",str_Zywcrs[i]));
					if(str_Zywcr.equals("")) str_Zywcr += strtemp+"("+str_wcrxhs[j]+")";
					else str_Zywcr += ","+strtemp+"("+str_wcrxhs[j]+")";
				}*/
				String str_Yjscjr = ds.toString((String)hashh.get("yjscjr"));
				String str_kssj = ds.toString((String)hashh.get("kssj"));
				String str_Jtsj = ds.toString((String)hashh.get("jtsj"));
			%>
				  <tr>
					<td><%=i+1%></td>
					<td><a href="../kjc2_manage/view1.jsp?projectid=<%=str_id%>"><%=str_xmmc%></a></td>
12 下一页
💿 文件大小 28909 K
👤 上传用户 moxcki
📂 所属分类 Java编程
🏷️ 相关标签

#JSP #数据库 #案例 #导航
⌨️ 快捷键说明

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