删除分销商

删除函数

function deleteRegion() {if(window.confirm("确认删除吗？")){with(document.forms[0]){action = "client_node_crud.jsp";submit();}}}

jsp里取得表单值，调用删除分销商方法

<%int id = Integer.parseInt(request.getParameter("id"));Client client = ClientManager.getInstance().findClientOrRegionById(id);//删除区域String command = request.getParameter("command");if(Constants.Del.equals(command)){ClientManager.getInstance().delClientOrRegion(id);%><script type="text/javascript">alert("用户【<%=client.getName()%>】删除成功！");window.parent.clientTreeFrame.location.reload();</script><%}%>

删除分销商方法

/** * 删除分销商或区域  * @param id */public void delClientOrRegion(int id){Connection conn = null;try{conn = DbUtil.getConnection();//手动控制事务DbUtil.beginTransaction(conn);//保存当前分销商Client client = findClientOrRegionById(id);//递归删除树节点recursionDelNode(conn, id);//如果父节点下没有子节点，修改为叶子if(getChildren(conn,client.getPid())==0){modifyIsLeafField(conn, client.getPid(), Constants.YES);}//提交事务DbUtil.commitTransaction(conn);}catch(Exception e){e.printStackTrace();DbUtil.rollbackTransaction(conn);}finally{DbUtil.resetConnection(conn);DbUtil.close(conn);}}

读取分销商

// 读取分销商public Client findClientOrRegionById(int id) {StringBuffer sbSql = new StringBuffer();sbSql.append("select a.id,pid,a.name,client_level_id,b.name as client_level_name,client_id,bank_acct_no,contact_tel,address,zip_code,").append("is_leaf,is_client").append(" from t_client a").append(" left join t_data_dict b on a.client_level_id=b.id").append(" where a.id = ?");Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;conn = DbUtil.getConnection();Client client = null;try {pstmt = conn.prepareStatement(sbSql.toString());pstmt.setInt(1, id);rs = pstmt.executeQuery();while (rs.next()) {client = new Client();client.setId(rs.getInt("id"));client.setPid(rs.getInt("pid"));client.setName(rs.getString("name"));ClientLevel cl = new ClientLevel();cl.setId(rs.getString("client_level_id"));cl.setName(rs.getString("client_level_name"));client.setClientLevel(cl);client.setClientId(rs.getString("client_id"));client.setBankAcctNo(rs.getString("bank_acct_no"));client.setContactTel(rs.getString("contact_tel"));client.setAddress(rs.getString("address"));client.setZipCode(rs.getString("zip_code"));client.setIsLeaf(rs.getString("is_leaf"));client.setIsClient(rs.getString("is_client"));}} catch (SQLException e) {e.printStackTrace();} finally {DbUtil.close(rs);DbUtil.close(pstmt);DbUtil.close(conn);}return client;}

递归删除节点

/** * 递归删除,首先删除下面的子节点 * @param conn * @param id * @throws SQLException  */private void recursionDelNode(Connection conn, int id) throws SQLException {String sql = "select * from t_client where pid=?";PreparedStatement pstmt = null;ResultSet rs = null;try{pstmt = conn.prepareStatement(sql);pstmt.setInt(1, id);rs = pstmt.executeQuery();while(rs.next()){if(Constants.NO.equals(rs.getString("is_leaf"))){recursionDelNode(conn,rs.getInt("id"));}delNode(conn, rs.getInt("id"));}//删除自身delNode(conn, id);}finally{DbUtil.close(rs);DbUtil.close(pstmt);}}

获取子节点数目

/** * 获取孩子数目 * @param conn * @param pid * @return * @throws SQLException  */private int getChildren(Connection conn, int pid) throws SQLException {String sql = "select count(*) as c from t_client where pid=?";PreparedStatement pstmt = null;ResultSet rs = null;int count = 0;try{pstmt = conn.prepareStatement(sql);pstmt.setInt(1, pid);rs = pstmt.executeQuery();rs.next();count =  rs.getInt("c");}finally{DbUtil.close(rs);DbUtil.close(pstmt);}return count;}

修改叶子

/** * 修改isLeaf字段 *  * @param conn *            连接 * @param id * @param leaf *            是否为叶子Y/N */private void modifyIsLeafField(Connection conn, int id, String leaf) {String sql = "update t_client t set t.is_leaf=? where id=?";PreparedStatement pstmt = null;try {pstmt = conn.prepareStatement(sql);pstmt.setString(1, leaf);pstmt.setInt(2, id);pstmt.executeUpdate();} catch (SQLException e) {e.printStackTrace();} finally {DbUtil.close(pstmt);}}