81,092
社区成员
发帖
与我相关
我的任务
分享
<tr>
<td width="110" height="30" align="center" valign="middle"
bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_time%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==1?str:"" %>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==2?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==3?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==4?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==5?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==6?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==7?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==8?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==9?str:""%>
</td>
<td width="82" align="center" valign="middle" bordercolor="#000000"
class="STYLE22 STYLE25"> <%=s_number==10?str:""%>
</td>
</tr>
<%
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
Connection conn = ds.getConnection();
if(conn==null){
out.print("未获得数据连接");
return;
}
PreparedStatement ps = null;
ResultSet rs = null;
try{
ps = conn.createStatement();
rs = ps.executeQuery("select * from wen");
if(rs!=null){
String s_time = "",str = "";
int s_number = 0;
while(rs.next()) {
s_time = rs.getString("time");
s_number = Integer.parseInt(rs.getString("number"));
str = rs.getString("wendu");
%>
<tr>
<td width="110" height="30" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_time%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==1?str:"" %> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==2?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==3?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==4?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==5?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==6?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==7?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==8?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==9?str:""%> </td>
<td width="82" align="center" valign="middle" bordercolor="#000000" class="STYLE22 STYLE25"> <%=s_number==10?str:""%> </td>
</tr>
<%
}
}
}catch(Exception e){
e.printStackTrace();
}finally{
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
ps = null;
}
if(con!=null){
conn.close();
conn = null;
}
}
%>