8.0w+
社区成员
如何把一个记录里的所有字段显示出来？
用select * from mytable;可以得到全部字段。如何可以把全部字段显示出来？？？就是说我不知道，或不想敲语句挨个显示字段？？？
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
maplewind 2001-10-23
谢谢几位的帮助。
zhjx_10 2001-10-23
<html>
<head>
<title>Get ResultSet</title>
</head>
<%@ page import="java.sql.*" %>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql:///wroxjsp?user=root&password=");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from employee,dept,city");
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
out.println("<table border='1'>");
String thisLine = "";
for ( int i=0; i<columnCount; i++ ) {
thisLine += "<td>" + rsmd.getColumnLabel(i+1) + "</td>";
}
out.println("<tr>" + thisLine + "</tr>");
while ( rs.next() ) {
thisLine ="";
for ( int i=0; i<columnCount; i++ ) {
thisLine += "<td>" + rs.getString(i+1) + "</td>";
}
out.println("<tr>" + thisLine + "</tr>");
}
rs.close();
st.close();
conn.close();
%>
</body>
</html>
上面是一段程序，连接的是mysql数据库，看看是否对你有用
<head>
<title>Get ResultSet</title>
</head>
<%@ page import="java.sql.*" %>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql:///wroxjsp?user=root&password=");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from employee,dept,city");
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
out.println("<table border='1'>");
String thisLine = "";
for ( int i=0; i<columnCount; i++ ) {
thisLine += "<td>" + rsmd.getColumnLabel(i+1) + "</td>";
}
out.println("<tr>" + thisLine + "</tr>");
while ( rs.next() ) {
thisLine ="";
for ( int i=0; i<columnCount; i++ ) {
thisLine += "<td>" + rs.getString(i+1) + "</td>";
}
out.println("<tr>" + thisLine + "</tr>");
}
rs.close();
st.close();
conn.close();
%>
</body>
</html>
上面是一段程序，连接的是mysql数据库，看看是否对你有用
maplewind 2001-10-23
看不太懂。我刚学。请多指教
能否把从连接数据库到jsp显示都告诉我。谢谢。
能否把从连接数据库到jsp显示都告诉我。谢谢。
kcb111 2001-10-22
用下面这个Bean吧。记得给分啊。
//====================== RsBean.java =====================
import java.io.Serializable;
import java.sql.*;
public class RsBean implements java.io.Serializable
{
ResultSet rs = null;
String rsString = "";
public RsBean()
{ }
public void setRs(ResultSet rs)
{
this.rs=rs;
}
public ResultSet getRs()
{
return rs;
}
public void setRsString(String rsStr)
{
rsString = new String(rsStr);
}
public String getRsString() throws Exception
{
ResultSetMetaData md = rs.getMetaData();
int colCount = md.getColumnCount();
String colLabel[] = new String[colCount + 1];
StringBuffer sb=new StringBuffer();
sb.append("<TABLE BORDER=1>");
sb.append("<TR>");
for (int i=1; i<=colCount; i++)
{
colLabel[i] = md.getColumnLabel(i);
sb.append("<TD>"+colLabel[i]+"</TD>");
}
sb.append("</TR>");
while (rs.next())
{
sb.append("<TR>");
for (int i=1; i<=colCount; i++)
{
String s = (String)rs.getString(i);
sb.append("<TD>" + s + "</TD>");
}
sb.append("</TR>");
}
sb.append("</TABLE>");
return sb.toString();
}
}
/////////END
//====================== RsBean.java =====================
import java.io.Serializable;
import java.sql.*;
public class RsBean implements java.io.Serializable
{
ResultSet rs = null;
String rsString = "";
public RsBean()
{ }
public void setRs(ResultSet rs)
{
this.rs=rs;
}
public ResultSet getRs()
{
return rs;
}
public void setRsString(String rsStr)
{
rsString = new String(rsStr);
}
public String getRsString() throws Exception
{
ResultSetMetaData md = rs.getMetaData();
int colCount = md.getColumnCount();
String colLabel[] = new String[colCount + 1];
StringBuffer sb=new StringBuffer();
sb.append("<TABLE BORDER=1>");
sb.append("<TR>");
for (int i=1; i<=colCount; i++)
{
colLabel[i] = md.getColumnLabel(i);
sb.append("<TD>"+colLabel[i]+"</TD>");
}
sb.append("</TR>");
while (rs.next())
{
sb.append("<TR>");
for (int i=1; i<=colCount; i++)
{
String s = (String)rs.getString(i);
sb.append("<TD>" + s + "</TD>");
}
sb.append("</TR>");
}
sb.append("</TABLE>");
return sb.toString();
}
}
/////////END
maplewind 2001-10-22
请具体说明用法好吗？
zhjx_10 2001-10-22
用ResultSetMetaData
