con=DatabaseConnection.getDBConnection();
Statement st = con.createStatement();
if((condition!=null)&&(!condition.trim().equals("")))
{
c = " WHERE "+ condition;
}
String q1 = "SELECT COUNT(*) AS total FROM shangpin "+c;
ResultSet rs1 = st.executeQuery(q1);
int total = 0;
if(rs1.next())
{
total = rs1.getInt("total");
}
pageBean.setMaxRowCount(total);
pageBean.setMaxPage();
int num = pageBean.getRowsPerPage();
int start = (pageNum-1)*num;
String q2="SELECT * FROM shangpin "+c+" limit "+start+","+num;
ResultSet rs2 = st.executeQuery(q2);
Vector v = new Vector();
User user;
其中的sql语句q2是在mysql中能够使用的,但是我发现在sql2000中就不能使用了,但是如果我想保持其他地方不变,这个sql2000中的sql语句该怎么改呢?
Statement st = con.createStatement();
if((condition!=null)&&(!condition.trim().equals("")))
{
c = " WHERE "+ condition;
}
String q1 = "SELECT COUNT(*) AS total FROM shangpin "+c;
ResultSet rs1 = st.executeQuery(q1);
int total = 0;
if(rs1.next())
{
total = rs1.getInt("total");
}
pageBean.setMaxRowCount(total);
pageBean.setMaxPage();
int num = pageBean.getRowsPerPage();
int start = (pageNum-1)*num;
String q2="SELECT * FROM shangpin "+c+" limit "+start+","+num;
ResultSet rs2 = st.executeQuery(q2);
Vector v = new Vector();
User user;
其中的sql语句q2是在mysql中能够使用的,但是我发现在sql2000中就不能使用了,但是如果我想保持其他地方不变,这个sql2000中的sql语句该怎么改呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货