new192.jsp
<%@page import="org.hibernate.dialect.RDMSOS2200Dialect"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
Connection conn = null;
try
{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String pwd = "mysql123";
conn = DriverManager.getConnection(url,user,pwd);
Statement stmt = conn.createStatement();
String sql = "select * from sp_goodsType where parentId = -1";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
int id = rs.getInt("id");
String typeName = rs.getString("typeName");
int parentId = rs.getInt("parentId");
out.print("<ul>");
out.print("<h1>"+typeName+"</h1>");
String sql2 = "select * from sp_goodsType where parentId=" + id;
Statement stmt2 = conn.createStatement();
ResultSet rs2 = stmt2.executeQuery(sql2);
while(rs2.next())
{
int id2 = rs2.getInt("id");
String typeName2 = rs2.getString("typeName");
out.print("<li><a href='catlist.htm'>"+typeName2+"</a></li>");
}
out.print("</ul>");
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</body>
</html>
