JSP动态树形结构、增删改查刷新功能(sql脚本)

package com.daos; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.DAaccess.DBAccess; import com.beans.MenuBean; public class MenuDao { Connection conn=null; PreparedStatement pstmt=null; ResultSet rs=null; com.DAaccess.DBAccess db=new DBAccess(); //实例化Dao //显示树形结构 。 left,.jsp public List<com.beans.MenuBean> getMemucontent() throws Exception { String sql="select nodeid,parentid,hrefaddress,nodename from DT"; // String sql="select id,parentid,hrefaddress,nodename from DT"; rs=db.sesect(sql); List<com.beans.MenuBean> menus=new ArrayList<MenuBean>(); while(rs.next()) { com.beans.MenuBean Menu=new MenuBean(); Menu.setNodeId(rs.getString(1)); //Menu.setId(rs.getInt(1)); Menu.setParentId(rs.getString(2)); Menu.setHrefAddress(rs.getString(3)); Menu.setNodeName(rs.getString(4)); menus.add(Menu); } System.out.println("------调用树形结构了--------"); return menus; } //查询全部信息 public List<com.beans.MenuBean> getDInfo() throws Exception { String sql="select * from DT"; rs=db.sesect(sql); List<com.beans.MenuBean> menus=new ArrayList<MenuBean>(); while(rs.next()) { com.beans.MenuBean Menu=new MenuBean(); Menu.setId(rs.getInt(1)); Menu.setNodeId(rs.getString(2)); Menu.setParentId(rs.getString(3)); Menu.setHrefAddress(rs.getString(4)); Menu.setNodeName(rs.getString(5)); Menu.setsName(rs.getString(6)); Menu.setdType(rs.getString(7)); Menu.setdPeople(rs.getString(8)); Menu.setState(rs.getString(9)); menus.add(Menu); } return menus; } //check 查询 public List<com.beans.MenuBean> getSingleInfo(int id) throws Exception { String classStr = "oracle.jdbc.driver.OracleDriver"; String conStr = "jdbc:oracle:thin:@localhost:1521:orcl"; Class.forName(classStr); conn = DriverManager.getConnection(conStr, "scott", "tiger"); String sql = "select nodeId,parentId ,NODENAME,SNAME,DTYPE,DPEOPLE,STATE from DT where nodeId=?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); List<com.beans.MenuBean> menus = new ArrayList<MenuBean>(); while (rs.next()) { com.beans.MenuBean Menu = new MenuBean(); Menu.setNodeId(rs.getString(1)); Menu.setParentId(rs.getString(2)); Menu.setNodeName(rs.getString(3)); Menu.setsName(rs.getString(4)); Menu.setdType(rs.getString(5)); Menu.setdPeople(rs.getString(6)); Menu.setState(rs.getString(7)); menus.add(Menu); } return menus; } //删除 public void del(MenuBean bean) { System.out.println("执行了这部没有 "); String sql="delete DT where nodeId =(?)" ; try { conn = db.getCon(); } catch (ClassNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } try { pstmt=conn.prepareStatement(sql); pstmt.setInt(1, bean.getId()); System.out.println("删除成功！！"); pstmt.executeUpdate(); System.out.println("删除成功！！！"); } catch (SQLException e) { e.printStackTrace(); } } // 修改 public void update(MenuBean bean){ System.out.println("修改的第一步 "); String sql="update DT set NodeName=?,sname=?,dtype=? ,dpeople =? ,state =? where nodeId=?"; try { conn=db.getCon(); } catch (ClassNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } try { pstmt=conn.prepareStatement(sql); pstmt.setString(1, bean.getNodeName()); pstmt.setString(2, bean.getsName()); pstmt.setString(3, bean.getdType()); pstmt.setString(4, bean.getdPeople()); pstmt.setString(5, bean.getState()); pstmt.setString(6, bean.getNodeId()); System.out.println("修改成功！！"); int num = pstmt.executeUpdate(); System.out.println(num); System.out.println("修改成功！！！"); } catch(SQLException e) { e.printStackTrace(); } } //增加 public void addDep(MenuBean bean) { System.out.println("执行了这部没有 "); String sql="insert into DT(NODEID,PARENTID,NODENAME,SNAME,DTYPE,DPEOPLE,STATE) values (?,?,?,?,?,?,?)" ; //insert into DT(NODEID,PARENTID,HREFADDRESS,NODENAME,SNAME,DTYPE,DPEOPLE,STATE) // values('7','2','','销售部','11','销售部','张海龙','正常'); try { conn=db.getCon(); } catch (ClassNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } try { pstmt=conn.prepareStatement(sql); pstmt.setString(1, bean.getNodeId()); pstmt.setString(2, bean.getParentId()); pstmt.setString(3, bean.getNodeName()); pstmt.setString(4, bean.getsName()); pstmt.setString(5, bean.getdType()); pstmt.setString(6, bean.getdPeople() ); pstmt.setString(7, bean.getState() ); System.out.println("增加成功！！！"); pstmt.executeUpdate(); System.out.println("增加成功！！！GG"); } catch (SQLException e) { e.printStackTrace(); } } }