<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> 人才师资 <%@ page import="zxtvictor.site.db.*"%> <% String sql1="SELECT TOP 5 * FROM news WHERE news_Group='collegenews' ORDER BY new_ID DESC"; String sql2="SELECT TOP 5 * FROM news WHERE news_Group='announcement' ORDER BY new_ID DESC"; String sql3="SELECT TOP 25 * FROM news WHERE news_Group='schoolmates' ORDER BY new_ID DESC"; String sql4="SELECT TOP 5 * FROM news WHERE news_group in ('partyinfo','partyknowledge','download',) ORDER BY new_ID DESC"; String sql5="SELECT TOP 5 * FROM news WHERE news_group in ('activitynews','jobguide','activityprofile',) ORDER BY new_ID DESC"; Conn con = new Conn(); ResultSet rs1 = con.getRs(sql1); ResultSet rs2 = con.getRs(sql2); ResultSet rs3 = con.getRs(sql3); ResultSet rs4 = con.getRs(sql4); ResultSet rs5 = con.getRs(sql5); %>
 
<%while(rs1.next()) {int intID=rs1.getInt("new_ID");%> <%}%>
     
  <%=rs1.getString("news_Title")%>  
     
<%while(rs2.next()) {int intID=rs2.getInt("new_ID");%> <%}%>
     
  <%=rs2.getString("news_Title")%>  
     
<%while(rs4.next()) {int intID=rs4.getInt("new_ID");%> <%}%>
  <% String str4=rs4.getString("news_Title"); if(str4.length()>10){ str4=str4.substring(0,8)+"…"; } out.println(str4); %>  
<%while(rs5.next()) {int intID=rs5.getInt("new_ID");%> <%}%>
  <% String str5=rs5.getString("news_Title"); if(str5.length()>10){ str5=str5.substring(0,8)+"…"; } out.println(str5); %>  

 

>>教学任务书

>>教学大纲

>>教学卡片

>>教学课表

>>实验介绍

>>教师简介

[返回]

COPYRIGHT©2006 天津理工大学化学化工学院 ALL RIGHT RESERVED
<%con.close();%>