【文件属性】:
文件名称:关于jsp中的树形节点
文件大小:4.22MB
文件格式:RAR
更新时间:2013-05-11 17:12:36
JAVA,树形,节点
package com.svse.struts.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.svse.struts.entity.PartBean;
import com.svse.struts.util.DBConnection;
public class PartDao
{
private Connection conn = null;
private PreparedStatement pre = null;
private ResultSet rs = null;
private DBConnection b = new DBConnection();
/** ******************查询所有部门************************* */
public List getx()
{
conn = b.getConnection();
List array = new ArrayList();
try
{
String sql = "select sjid,zjid,zjmc from t_part";
pre = conn.prepareStatement(sql);
rs = pre.executeQuery();
while (rs.next())
{
int sjid = rs.getInt("sjid");
int zjid = rs.getInt("zjid");
String zjmc = rs.getString("zjmc");
PartBean vo = new PartBean();
vo.setSjid(sjid);
vo.setZjid(zjid);
vo.setZjmc(zjmc);
array.add(vo);
}
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if (pre != null)
{
pre.close();
}
if (conn != null)
{
conn.close();
}
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
return array;
}
/** ********************增加部门********************** */
public void addpart(PartBean vo)
{
conn = b.getConnection();
try
{
int count = 0;
String sql = "select max(zjid) as t from t_part";
String sql1 = "insert into t_part(sjid,zjid,zjmc,zjjs) values(?,?,?,?)";
pre = conn.prepareStatement(sql);
rs = pre.executeQuery();
while (rs.next())
{
count = rs.getInt("t");
}
count = count + 1;
pre = conn.prepareStatement(sql1);
pre.setInt(1, vo.getSjid());
pre.setInt(2, count);
pre.setString(3, vo.getZjmc());
pre.setString(4, vo.getZjjs());
pre.executeUpdate();
pre.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if (pre != null)
{
pre.close();
}
if (conn != null)
{
conn.close();
}
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
}
/********************查询单个部门***********************/
public PartBean getdep(int zjid)
{
PartBean bean=new PartBean();
conn = b.getConnection();
try
{
String sql="select sjid,zjid,zjmc,zjjs from t_part where zjid=?";
pre=conn.prepareStatement(sql);
pre.setInt(1,zjid);
rs=pre.executeQuery();
while(rs.next())
{
bean.setSjid(rs.getInt("sjid"));
bean.setZjid(rs.getInt("zjid"));
bean.setZjmc(rs.getString("zjmc"));
String tx=null;
tx=rs.getString("zjjs");
if(tx==null)
{
String tt="暂无";
bean.setZjjs(tt);
}
else
{
bean.setZjjs(tx);
}
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(pre!=null)
{
pre.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
}
return bean;
}
/**************************修改部门***********************/
public void up(PartBean bean)
{
conn = b.getConnection();
try
{
String sql="update t_part set zjmc=?,zjjs=?,sjid=? where zjid=?";
pre=conn.prepareStatement(sql);
pre.setString(1,bean.getZjmc());
pre.setString(2,bean.getZjjs());
pre.setInt(3,bean.getSjid());
pre.setInt(4,bean.getZjid());
pre.executeUpdate();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(pre!=null)
{
pre.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
}
}
/********************删除部门**********************/
public int del(int sjid,int zjid)
{
int s=0;
conn = b.getConnection();
String sql="delete from t_part where sjid=? and zjid=?";
try
{
int count=0;//统计了结点
String sqlCount="select count(*) as t from t_part where sjid=?";
pre=conn.prepareStatement(sqlCount);
pre.setInt(1,zjid);
rs=pre.executeQuery();
while(rs.next())
{
count=rs.getInt("t");
}
if(count>0)
{
s=0;//下面有了结点,不能删除!
}
else
{
pre=conn.prepareStatement(sql);
pre.setInt(1,sjid);
pre.setInt(2,zjid);
pre.executeUpdate();
s=1;
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(pre!=null)
{
pre.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
}
return s;
}
}
网友评论
- 后来用了ztree,这个确实很好用,好好学习啊