querydata.java

一款少见的用swt写的彩票软件

package com.dc.system;

import com.dc.db.RdbmsConnecter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class QueryData {

	public List QueryDataForStore() throws Exception {
		String sql = "select * from data";
		Connection con = null;
		ResultSet rs = null;
		List<Object> listresult = new ArrayList<Object>();
		con = RdbmsConnecter.getInstance().getConnection();
		try {
			rs = con.createStatement().executeQuery(sql);
			if (rs.next()) {
				listresult.add(rs.getObject(2));
				listresult.add(rs.getObject(3));
				listresult.add(rs.getObject(4));
				listresult.add(rs.getObject(5));
				listresult.add(rs.getObject(6));
				listresult.add(rs.getObject(7));
			}
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		} finally {
			if (con != null) {
				con.close();
			}
		}
		System.out.println(listresult);
		return listresult;
	}

}