基于web的在线界面设计系统

package xu.qi.jin.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import xu.qi.jin.dao.TreeNodeDAO; import xu.qi.jin.vo.NodeVo; public class TreeNodeDAOImpl implements TreeNodeDAO { private Connection conn = null; private PreparedStatement pst = null; public TreeNodeDAOImpl(Connection conn) { this.conn = conn; } public boolean addNode(NodeVo vo) throws Exception { boolean flag = false; String sql = "insert into tree_node values(?,?,?,?,?,?)"; this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1, vo.getTreeid()); this.pst.setString(2, vo.getUid()); this.pst.setString(3, vo.getHtmlnode()); this.pst.setInt(4, vo.getPid()); this.pst.setString(5, vo.getTitle()); this.pst.setString(6, vo.getXingzhi()); if (this.pst.executeUpdate() > 0) { flag = true; } this.pst.close(); return flag; } public boolean deleteNode(int id,String p) throws Exception { boolean flag = false; String sql = "delete from tree_node where tree_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1, id); this.pst.setString(2,p); if (this.pst.executeUpdate() >= 1) { flag = true; } this.pst.close(); return flag; } public boolean deleteNode2(int id,String pid)throws Exception{ boolean flag = false; String sql = "delete from tree_node where p_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1, id); this.pst.setString(2,pid); if (this.pst.executeUpdate() >= 1) { flag = true; } this.pst.close(); return flag; } public String searchNode(int id,String p) throws Exception { String s = null; String sql = "SELECT * FROM tree_node WHERE tree_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1, id); this.pst.setString(2,p); ResultSet rs = this.pst.executeQuery(); while (rs.next()) { s = rs.getString(3); } this.pst.close(); rs.close(); return s; } public boolean updateNode(int id, String nodeHtml,String uid) throws Exception { boolean flag = false; String sql = "update tree_node set htmlnode=? where tree_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); pst.setString(1, nodeHtml); pst.setInt(2, id); pst.setString(3,uid); if (this.pst.executeUpdate()>= 1) { flag = true; } this.pst.close(); return flag; } public boolean updateTitle(int id, String t,String p) throws Exception { boolean flag = false; String sql = "update tree_node set title=? where tree_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); pst.setString(1, t); pst.setInt(2, id); pst.setString(3, p); if (this.pst.executeUpdate() >= 1) { flag = true; } this.pst.close(); return flag; } public boolean updateXingzhi(String ss,int id,String uid)throws Exception{ boolean flag = false; String sql = "update tree_node set xingzhi=CONCAT(xingzhi,?) where tree_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); pst.setString(1,ss); pst.setInt(2, id); pst.setString(3,uid); if (this.pst.executeUpdate()>= 1) { flag = true; } this.pst.close(); return flag; } public String getXingzhi(int id,String uid)throws Exception{ String ss=""; String sql = "SELECT xingzhi FROM tree_node WHERE tree_id=? and u_id=?"; //将用户u_id的全部节点全部提取 this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1,id); this.pst.setString(2,uid); ResultSet rs = this.pst.executeQuery(); while (rs.next()) { ss=rs.getString(1); } this.pst.close(); rs.close(); return ss; } public boolean initNodes(int i1,String s,int i2)throws Exception{ boolean flag = false; String sql = "insert into tree_node values(?,?,?,?,?,?)"; this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1, i1); this.pst.setString(2, s); this.pst.setString(3, "haha"); this.pst.setInt(4, i2); this.pst.setString(5, "undefirtyned"); this.pst.setString(6, "rtyty"); if (this.pst.executeUpdate() > 0) { flag = true; } this.pst.close(); return flag; } public String loadNode(String s)throws Exception{ String ss=""; String sql = "SELECT * FROM tree_node WHERE u_id=?"; //将用户u_id的全部节点全部提取 this.pst = this.conn.prepareStatement(sql); this.pst.setString(1,s); ResultSet rs = this.pst.executeQuery(); while (rs.next()) { ss+="{"+"\""+"id"+"\""+":"+rs.getInt(1)+","+"\""+"parentId"+"\""+":"+rs.getInt(4)+","+"\""+"name"+"\""+":"+"\""+rs.getString(5)+"\""+"}"+","; } this.pst.close(); rs.close(); ss=ss.substring(0,ss.length()-1); ss="["+ss+"]"; return ss; } public boolean setJsNull(int id,String uid)throws Exception{ boolean flag = false; String sql ="update tree_node set xingzhi=\" \" where tree_id=? and u_id=?"; this.pst = this.conn.prepareStatement(sql); this.pst.setInt(1, id); this.pst.setString(2, uid); if (this.pst.executeUpdate() > 0) { flag = true; } this.pst.close(); return flag; } }