userdao.java

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

/** 
* Copyright 2007 Wuhan University of Technology. 
* All right reserved. 
* Create on 2007-3-18
*/

package edu.whut.cwts.maintain.action;

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

import edu.whut.cwts.datasource.DBConnect;
import edu.whut.cwts.maintain.bean.Role;
import edu.whut.cwts.maintain.bean.User;
/**
 * @author dwr
 *
 */
public class UserDAO {
	
	public List getRole()
	{
		List rolelist = new ArrayList();
		DBConnect dbconn=new DBConnect();		
		String sql = "select jsdm,jsmc from jsb ";
		int i = 0;
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			while(rs.next())
			{
				Role role = new Role();
				role.setJsdm(rs.getString("jsdm"));
				role.setJsmc(rs.getString("jsmc"));
				rolelist.add(i,role);
				i++;
			}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			 dbconn.close();			
		return rolelist;
	}
	
	public static User getUser(String yhdm)
	{
		User user = new User();
		DBConnect dbconn=new DBConnect();		
		String sql = "select yhxm,jsjh,yhmm,zddm from yhxxb ";
		sql += "WHERE ";
		sql += "yhdm = '" + yhdm.trim() + "' ";			
		
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			while(rs.next())
			{
				user.setYhdm(yhdm);
				user.setYhxm(rs.getString("yhxm"));
				user.setJsjh(rs.getString("jsjh"));
				user.setYhmm(rs.getString("yhmm"));
				user.setZddm(rs.getString("zddm"));
			}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			 dbconn.close();			
		return user;
	}

	public ArrayList getRoleSet(String jsjh){
		ArrayList altoken=new ArrayList();
		StringTokenizer st=new StringTokenizer(jsjh,"_"); 
		String s_buffer=null; 
		while(st.hasMoreTokens()) 
		{ 
		s_buffer=st.nextToken(); 
		altoken.add(s_buffer);
		} 
		return altoken;
	}
	
public static boolean addUser(String yhdm,String yhxm,String jsjh,String zddm)
{
	boolean flag=false;
	String str1="";
	if(yhxm.length()==9)
		str1=yhxm.substring(6,7);
	else
	    str1=yhxm.substring(0,1);
	if(str1.equals("p")) 
		jsjh="_p";
	DBConnect dbconn=new DBConnect();	
	String sqlinsert = "INSERT INTO yhxxb(yhdm,yhxm,jsjh,yhmm,zddm) VALUES( ";
	
	sqlinsert += " '" + yhdm.trim() + "' ,";
	sqlinsert += " '" + yhxm.trim() + "' ,";
	sqlinsert += " '" + jsjh.trim() + "' ,";
	sqlinsert += " '888888' ,";
	sqlinsert += " '" + zddm.trim() + "') "; 			
	System.out.println(sqlinsert);
	try
	{
		flag = dbconn.executeInsert(sqlinsert);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			System.out.println(sqlinsert);
		}
		 dbconn.close();	
	return flag;
}

public boolean deleteUser(String yhdm)
	{
	 String sql="delete yhxxb where yhdm='"+yhdm.trim()+"'";
	 System.out.println(sql);
	 DBConnect dbconn2=new DBConnect();
	 boolean flag=false;
	 flag = dbconn2.executeDelete(sql);
	 //System.out.println(flag);
	 dbconn2.close();
	 return flag;
	
	}
   
public int updateUser(String yhxm,String jsjh,String yhdm)
	{
	 String sql="update yhxxb set yhxm='"+yhxm.trim()+"',jsjh='"+jsjh.trim()+"' where yhdm='"+yhdm.trim()+"' ";
	 System.out.println(sql);
	 DBConnect dbconn = new DBConnect();
	 int flag=0;
	 try {
		flag = dbconn.executeUpdate(sql);
		
	 } catch (SQLException e) {
		// TODO 自动生成 catch 块
		e.printStackTrace();
	 }
	 dbconn.close();
	 //System.out.println(flag);
	 return flag;
	
	 }
public static void main(String[] args) {
	// TODO 自动生成方法存根
/*System.out.println("dd");
String yhdm="1156";
String yhxm="1256";
String jsdm="1256";
String yhmm="1256";
String zddm="1256";
boolean flag;
flag=addUser(yhdm,yhxm,jsdm,yhmm,zddm);
System.out.println(flag);*/
	String zddm="110202";
	if(zddm=="0")
	zddm="000000";
//	select isnull(max(cast(zldm as int))+1,'1'):防止数据库中选出来的值为空值!
	String sqlselect="select cast(isnull(max(yhdm),'"+zddm+"000')as int) from yhxxb where yhdm like '"+zddm+"%' and yhdm not like '"+zddm+"p%' "; 
//	String sqlselect="select isnull(max(cast(yhdm as int))+1,'1') from yhxxb where yhdm like '"+zddm+"%'"; 
	String sqlselect2="select cast(max(yhdm)as char) from yhxxb where yhdm like '"+zddm+"p%'";
//	String sqlselect2="select cast(max(yhdm)as int)+1 from yhxxb where yhdm like '"+zddm+"%'";
	System.out.println(sqlselect);
	System.out.println(sqlselect2);
	DBConnect dbconn=new DBConnect();
	DBConnect dbconn2=new DBConnect();
	String id="";
	String PDAID="";
	String userID="";
	int pdaid=0;
	try{
		 ResultSet rs2=dbconn2.executeQuery(sqlselect2);
		 ResultSet rs=dbconn.executeQuery(sqlselect);
		 if(rs2.next())
		 id=rs2.getString(1);
		 if(rs.next())
		 userID=rs.getString(1);
		 }
		 catch (SQLException e) {
				e.printStackTrace();}
	dbconn2.close(); 
	dbconn.close(); 
	pdaid=Integer.parseInt(id.substring(7).trim())+1;
	if(pdaid<10)
		id="0"+String.valueOf(pdaid);
	else
		id=String.valueOf(pdaid);
	PDAID=zddm+"p"+id;
	/*System.out.println(id.substring(7,8));
	System.out.println(id.substring(8));
	if(id.substring(7,8)!="0")
	{
		pdaid=Integer.parseInt(id.substring(8).trim())+1;
		System.out.println(pdaid);
		 PDAID=zddm+"p0"+String.valueOf(pdaid);}
	
	else
	{pdaid=Integer.parseInt(id.substring(7).trim())+1;
	//System.out.println(pdaid);
	 PDAID=zddm+"p"+String.valueOf(pdaid);}*/
	
	
	System.out.println(userID);
	System.out.println(PDAID);
	String s="123";
	System.out.println(s.length());
}

}