急啊``在线等``大家来看看

[crazyhardy]

用JSP连MYSQL..以TABLE的形式显示``但是``怎么给指定的一条记录(即一行)加上背景颜色??

[crazyhardy]

好似不是太明白如何使用..假如我在以下程序中查id=2的变颜色..那应该如何??
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
Statement sql=null;
ResultSet rs=null;

try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();

//out.print("success1");
}
catch (ClassNotFoundException e)
{}
try
{
String url="jdbc:mysql://localhost:3306/abc";
conn=DriverManager.getConnection(url,"root","feng");
//out.print("success2");

sql=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = sql.executeQuery("select * from yes");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"id");
out.print("<TH width=100>"+"name");
out.print("<TH width=100>"+"number");
out.print("</TR>");
while (rs.next())
{
out.print("<TR>");
int id=rs.getInt(1);
out.print("<TD>"+id+"</TD>");
String name=rs.getString(2);
out.print("<TD>"+name+"</TD>");
String number=rs.getString(3);
out.print("<TD>"+number+"</TD>");
out.print("</TR>");
}
out.print("<Table>");
conn.close();
}
catch (SQLException e){}
%>
可以再详细一点教教吗？???

[crazyhardy]

没人可以帮帮忙吗？??真得很急``我试了很好多次都失败```

[infowain]

这是html的问题了，设置表格的background color

[polarman]

<table>
<tr bgcolor="#A0B0FF"><td>test</td></tr>
<tr><td>test</td></tr>
</table>

[loveyt]

<%
String trClass = "";

if (nowID = theID){
trClass = "style=\"background-color:#0000FF; \"";
%>
<%
}
%>
<tr <%= trClass %>>
......