guestbook.java

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

package com.example.dao;

import java.util.*;
import java.sql.*;
import com.example.database.*; //导入数据库连接bean

/** <br>
 *类说明：提供对数据表guestbook的添加、修改、删除和数据查询<br>
 *建立日期：2005-10-22 <br>
 *建立人 ： D2Frobot1.04程序生成<br>
 *修改日期：  <br>
 *修改原因：  <br>
 *修改人  ：  <br>
 */

public class Guestbook {
  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);
  }

  private int ID = -1;
  public void setID(int newFiled) {
    ID = newFiled;
  }

  public int getID() {
    return ID;
  }

  private String NAME = "";
  public void setNAME(String newFiled) {
    NAME = newFiled;
  }

  public String getNAME() {
    return NAME;
  }

  private String CONTENT = "";
  public void setCONTENT(String newFiled) {
    CONTENT = newFiled;
  }

  public String getCONTENT() {
    return CONTENT;
  }

  private String EMAIL = "";
  public void setEMAIL(String newFiled) {
    EMAIL = newFiled;
  }

  public String getEMAIL() {
    return EMAIL;
  }

  private String IP = "";
  public void setIP(String newFiled) {
    IP = newFiled;
  }

  public String getIP() {
    return IP;
  }

  /**
   *<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;
  }

} //end :)~