tinfoserviceimpl.java

动态的树型目录

package com.xial.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.xial.bean.Tinfo;
import com.xial.sqlserver.util.DBUtil;

public class TinfoServiceImpl {

	public Tinfo findTinfoById(String id) {
		return null;
	}

	public List findAllTinfo() throws InstantiationException, IllegalAccessException, ClassNotFoundException,
			SQLException {
		List ls = new ArrayList();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			conn = DBUtil.getConnection();
			stmt = conn.createStatement();
			String sql = "select * from [dbo].[SQCLUB]";
			rs = stmt.executeQuery(sql);

			while (rs.next()) {
				Tinfo tinfo = new Tinfo();
				tinfo.setId(new Integer(rs.getInt("ID")));
				tinfo.setMc(rs.getString("MC"));
				tinfo.setFollowId(new Integer(rs.getInt("FollowId")));
				tinfo.setBm(rs.getString("BM"));
				tinfo.setFlag(new Integer(rs.getInt("Flag")));
				ls.add(tinfo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(rs, stmt, conn);
		}
		return ls;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}