- 论坛徽章:
- 0
|
在windows下可以正常运行的jsp代码,为什么拿到unix下的就运行不正常了,表格的内容只显示了一条记录,下面的记录都没有显示出来,为什么?在windows下是可以全部显示的
我刚注册的,还没有积分,将来我会补给你的!
下面是代码:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="java.util.Date" import="java.text.SimpleDateFormat" %>
<%
//********** 数据库连接代码 开始 ******/
//以下几项请自行修改
String server="localhost"; //MYSQL 服务器的地址
String dbname="gps"; //MYSQL 数据库的名字
String user="root"; //MYSQL 数据库的登录用户名
String pass="root"; //MYSQL 数据库的登录密码
String port="3306";
//加载驱动程序
Class.forName("org.gjt.mm.mysql.Driver");
//建立连接
Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/GPS","gps","gps");
// **** 数据库连接代码 结束 *******
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head>
<body topmargin="0" leftmargin="0">
<font color="#800080" size="6">AR Tracking</font>
<table><tr>
<!-- ****add new records***
<td width="">
<p><a href="AddNewItem.jsp" target="_blank"><img src="/add.gif" width="30" height="30" border="0" alt="Add New Item" >Addition</a>
 </td>
-->
<td align ="center" valign="bottom">
<form action="Filter.jsp" method="post" target="_blank"><b><font color="#000080" size="4">Filter According to</font></b>
<select name="GpsOwner">
<option value=""> -GPS_OWNER-</option>
<option value="zhenle">zhenle</option>
<option value="hezhao">hezhao</option>
<option value="chenp">chenp</option>
<option value="mdu">mdu</option>
<option value="xdang">xdang</option>
<option value="diw">diw</option>
<option value="xiaoyawa">xiaoyawa</option>
<option value="yangdl">yangdl</option>
<option value="haiqianh">haiqianh</option>
<option value="jhe004">jhe004</option>
<option value="lxie001">lxie001</option>
<option value="ruwang">ruwang</option>
<option value="tajin">tajin</option>
<option value="lfeng003">lfeng003</option>
<option value="jianliaw">jianliaw</option>
</select>
<b><font color="#000080" size="4">And</font></b>
<select name="StateName">
<option value=""> -SATATENAME-</option>
<option value="Closed">UnClosed</option>
<option value="In Progress">In Progress</option>
<option value="Pending">Pending</option>
<option value="Resolved">Resolved</option>
<option value="Re-Assigned">Re-Assigned</option>
</select>
 
<input type="submit" value="sumbit"/>  
<input type="reset" value="reset"/>
</form>
</td></tr></table>
<hr width="180%">
<table border="1" bordercolorlight="#008080" width="180%" style="border-collapse: collapse">
<tr bgcolor="#5CADAD" height="40">
<td width="100"><b><font color="#000080" size="4">Update</font></b></td>
<td width="100"><b><font color="#000080" size="4">AR_NUMBER:</font></b></td>
<td width="100" ><b><font color="#000080" size="4">TITLE:</font></b> </td>
<td width="150"><b><font color="#000080" size="4">GPS_OWNER:</font></b>  </td>
<td width="30%"><b><font color="#000080" size="4">STATUS_SUMMARY:</font></b>  </td>
<td width="13%"><b><font color="#000080" size="4">SITE_COMPANY:</font></b>  </td>
<td width="10%"><b><font color="#000080" size="4">SEVERITY:</font></b></td>
<td width="10%"><b><font color="#000080" size="4">PRODUCT_VERSION:</font></b></td>
<td width="20%"><b><font color="#000080" size="4">PRODUCT:</font></b>  </td>
<td width="10%"><b><font color="#000080" size="4">STATENAME:</font></b></td>
<td width="20%"><b><font color="#000080" size="4">STATE_REASON:</font></b>  </td>
<td width="10%"><b><font color="#000080" size="4">CRID</font></b></td>
<td width="20%"><b><font color="#000080" size="4">ASSIGNED_GROUP:</font></b>  </td>
<td width="10%"><b><font color="#000080" size="4">ASSIGNEE:</font></b></td>
<td width="200px"><b><font color="#000080" size="4">OWNER_GROUP:</font></b>  </td>
<td width="200px"><b><font color="#000080" size="4">Date_Update:</font></b>  </td>
<td width="200px"><b><font color="#000080" size="4">TARGET_RESOLVE_DATE:</font></b>  </td>
<td width="200px"><b><font color="#000080" size="4">GPS_ASSIGNEE:</font></b>  </td>
<td width="200px"><b><font color="#000080" size="4">Flow:</font></b>  </td>
<td width="200px"><b><font color="#000080" size="4">AGE:</font></b>  </td>
</tr>
<%
Date date = new Date(); //创建Date对象date
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String td=formatter.format(date);
try{
Statement stmt=conn.createStatement();
String sql="select * from ar_tracking ORDER BY AR_NUMBER DESC";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr bgcolor="#F0F0F0">
<td width="10%" align="center"><a href="EditArTrackingDetails.jsp?AR_Number=<%=rs.getString("AR_NUMBER")%>" target="_blank"><img src="/write.gif" align="middle" width="20" height="20" border="0" alt="Edit Deatils"></a></td>
<td><%=rs.getString("AR_NUMBER")%></td>
<td><%=rs.getString("TITLE")%></td>
<td width="13%"><%=rs.getString("GPS_OWNER")%></td>
<td width="30%"><%=rs.getString("STATUS_SUMMARY")%></td>
<td width="13%"><%=rs.getString("SITE_COMPANY")%></td>
<td width="10%"><%=rs.getString("SEVERITY")%></td>
<td width="10%"><%=rs.getString("PRODUCT_VERSION")%></td>
<td width="20%"><%=rs.getString("PRODUCT")%></td>
<td width="10%"><%=rs.getString("STATENAME")%></td>
<td width="20%"><%=rs.getString("STATE_REASON")%></td>
<td width="10%"><%=rs.getString("CRID")%></td>
<td width="20%"><%=rs.getString("ASSIGNED_GROUP")%></td>
<td width="10%"><%=rs.getString("ASSIGNEE")%></td>
<td width="200px"><%=rs.getString("OWNER_GROUP")%></td>
<td width="200px"><%=rs.getString("Date")%></td>
<td width="200px"><%=rs.getString("TARGET_RESOLVE_DATE")%></td>
<td width="200px"><%=rs.getString("GPS_Assignee")%></td>
<td width="200px"><%=rs.getString("Flow")%></td>
<td width="200px"><%=rs.getString("AGE")%></td></tr>
<%
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</table>
</body>
</html>
[ 本帖最后由 linwang824 于 2009-4-14 14:04 编辑 ] |
|