signature.java

mail sent and revesive system jsp+mysql

package fengyun.Fastmail.beans;

import java.sql.*;

public class Signature {
  private String userid = null;
  private String signature = null;

  public void setUserid(String userid) { this.userid = userid; }
  public String getUserid() { return userid; }
  public void setSignature(String signature) { this.signature = signature; }
  public String getSignature() { return signature; }

  public boolean update() {
    if (signature == null) signature = "";
    try {
		String sql = "update profile set signature=? where userid =?";
		Mysql mysql = new Mysql(sql);
		mysql.setString(1,signature);
		mysql.setString(2,userid);
		mysql.executeUpdate();
		mysql.close();
		return true;
    } catch (Exception ex) {
		System.err.println("Signature.update():");
		ex.printStackTrace(System.err);
		return false;
    }
  }
  public boolean select() {
    try {
		String sql = "select signature from profile where userid = ?";
		Mysql mysql = new Mysql(sql);
		mysql.setString(1,userid);
		ResultSet rs = mysql.executeQuery();
		boolean next = rs.next();
		if (next) signature = rs.getString("signature");
		rs.close();
		mysql.close();
		return next;
    } catch (Exception ex) {
		System.err.println("Profile.select():");
		ex.printStackTrace(System.err);
		return false;
    }
  }
  public boolean isValid() {
    return (userid != null && !userid.equals(""));
  }
}