usertomenubiz.java

java swing 和sql server 数据库做的 图书管理系统

/**
 * 
 */
package bookmanager.biz;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.LinkedList;


import bookmanager.bean.DB;
import bookmanager.bean.DbUtil;
import bookmanager.entity.UserToMenu;

/**
 * @author 李旻翀��FH
 *
 * @version UserToMenuBiz biz xx-UserToMenuBiz.java
 * 
 *May 14, 2008 4:02:13 PM
 */
public class UserToMenuBiz {
String sql;
	/**
	 * 
	 */
	public UserToMenuBiz() {
		// TODO Auto-generated constructor stub
	}
public LinkedList listUser(int userId)
{
//	DbUtil db = new DbUtil();
LinkedList ll = new LinkedList();
ResultSet rs;
sql="select * from T_USER2MENU where USID="+userId;
rs=DbUtil.executeQuery(sql);
try {
	while (rs.next()) {
		UserToMenu utm = new UserToMenu();
		utm.setUsid(userId);
		utm.setId(rs.getInt("ID"));
		utm.setMenuName(rs.getString("MENUNAME"));
		ll.add(utm);
	}
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}finally{
	DbUtil.closeConnection();
}
	return ll;}

public LinkedList searchUser(int userId,String menuName){
//	DbUtil db = new DbUtil();
	LinkedList ll = new LinkedList();
	sql="select ID,USID,MENUNAME from T_USER2MENU where USID='"+userId+"' and MENUNAME='"+menuName+"'";
	ResultSet rs=DbUtil.executeQuery(sql);
	
	
	try {while (rs.next()) {
		UserToMenu utm = new UserToMenu();
		utm.setUsid(userId);
		utm.setId(rs.getInt("ID"));
		utm.setMenuName(menuName);
		ll.add(utm);
	}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	finally{
		DbUtil.closeConnection();
}
	return ll;
	
	
}

public void delUserToMenu(int userId,String menuName) {
//	DbUtil db = new DbUtil();
	sql="DELETE FROM T_USER2MENU WHERE USID="+userId+" and MENUNAME='"+menuName+"'" ;
	DbUtil.executeUpdate(sql);
//	DbUtil.closeConnection();
}

public void insertUserToMenu(int userId,String menuName){
//	DbUtil db = new DbUtil();
	sql="INSERT INTO T_USER2MENU (USID,MENUNAME) VALUES ("+userId+",'"+menuName+"')" ;
	DbUtil.executeUpdate(sql);
//	DbUtil.closeConnection();
	
}
}