group.java

一个用java写的一种聊天工具

package business;
import java.sql.ResultSet;
import java.sql.SQLException;

import DataLayer.SqlHelper;
public class Group {
	public int groupID;
	public String groupName;
	public String groupInfo;
	public int ownerNum;
	private static SqlHelper sh;
	public Group()
	{
		
	}
	public Group(int id,String name,String info,int owner)
	{
		groupID = id;
		groupName = name;
		groupInfo = info;
		ownerNum = owner;
	}
	public static Group getGroup(int groupID)
	{
		Group temp = null;
		sh = new SqlHelper();
		sh.setStatement(sh.getConnection());
		ResultSet rs = sh.getQuery("select * from tbl_Groups where groupID="+groupID);
		try {
			if(rs.next())
			{
				temp = new Group(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getInt(4));
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return temp;
	}
}