opencms mysql_老师们，请教一个opencms+mysql做网站的问题，在一个页面中显示产品图片，并作出可以跳转到用户订单的图片...

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("

//out.println("

");

while(rspage.next()){

out.println("

");

//out.println("ding gou zi chan pincha kan ci chan pin xiang");

out.println("

");

}

out.println("

");

//if(rs.next())

//if(rs.getString(2).equals(userNamea)){

//out.print("login successfully");

//report report1;

//report1.loginSuccessfully();

//out.println("

//if( rs.getString(1).equals(userPwd) ){

//out.println("

//out.println("");}else{

//out.println("

//out.println("");

//}

//}

//else{

//out.println("

//out.println("");

//}}

rspage.close();

rs.close();

sql.close();

conn.close();

}catch(SQLException e1){out.print(e1);}

%>

可图片不出来，求解

展开