下面是javabean的程序
package com.inbess.address.contact;
/**
*Copyright (c) 2004. Shanghai Inbess Corporation.
*All Rights Reserved.
*Created by xshu 2004-08-14
*/
import java.sql.ResultSet;
import com.inbess.util.base.*;
import com.inbess.util.log.*;
/**
*This class is used to manage the contact group
*/
public class UserContactGroup extends BaseBean
{
//define attributes
private String user_contact_group_id = "";
private String user_email_address = "";
private String group_name = "";
public UserContactGroup()
{
}
//attributes setter and getter
public void setUserContactGroupId(String param)
{
user_contact_group_id = param;
}
public void setUserEmailAddress(String param)
{
user_email_address = param;
}
public void setGroupName(String param)
{
group_name = param;
}
//other method
public void insert()
{
String sql = "insert into user_contact_group values('" + user_contact_group_id + "','"
+ user_email_address + "','" + group_name + "')";
db.executeUpdate(sql);
}
public void modify()
{
String sql = "update user_contact_group set group_name = '" + group_name + "' where"
+ " user_contact_group_id = '" + user_contact_group_id + "'";
db.executeUpdate(sql);
}
public void delete()
{
String sql = "delete from user_contact_group where user_contact_group_id = '" + user_contact_group_id + "'";
db.executeUpdate(sql);
}
public ResultSet queryById(String id)
{
String sql = "select * from user_contact_group where user_contact_group_id = '" + id + "'";
ResultSet rs = db.executeQuery(sql);
return rs;
}
public ResultSet queryByEmailAddress(String email)
{
String sql = "select * from user_contact_group where user_email_address = '" + email + "'";
ResultSet rs = db.executeQuery(sql);
return rs;
}
}
