<%@ page contentType="text ml;Charset=GB2312"%><%@page import="java.sql.*,org.opencms.db.*,org.opencms.main.*"%><%@ page import="java.util.*"%><%@ page import="java.sql.*"%><%@ page import="com.mysql.jdbc.Driver"%><%@ page import="java.io.*"%><%java.sql.Connection conn = OpenCms.getSqlManager().getConnection("default");Statement sql;ResultSet rs;try{Class.forName("com.mysql.jdbc.Driver");}catch(Exception e){out.print(e);}try{//String uri="jdbc:mysql://localhost:3306/opencms";//String userNamea=request.getParameter("userName");//String userPwd=request.getParameter("userPwd");sql=conn.createStatement();rs=sql.executeQuery("select proId,proName from product where proTypeId='1' order by proId" );int i=1;while(rs.next()){i++;} //String query="select proId,proName from product where proTypeId='1' order by proId";ResultSet rspage;rspage=sql.executeQuery("select proId,proName from product where proTypeId='1' order by proId desc limit 0,1");out.println(" |