public static void addChildcategory(int pid,String name,String desc) {
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt=null;
try {
conn = DB.getConn();
conn.setAutoCommit(false);
rs = DB.executeQuery(conn, "select * from category where id= "+pid);
System.out.println("tttt"+pid);
rs.next();
System.out.println("mbbbbb");
int parentgrade = rs.getInt("grade");
String sql = "insert into category values(null,?,?,?,?,?)";
pstmt = DB.prepare(conn, sql);
pstmt.setString(1,name);
pstmt.setString(2,desc);
pstmt.setInt(3,pid);
pstmt.setInt(4,0);
pstmt.setInt(5,parentgrade+1);
pstmt.executeUpdate();
System.out.println(parentgrade);
String str ="update category set isleaf =1 where id = "+pid;
System.out.println(str);
DB.executeUpdate(conn, "update category set isleaf =1 where id = "+pid);
System.out.println("mb663336bb");
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
DB.close(rs);
DB.close(pstmt);
DB.close(conn);
}
}哪里错了
是试过了到 DB.executeUpdate(conn, "update category set isleaf =1 where id = "+pid);
这里就有错这么回事啊
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt=null;
try {
conn = DB.getConn();
conn.setAutoCommit(false);
rs = DB.executeQuery(conn, "select * from category where id= "+pid);
System.out.println("tttt"+pid);
rs.next();
System.out.println("mbbbbb");
int parentgrade = rs.getInt("grade");
String sql = "insert into category values(null,?,?,?,?,?)";
pstmt = DB.prepare(conn, sql);
pstmt.setString(1,name);
pstmt.setString(2,desc);
pstmt.setInt(3,pid);
pstmt.setInt(4,0);
pstmt.setInt(5,parentgrade+1);
pstmt.executeUpdate();
System.out.println(parentgrade);
String str ="update category set isleaf =1 where id = "+pid;
System.out.println(str);
DB.executeUpdate(conn, "update category set isleaf =1 where id = "+pid);
System.out.println("mb663336bb");
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
DB.close(rs);
DB.close(pstmt);
DB.close(conn);
}
}哪里错了
是试过了到 DB.executeUpdate(conn, "update category set isleaf =1 where id = "+pid);
这里就有错这么回事啊
方法吗? 是static 的吗?
早DB里的executeUpdate(Connection conn, String sql);
错了
谢谢