yhxxctrl.java

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

package edu.whut.cwts.pg.fafang;

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

import edu.whut.cwts.pg.db.*;


public class YhxxCtrl {

	public static ArrayList findYhByzddm(String zddm)
			throws java.sql.SQLException {
		//假如登陆进去的站点逻辑级别为3，则根据登陆站点代码查找用户信息
		ArrayList result = new ArrayList();
		ConnectDB conndb = new ConnectDB();
		System.out.println("hello");
		String sql = "SELECT * from yhxxb where zddm='" + zddm.trim() + "'";
		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 void main(String[] args) throws java.sql.SQLException {

	}
}