erp系统/src/com/util/AllBean.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.util;

 


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

 

import com.util.SelectBean;

public class AllBean {
	SelectBean sb = new SelectBean();
	@SuppressWarnings("unchecked")
	ArrayList al = null;
	
	
	public Map<String, String> getOneById(String user_id) {
		Map<String, String> map = null;
		String sql = "select id,stuNo,pwd,name"
				+ " from tstudent where id=?";
		String[] args = { user_id };
		map = CommDAO.getMap(sql, args);
		return map; 
	}


	
	
	@SuppressWarnings("unchecked")
	public ArrayList getAdmin() {
		String sql = "select * from t_admin order by id desc";
		String args[] = { "id", "account","pwd"};
		al = sb.select(sql, args);
		return al;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getAdmin1(String account) {
		String sql = "select * from t_admin  where account like '%"+account+"%'";
		String args[] = { "id", "account","pwd"};
		al = sb.select(sql, args);
		return al;
	}
	
	@SuppressWarnings("unchecked")
	public ArrayList getCangku() {
		String sql = "select * from t_cangku order by id desc";
		String args[] = { "id", "cangkuNo","name","username","beizhu","istingyong"};
		al = sb.select(sql, args);
		return al;
	}
	
	@SuppressWarnings("unchecked")
	public ArrayList getCangkuByname(String name) {
		String sql = "select * from t_cangku where name='%"+name+"%'";
		String args[] = { "id", "cangkuNo","name","username","beizhu","istingyong"};
		al = sb.select(sql, args);