yhxxctrl.java

来自「文件的上传和下载的实现,用JAva编写,非常简单」· Java 代码 · 共 45 行

package edu.whut.cwts.pg.hexiao;

import java.sql.*;
import java.util.*;

public class YhxxCtrl {

	public static ArrayList findYhByzddm(String zddm)
			throws java.sql.SQLException {
		//假如登陆进去的站点逻辑级别为3，则根据登陆站点代码查找用户信息
		ArrayList result = new ArrayList();
		ConnectDB conndb = new ConnectDB();
		String sql = "SELECT * from yhxxb where zddm='" + zddm.trim() + "'";
		Assert.pl(sql);
		ResultSet rs = conndb.executeQuery(sql);
		if (rs == null)
			return null;
		while (rs.next()) {
			result.add(new Yhxx(rs.getString("yhdm"), rs.getString("yhxm"), rs
					.getString("jsjh"), rs.getString("yhmm"), rs
					.getString("zddm")));
		}
		conndb.close();
		return result;
	}
    public static String findYhxm(String yhdm) throws java.sql.SQLException{
    	//按照用户代码获取用户名称
    	ArrayList result = new ArrayList();
    	ConnectDB conndb = new ConnectDB();
    	String sql = "SELECT yhxm from yhxxb where yhdm='"+yhdm.trim()+"'";
    	Assert.pl(sql);
    	ResultSet rs = conndb.executeQuery(sql);
    	if (rs == null)
    		return null;
    	while (rs.next()) {
			result.add(rs.getString("yhxm"));    		
    	}
		conndb.close();
		String mc=(String) result.get(0);
		return mc;    	
    }
	public static void main(String[] args) throws java.sql.SQLException {

	}
}