guestbook.java

This book code procedure according to the chapter arrangement, the 1st chapter of example under "1"

/*
 * Guestbook.java
 *
 * Created on 2005年11月25日, 下午9:47
 */

package com.example.dao;
import com.example.database.DbConn;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Vector;

/**
 * @author Admin
 */
public class Guestbook {
    private int ID = -1;
    private String NAME = "";
    private String CONTENT = "";
    private String EMAIL = "";
    private String IP = "";
    
    public int getID() {
        return ID;
    }

    public void setID(int ID) {
        this.ID = ID;
    }

    public String getNAME() {
        return NAME;
    }

    public void setNAME(String NAME) {
        this.NAME = NAME;
    }

    public String getCONTENT() {
        return CONTENT;
    }

    public void setCONTENT(String CONTENT) {
        this.CONTENT = CONTENT;
    }

    public String getEMAIL() {
        return EMAIL;
    }

    public void setEMAIL(String EMAIL) {
        this.EMAIL = EMAIL;
    }

    public String getIP() {
        return IP;
    }

    public void setIP(String IP) {
        this.IP = IP;
    }
    Connection conn;
  DbConn db = new DbConn(); //实例化数据库连接bean
  public Guestbook() {
    String tDriver = "com.inet.tds.TdsDriver";
    String tUrl = "jdbc:inetdae:127.0.0.1:1433?database=project&charset=GB2312";
    String tUser = "sa";
    String tPassWord = "sa";
    conn = db.getConn(tDriver, tUrl, tUser, tPassWord);
  }
  /**
   *<br>方法说明：添加数据
   *<br>输入参数：
   *<br>输出类型：成功返回Int 0 失败返回 Int -1    <br>
   */
  public int insert() {
    String sql = "insert into guestbook";
    String strFiled = "";
    String strValue = "";
    try {
      boolean flag = true;
      if (!NAME.equals("")) {
        if (flag) {
          strFiled += " NAME";
          strValue +="'"+NAME+"'";
          flag = false;
        }
        else {
          strFiled += ",NAME";
          strValue +=",'"+NAME+"'";
        }
      }
      if (!CONTENT.equals("")) {
        if (flag) {
          strFiled += " CONTENT";
          strValue +="'"+CONTENT+"'";
          flag = false;
        }
        else {
          strFiled += ",CONTENT";
          strValue +=",'"+CONTENT+"'";
        }
      }
      if (!EMAIL.equals("")) {
        if (flag) {
          strFiled += " EMAIL";
          strValue +="'"+EMAIL+"'";
          flag = false;
        }
        else {
          strFiled += ",EMAIL";
          strValue +=",'"+EMAIL+"'";
        }
      }
      if (!IP.equals("")) {
        if (flag) {
          strFiled += " IP";
          strValue +="'"+IP+"'";
          flag = false;
        }
        else {
          strFiled += ",IP";
          strValue +=",'"+IP+"'";
        }
      }
      sql += "(" + strFiled + ") values(" + strValue + ")";
      Integer iResult = (Integer)db.execute(conn, sql);
      return iResult.intValue();
    }
    catch (SQLException e) {
      System.out.println(e);
      return -1;
    }
  }

  /**<br>
   *方法说明：得出所有信息列表  <br>
   *                       <br>
   *输入参数：colName：查询字段； 如果为空则表示选择所有<br>
   *输出类型：向量Vector   <br>
   */
  public Vector getList(String colName) {
    Vector vResult = new Vector();
    String sql = "";
    String sqlH = "";
    String sqlT = "";
    String colList = "";
    String query = "";
    try {
      if (colName.equals("") || colName == null) {
        colList = "* "; //请填查选字段
      }
      else {
        colList = colName;
      }
      sql = "select ";
      query = " from guestbook ";
      sqlT = " order by id desc ";
      sql = sql + colList + query + sqlT;
      vResult = (Vector) db.execute(conn, sql);
      int iRnum = vResult.size();
      vResult.insertElementAt(String.valueOf(iRnum), 0);
    }
    catch (SQLException e) {
      System.out.println("getList e:" + e);
    }
    return vResult;
  }  
    
}