我用jsp连接数据库,我用odbc实现了,但 还有个问题,我想让性别相同的列显示相同的颜色,我始终都弄不出来?请教
代码:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head></head>
<body>
<table border=3>
<tr><td><b>学生学号</td>
<td><b>学生姓名</td>
<td><b>学生性别</td>
<td><b>学生年龄</td></tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:sun";
Connection conn = DriverManager.getConnection(url,"hq","123");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM good");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getInt(4)+"</td>");
out.print("</tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html
代码:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head></head>
<body>
<table border=3>
<tr><td><b>学生学号</td>
<td><b>学生姓名</td>
<td><b>学生性别</td>
<td><b>学生年龄</td></tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:sun";
Connection conn = DriverManager.getConnection(url,"hq","123");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM good");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getInt(4)+"</td>");
out.print("</tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html
解决方案 »
- HTML表单调用JS方法无效果!
- 下拉框和文本框级联
- Spring管理Struts的dispatchaction问题
- 请问 在jsp页面中怎样获得上传文件的文件名(带扩展名)呢?
- 急用,请各位前辈,倾囊而诤
- jdbc
- 高分求助jive2.0版在jbuildx中的问题...
- 用JSP怎样得到浏览者的浏览分辨率(如1024*768)和浏览者来访的页面?
- TOMCAT中,怎样设置Tomcat Administration和Tomcat Manager?
- Can't start a cloned connection while in manual transaction mode是什么异常
- jsp问题
- java是runtime的难题
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:sun";
Connection conn = DriverManager.getConnection(url,"hq","123");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM good");
String gender;
while(rs.next())
{
out.print(" <tr"+("男".equals(rs.getString(3)?" bgcolor='EEDDFF'":"")+"> ");
out.print(" <td> "+rs.getString(1)+" </td> ");
out.print(" <td> "+rs.getString(2)+" </td> ");
out.print(" <td> "+rs.getString(3)+" </td> ");
out.print(" <td> "+rs.getInt(4)+" </td> ");
out.print(" </tr> ");
}
rs.close();
stmt.close();
conn.close();
%>
另外,建议不要在jsp中做这种操作,即使做也最好使用tag实现,比如jstl提供了现成的:)
out.print("<tr "+color+">"+rs.getString(3)+"</td>"); 不知道这样可不可以解决你的问题
out.print(" <td "+color+"> "+rs.getString(3)+" </td> ");