你可以加我吗?
真的,我调了一晚上。
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="opendate" class="Con_soft.database.sql" scope="page"/>
<%
String sql2 = "select soft.soft_id,soft.soft_name,soft.soft_sys,soft.soft_size,soft.soft_tuijian,soft.soft_hits,soft.soft_intro,soft.add_time,soft.file_name,type.type_id,type.type_name_cn,type_parent.type_parent_id,type_parent.type_parent_cn from soft,type,type_parent where soft.type_id = type.type_id and type.type_parent_id = type_parent.type_parent_id order by soft.add_time desc";
ResultSet rs2 = opendate.sqlQuery(sql2);
String a = rs2.getString(soft_id);
while(rs2.next()){
out.print(a);}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body></body>
</html>
真的,我调了一晚上。
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="opendate" class="Con_soft.database.sql" scope="page"/>
<%
String sql2 = "select soft.soft_id,soft.soft_name,soft.soft_sys,soft.soft_size,soft.soft_tuijian,soft.soft_hits,soft.soft_intro,soft.add_time,soft.file_name,type.type_id,type.type_name_cn,type_parent.type_parent_id,type_parent.type_parent_cn from soft,type,type_parent where soft.type_id = type.type_id and type.type_parent_id = type_parent.type_parent_id order by soft.add_time desc";
ResultSet rs2 = opendate.sqlQuery(sql2);
String a = rs2.getString(soft_id);
while(rs2.next()){
out.print(a);}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body></body>
</html>
放在while(rs2.next()){
out.print(a);}
里
你想想soft_id是db的column啊,或者建议使用:
String a = rs2.getString(0);
rs:getString()的参数可以为int, String,前者效率上有优势~~
数据库解析,应该
String a = rs2.getString("soft_id");
才对
这是resin控制台的提示,页面改正如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="opendate" class="Con_soft.database.sql" scope="page"/>
<%
String sql2 = "select soft.soft_id,soft.type_id,soft.soft_name,soft.soft_sys,soft.soft_size,soft.soft_tuijian,soft.soft_hits,soft.soft_intro,soft.add_time,soft.file_name,type.type_id,type.type_parent_id,type.type_name_en,type.type_name_cn,type.type_order_id,type_parent.type_parent_id,type_parent.type_parent_en,type_parent.type_parent_cn,type_parent.parent_order_id from soft,type,type_parent where soft.type_id = type.type_id and type.type_parent_id = type_parent.type_parent_id order by soft.add_time desc";
ResultSet rs2 = opendate.sqlQuery(sql2);
while(rs2.next()){
String a = rs2.getString("soft.soft_id");
out.print(a + "<br>");}
rs2.close();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body></body>
</html>