给你一个例子
你看看就知道了
Connection c = null;
PreparedStatement ps = null;
ResultSet rs = null;
Page ret = null; try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("jdbc:odbc:Jworkflow"); //建立数
ps = c.prepareStatement("select COUNT(*) "
+ "from (category a join "
+ "category_details b on "
+ "a.catid=b.catid) "
+ "where locale = ?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ps.setString(1, l.toString());
rs = ps.executeQuery();
rs.first();
int total = rs.getInt(1);
rs.close();
ps.close(); // Select.
ps = c.prepareStatement("select a.catid, name, descn "
+ "from (category a join "
+ "category_details b on "
+ "a.catid=b.catid) "
+ "where locale = ? "
+ "order by name",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ps.setString(1, l.toString()); rs = ps.executeQuery();
if (start >= 0 && start < total) {
List items = new ArrayList();
rs.absolute(start+1);
do {
items.add(new Category(rs.getString(1).trim(),
rs.getString(2),
rs.getString(3)));
} while (rs.next() && (--count > 0));
ret = new Page(items, start, total);
}
else {
ret = Page.EMPTY_PAGE;
} rs.close();
ps.close(); c.close();
return ret;
}
catch (SQLException se) {
}
}
你看看就知道了
Connection c = null;
PreparedStatement ps = null;
ResultSet rs = null;
Page ret = null; try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("jdbc:odbc:Jworkflow"); //建立数
ps = c.prepareStatement("select COUNT(*) "
+ "from (category a join "
+ "category_details b on "
+ "a.catid=b.catid) "
+ "where locale = ?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ps.setString(1, l.toString());
rs = ps.executeQuery();
rs.first();
int total = rs.getInt(1);
rs.close();
ps.close(); // Select.
ps = c.prepareStatement("select a.catid, name, descn "
+ "from (category a join "
+ "category_details b on "
+ "a.catid=b.catid) "
+ "where locale = ? "
+ "order by name",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ps.setString(1, l.toString()); rs = ps.executeQuery();
if (start >= 0 && start < total) {
List items = new ArrayList();
rs.absolute(start+1);
do {
items.add(new Category(rs.getString(1).trim(),
rs.getString(2),
rs.getString(3)));
} while (rs.next() && (--count > 0));
ret = new Page(items, start, total);
}
else {
ret = Page.EMPTY_PAGE;
} rs.close();
ps.close(); c.close();
return ret;
}
catch (SQLException se) {
}
}
如果是笔误的话!把你的错误信息贴出来!
//==========================<%@ page contentType="text/html; charset=GB2312" %><%@ page import="java.sql.*" %>
<%@ page language="java" %><html>
<head>
<title>
查询数据库,并返回结果
</title>
</head>
<body>
<h1>
查询数据库,并返回结果
</h1>
<%
Connection con=null;
Statement stmt=null;
ResultSet rs =null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
con = DriverManager.getConnection("jdbc:odbc:Jworkflow"); //建立数据库链接
stmt = con.createStatement(); //建立Statement对象
rs = stmt.executeQuery("select * from ryxx where ryid="); //执行SQL语句
%>
<table align=center width=500 border=1 bordercolor=blue>
<tr><td>人员ID</td><td>姓名</td><td>性别</td><td>年龄</td><td>班级编号</td></tr><%//利用while循环将数据表中的记录列出
while (rs.next())
{
%>
<TR bgcolor=white>
<TD><%= rs.getInt("ryid") %></TD>
<TD><%= rs.getString("ryxm") %></TD>
<TD><%= rs.getString("ryxb") %></TD>
<TD><%= rs.getInt("nl") %></TD>
<TD><%= rs.getInt("bjbh") %></TD>
</TR>
<%
}
rs.close(); //关闭ResultSet对象
stmt.close(); //关闭Statement对象
con.close(); //关闭Connection对象
}catch(ClassNotFoundException e){
e.printStackTrace();
System.err.println("OpenDb()"+e.getMessage());
}%></table>
</body>
</html>
//============
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %><html>
<head>
<title>查询数据库,并返回结果</title>
</head>
<body>
<h1>查询数据库,并返回结果</h1>
<%
Connection con=null;
Statement stmt=null;
ResultSet rs =null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
con = DriverManager.getConnection("jdbc:odbc:Jworkflow"); //建立数据库链接
stmt = con.createStatement(); //建立Statement对象
rs = stmt.executeQuery("select * from ryxx where ryid="); //执行SQL语句
%>
<table align=center width=500 border=1 bordercolor=blue>
<tr><td>人员ID</td><td>姓名</td><td>性别</td><td>年龄</td><td>班级编号</td></tr><%// 有结果则显示查询内容
if(rs.next()){
//利用while循环将数据表中的记录列出
do{
%>
<TR bgcolor=white>
<TD><%= rs.getInt("ryid") %></TD>
<TD><%= rs.getString("ryxm") %></TD>
<TD><%= rs.getString("ryxb") %></TD>
<TD><%= rs.getInt("nl") %></TD>
<TD><%= rs.getInt("bjbh") %></TD>
</TR>
<%
}while(rs.next());
}else{
//没有结果则显示提示信息
%>
<TR bgcolor=white><TD colspan="5">没有符合此条件的查询结果!</TD></TR>
<%
}// End if(rs.next())}catch(ClassNotFoundException e){
e.printStackTrace();
System.err.println("OpenDb()"+e.getMessage());
}catch(SQLException sqle){
sqle.printStackTrace();
System.err.println("OpenDb()"+sqle.getMessage());
}catch(Exception ex){
ex.printStackTrace();
System.err.println("OpenDb()"+ex.getMessage());
}finally{
if(rs!=null) rs.close(); //关闭ResultSet对象
if(stmt!=null) stmt.close(); //关闭Statement对象
if(con!=null) con.close(); //关闭Connection对象
}
%>
</table>
</body>
</html>
rs = stmt.executeQuery("select * from ryxx");