当前位置: 代码迷 >> Eclipse >> 用JSP展示数据库表字段名
  详细解决方案

用JSP展示数据库表字段名

热度:92   发布时间:2016-04-23 14:47:00.0
用JSP显示数据库表字段名
怎样用JSP显示数据库表字段名,能否粘一段代码,谢谢!

------解决方案--------------------
什么意思?说清楚点。
------解决方案--------------------
当然是用动态方法将数据库列名查询出来然后通过对象传到页面上进行显示啊,我觉得没有别的方法。
------解决方案--------------------
我是这样做的,你可以参考以下:
<%
String month=request.getParameter( "month ");
String title= "工资表 ";
String sql= "SELECT * FROM tb_wage ORDER BY wageDate desc ";
if(month!=null && !month.equals( " ")){
sql= "SELECT * FROM tb_wage where wageDate= ' "+month+ " ' ORDER BY wageDate desc ";
title=month+title;
}
System.out.println( "SQL: "+sql);
ResultSet rs=conn.executeQuery(sql);
%>


<body>
<form name= "form1 " method= "post " action= "index.jsp ">
<table>
<tr>
<td width= "37 " height= "27 " align= "center " bgcolor= "#efefef "> 编号 </td>
<td width= "152 " align= "center " bgcolor= "#efefef "> 员工名称 </td>
<td width= "106 " align= "center " bgcolor= "#efefef "> 月份 </td>
<td width= "85 " align= "center " bgcolor= "#efefef "> 奖金 </td>
</tr>
<%
int i=1;
String name= " ";
String wageDate= " ";
float award=0f;
try{
while(rs.next()){
name=rs.getString(2);
wageDate=rs.getString(3);
award=rs.getFloat(4);
%>
<tr>
<td height= "25 " align= "center " bgcolor= "#FFFFFF "> <%=i%> </td>
<td align= "center " bgcolor= "#FFFFFF "> &nbsp; <%=name%> </td>
<td align= "center " bgcolor= "#FFFFFF "> &nbsp; <%=wageDate%> </td>
<td align= "center " bgcolor= "#FFFFFF "> &nbsp; <%=award%> </td>
</tr>
<%
i++;
}
}catch(Exception e){
System.out.println(e.getMessage());
}
%>
</table>
</body>
  相关解决方案