dbcp tomcat 配置方法 代码

由于需求在网上看了一些例子，就开始写二个代码学学dbcp  第一次做！！有很多不完美的地方，，但起码有效果了，，

 

做的视频也发上来了，也是第一次向往上发视频，，不要笑哦，做的很一般，，，很基本的一些东西，高手就别进来了！怕笑话！哈哈！！！

 

视频太大了上不了

 

 

评论

1 楼 xiaoCong 2009-09-03  

做个实验。嘿嘿

package com.ascent.action;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.ascent.po.Authorization;
import com.ascent.po.Department;
import com.ascent.po.News;
import com.ascent.po.Userauth;
import com.ascent.po.Usr;
import com.opensymphony.xwork2.ActionContext;

public class AuthAction extends BaseAction {
	
	public String typ;
	public String pars;
	public String id;
	public String name;
	public String gid;
	public String sid;
	public String gname;
	public String sname;
	public String dept;
	
	public String getGname() {
		return gname;
	}
	public void setGname(String gname) {
		this.gname = gname;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getGid() {
		return gid;
	}
	public void setGid(String gid) {
		this.gid = gid;
	}
	public String getSid() {
		return sid;
	}
	public void setSid(String sid) {
		this.sid = sid;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPars() {
		return pars;
	}
	public void setPars(String pars) {
		this.pars = pars;
	}
	public String getTyp() {
		return typ;
	}
	public void setTyp(String typ) {
		this.typ = typ;
	}
	public String getDept() {
		return dept;
	}
	public void setDept(String dept) {
		this.dept = dept;
	}

	/**
	 * 查找用户权限
	 *
	 */
	public String auth(){
		String sql = "select a from Authorization a,Usr u,Userauth ua " +
				"where u.id=? and ua.userId=u.id and ua.authId=a.id";
		Map session = ActionContext.getContext().getSession();
		Usr user = (Usr) session.get("user");
		Integer[] value = new Integer[1];
		value[0] = user.getId();
		List list = newsService.selectSQL(sql,value);
		ActionContext.getContext().put("auth",list);
		return "qxx";
	}
	
	/**
	 * 查找应该显示在首页的头版头条和综合新闻
	 *
	 */
	public void index(){
		Map session = ActionContext.getContext().getSession();
		String sql = "from News n where (n.status=1 and n.type=1) or " +
				"(n.type=2 and n.checkstatus=2 and n.status=1) order by n.id" +
				" desc";
		List list = newsService.selectSQL(sql,null);
		if(list.size()>0){
			News news = (News) list.get(0);
			session.put("typ1",news);
		} else {
			session.put("typ1",null);
		}
		sql = "from News n where n.status=1 and n.type=2 and " +
				"n.checkstatus!=2 order by n.id desc";
		list = newsService.selectSQL(sql,null);
		List li = new ArrayList();
		if(list.size()>6){
			for(int i=0;i<6;i++){
				li.add(list.get(i));
			}
			session.put("typ2",li);
		} else {
			session.put("typ2",list);
		}
	}
	
	/**
	 *用户分配权限之前的寻找
	 */
	public String plot(){
		//部门集合
		String sql = "from Department";
		List list = newsService.selectSQL(sql, null);
		ActionContext.getContext().put("dept",list);
		
		//未分配权限的用户集合
		Department dt = (Department) list.get(0);
		sql = "from Usr u where u.deptid=? and u.id not in" +
				"(select ua.userId from Userauth ua,Authorization a where " +
				"ua.authId=a.id and a.columnId=?)";
		Integer[] value1 = {dt.getId(),Integer.parseInt(this.getTyp())};
		list = newsService.selectSQL(sql, value1);
		ActionContext.getContext().put("user1",list);
		
		//栏目管理的权限的用户集合
		sql = "select u from Usr u,Userauth ua,Authorization a where " +
				"u.id=ua.userId and u.deptid=? and a.columnId=? and " +
				"a.auth=1 and ua.authId=a.id";
		list = newsService.selectSQL(sql, value1);
		ActionContext.getContext().put("guser",list);
		
		//栏目审核的权限的用户集合
		sql = "select u from Usr u,Userauth ua,Authorization a where " +
				"u.id=ua.userId and u.deptid=? and a.columnId=? and " +
				"a.auth=2 and ua.authId=a.id";
		list = newsService.selectSQL(sql, value1);
		ActionContext.getContext().put("suser",list);
		return SUCCESS;
	}
	
	/**
	 * 根据部门查询用户
	 * @return
	 */
	public String deptUser(){
		String[] par = this.getPars().split(",");
		String sql = "from Usr u where u.deptid=? and u.id not in" +
						"(select ua.userId from Userauth ua,Authorization a " +
						"where ua.authId=a.id and a.columnId=?)";
		Integer[] value = {Integer.parseInt(par[0]),Integer.parseInt(par[1])};
		List list = newsService.selectSQL(sql, value);
		this.setId("");
		this.setName("");
		for(int i=0;i<list.size();i++){
			Usr user = (Usr) list.get(i);
			if(i==0){
				id = user.getId()+"";
				name = user.getNickname();
			} else {
				id = id+","+user.getId();
				name = name+","+user.getNickname();
			}
		}
		Integer[] va = {Integer.parseInt(par[0]),Integer.parseInt(par[1])};
		sql = "select u from Usr u,Userauth ua,Authorization a where " +
				"u.id=ua.userId and u.deptid=? and a.columnId=? and " +
				"a.auth=1 and ua.authId=a.id";
		list = newsService.selectSQL(sql, va);
		this.setGname("");
		this.setGid("");
		for(int i=0;i<list.size();i++){
			Usr user = (Usr) list.get(i);
			if(i==0){
				gid = user.getId()+"";
				gname = user.getNickname();
			} else {
				gid = gid+","+user.getId();
				gname = gname+","+user.getNickname();
			}
		}
		
		sql = "select u from Usr u,Userauth ua,Authorization a where " +
				"u.id=ua.userId and u.deptid=? and a.columnId=? and " +
				"a.auth=2 and ua.authId=a.id";
		list = newsService.selectSQL(sql, va);
		this.setSname("");
		this.setSid("");
		for(int i=0;i<list.size();i++){
			Usr user = (Usr) list.get(i);
			if(i==0){
				sid = user.getId()+"";
				sname = user.getNickname();
			} else {
				sid = sid+","+user.getId();
				sname = sname+","+user.getNickname();
			}
		}
		return "de";
	}
	
	public String addPlot(){
		String[] gid = this.getGid().split(",");
		String[] sid = this.getSid().split(",");
		String gsql = "from Authorization a where a.columnId=? and a.auth=1";
		String ssql = "from Authorization a where a.columnId=? and a.auth=2";
		Integer[] value = {Integer.parseInt(this.getTyp())};
		List glist = newsService.selectSQL(gsql,value);
		List slist = newsService.selectSQL(ssql,value);
		Authorization ga = (Authorization) glist.get(0);
		Authorization sa = (Authorization) slist.get(0);
		
		String sql = "select ua from Usr u,Userauth ua,Authorization a " +
				"where u.deptid=? and u.id=ua.userId and a.columnId=? " +
				"and a.auth=1 and a.id=ua.authId";
		Integer[] v = {Integer.parseInt(this.getDept()),
				Integer.parseInt(this.getTyp())};
		List list = newsService.selectSQL(sql, v);
		for(int i=0;i<list.size();i++){
			Userauth ua = (Userauth) list.get(i);
			newsService.deleteObject(ua);
		}
		sql = "select ua from Usr u,Userauth ua,Authorization a where " +
				"u.deptid=? and u.id=ua.userId and a.columnId=? and " +
				"a.auth=2 and a.id=ua.authId";
		list = newsService.selectSQL(sql, v);
		for(int i=0;i<list.size();i++){
			Userauth ua = (Userauth) list.get(i);
			newsService.deleteObject(ua);
		}
		for(int i=0;i<gid.length;i++){
			if(gid[0]!=null && !"".equals(gid[0])){
				Userauth ua = new Userauth();
				ua.setUserId(Integer.parseInt(gid[i]));
				ua.setAuthId(ga.getId());
				newsService.addObject(ua);
			}
		}
		for(int i=0;i<sid.length;i++){
			if(sid[0]!=null && !"".equals(sid[0])){
				Userauth ua = new Userauth();
				ua.setUserId(Integer.parseInt(sid[i]));
				ua.setAuthId(sa.getId());
				newsService.addObject(ua);
			}
		}
		return "am";
	}
}