劳烦高手帮忙看看是什么错误,怎么改啊,小弟在这多谢多谢!
这是代码
public Collection exhibit(int page, int pageSize, int pageTotalNum,int id){
Collection<Category> c=new ArrayList<Category>();
Category category=null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/shopping1?user=root&password=root";
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
String sql="select * from category where pid=0";
// String sql="select * from category where pid="+id+" limit "+(page-1)*pageSize+","+pageSize;
//String sql="select * from category limit "+(page-1)*pageSize+","+pageSize;
rs = stmt.executeQuery(sql);
while (rs.next()) {
category=new Category();
category.setId(rs.getInt("id"));
category.setName(rs.getString("name"));
category.setPid(rs.getInt("pid"));
category.setIsleaf(rs.getInt("isleaf")==0?true:false);
category.setGrade(rs.getInt("grade"));
c.add(category);
// if(!category.isIsleaf()){
if(!category.isIsleaf()){
exhibit(page,pageSize,pageTotalNum,category.getId());
}
//category = null;
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return c;
}
public void insertchild(Category category) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost/shopping1?user=root&password=root";
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
stmt1=conn.createStatement();
stmt2=conn.createStatement();
String name=category.getName();
int pid=category.getPid();
String sql1 = "select * from category where id="+pid;
rs1=stmt1.executeQuery(sql1);
rs1.next();
int grade1 = rs.getInt("grade");
int grade2= grade1+1;
String sql = "insert into category values(null,'" + name + "',"+pid+","+0+","+grade2+")";
stmt.executeUpdate(sql);
String sql2="update category set isleaf=1 where id="+pid;
stmt2.executeUpdate(sql2);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(rs1!=null){
try {
rs1.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt1!=null){
try {
stmt1.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt2!=null){
try {
stmt2.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
这是代码
public Collection exhibit(int page, int pageSize, int pageTotalNum,int id){
Collection<Category> c=new ArrayList<Category>();
Category category=null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/shopping1?user=root&password=root";
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
String sql="select * from category where pid=0";
// String sql="select * from category where pid="+id+" limit "+(page-1)*pageSize+","+pageSize;
//String sql="select * from category limit "+(page-1)*pageSize+","+pageSize;
rs = stmt.executeQuery(sql);
while (rs.next()) {
category=new Category();
category.setId(rs.getInt("id"));
category.setName(rs.getString("name"));
category.setPid(rs.getInt("pid"));
category.setIsleaf(rs.getInt("isleaf")==0?true:false);
category.setGrade(rs.getInt("grade"));
c.add(category);
// if(!category.isIsleaf()){
if(!category.isIsleaf()){
exhibit(page,pageSize,pageTotalNum,category.getId());
}
//category = null;
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return c;
}
public void insertchild(Category category) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost/shopping1?user=root&password=root";
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
stmt1=conn.createStatement();
stmt2=conn.createStatement();
String name=category.getName();
int pid=category.getPid();
String sql1 = "select * from category where id="+pid;
rs1=stmt1.executeQuery(sql1);
rs1.next();
int grade1 = rs.getInt("grade");
int grade2= grade1+1;
String sql = "insert into category values(null,'" + name + "',"+pid+","+0+","+grade2+")";
stmt.executeUpdate(sql);
String sql2="update category set isleaf=1 where id="+pid;
stmt2.executeUpdate(sql2);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(rs1!=null){
try {
rs1.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt1!=null){
try {
stmt1.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt2!=null){
try {
stmt2.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
解决方案 »
- 求网络爬虫设计思路
- JSF(myfaces1.1.5)页面之间传值时值丢失是为什么?用的是<f:param/>标签
- 从unix用文件输出流形式下载文件到windows的问题
- 菜鸟问题:如何调试JSP
- 请教点击姓名出现新窗口调用oracle显示其详细信息的代码(急,在线等!)
- tomcat6.0 运行jsp时出现500错误提示,急急急急急
- 如何用链接的方式打开一个pdg文件
- 请教:我的这个structs 应用系统中,有错误:Invalid path /testOracle was requested
- 关于jasperreport例子的编译使用??就30分了,棒棒忙吧!csdn都是活雷锋!!!
- 用 <logic:forward name="logon" />,怎么提交到它的父窗口?
- ${}传参问题??
- struts2如何在form里面显示图像?
一:域名注册专业咨询服务,让您花更少的钱更少的精力注册更合适的域名!避免域名注册陷阱,避免盲目注册,避免域名被盗取,避免域名被恶意抢注!
二:虚拟主机或服务器专业咨询服务,让您花更少的钱更少的精力购买最合适最安全的虚拟主机或者服务器!避免上当受骗,避免盲目投资,避免服务器被黑客利用!
三:专家级的网站建设,完美的界面---让客户喜欢上你的网站,强大的网站功能---让您的网站方便您的管理和用户的体验,最佳的网上营销---让网站给您带来滚滚财富!
四:专家级的网站维护,所有的网站维护工作由我们为您代劳,让您省钱、省心、省力,专心致志于业务的开展!
五:专家级的网站推广,为您提供百度推广、google推广、新浪推广、搜狐推广、网站优化排名等专业服务,让您的客户更容易找到您,让资金向您的网站滚滚流动!
六:网站ICP备案服务,我们拥有信息产业部网站备案资质,可以免费为您的网站域名办理ICP备案服务!
第一万维网您的第一选择!您的最佳选择!因为专业所以卓越!建站就选第一万维网!