role.java

文件的上传和下载的实现,用JAva编写,非常简单

/**
 * 
 */
package edu.whut.cwts.maintain.bean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.StringTokenizer;

import edu.whut.cwts.datasource.DBConnect;

/**
 * @author dwr
 *
 */
public class Role {

	/**
	 * @param args
	 */
	private String jsdm;
	private String jsmc;
	private String qxjh;
	
	public String getJsdm() {
		return jsdm;
	}
	public void setJsdm(String jsdm) {
		this.jsdm = jsdm;
	}
	public String getJsmc() {
		return jsmc;
	}
	public void setJsmc(String jsmc) {
		this.jsmc = jsmc;
	}
	public String getQxjh() {
		return qxjh;
	}
	public void setQxjh(String qxjh) {
		this.qxjh = qxjh;
	}
	public boolean roleInsert(String jsmc,String qxjh) throws SQLException{
		boolean flag=true;
		String jsdm="";
		//float u=Float.valueOf(yjhyf);
		String sqljsdm="select cast(isnull(max(jsdm),'0') as int)+1  from jsb";
		
		System.out.println(sqljsdm);
		
		DBConnect conn=new DBConnect();
		ResultSet rs=conn.executeQuery(sqljsdm);
		if(rs.next())jsdm=rs.getString(1);
		String sqlInsert="insert into jsb (jsdm,jsmc,qxjh) values('"+jsdm.trim()+"','"+jsmc.trim()+"','"+qxjh.trim()+"')";
		System.out.println(sqlInsert);
		flag=conn.executeInsert(sqlInsert);
		conn.close();
		
		return flag;
	}
	
	public int roleUpdate(String jsdm,String qxjh) throws SQLException{
		String sql="update jsb set qxjh='"+qxjh+"' where jsdm='"+jsdm+"'";
		int flag=0;
		DBConnect conn=new DBConnect();
		flag=conn.executeUpdate(sql);
		return flag;
	}
	public boolean roleDelete(String jsdm) throws SQLException{
		String sql="delete jsb  where jsdm='"+jsdm+"'";
		boolean flag=true;
		DBConnect conn=new DBConnect();
		flag=conn.executeDelete(sql);
		return flag;
	}
	public ArrayList getRoleSet(String qxjh){
		ArrayList altoken=new ArrayList();
		
		
		StringTokenizer st=new StringTokenizer(qxjh,"_"); 

		String s_buffer=null; 
		while(st.hasMoreTokens()) 
		{ 
		s_buffer=st.nextToken(); 
		altoken.add(s_buffer);
		
		
		} 
		
		return altoken;
	}
	public String queryQxjh(String jsdm) throws SQLException{
		String qxjh="";
		DBConnect conn=new DBConnect();
		ResultSet rs=conn.executeQuery("select qxjh from jsb where jsdm='"+jsdm.trim()+"'");
		if(rs.next())qxjh=rs.getString("qxjh");
		return qxjh;
		
	}
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		Role r=new Role();
		ArrayList list=r.getRoleSet("4_3_7_8_");
		Iterator it=list.iterator();
		while(it.hasNext()){
			String u=(String)it.next();
			System.out.println(u);
		}
		
	}

}