src/com/bar/db/Words.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.bar.db;

/**
 *数据库表
  DROP TABLE IF EXISTS `words`;
  CREATE TABLE words (
  wordsid bigint(20) NOT NULL auto_increment,
  content mediumtext,
  userid bigint(20) NOT NULL default '0',
  goodinfoid bigint(20) NOT NULL default '0',
  createtime timestamp   NOT   NULL   default   CURRENT_TIMESTAMP,
  PRIMARY KEY  (wordsid),
  UNIQUE KEY wordsid (wordsid)
  ) TYPE=MyISAM;
 */


import java.sql.*;

public class Words extends ExecuteDB
{
	//定义类成员变量
	private long wordsid;
	private String content;
	private long userid;
	private long goodinfoid;
	private String strSql;

    //构造函数，对成员变量进行初始化赋值
	public Words()
	{
		this.wordsid=0;
		this.content="";
		this.goodinfoid=0;
		this.userid=0;
		this.strSql="";
	}

	//添加新留言，往words数据表中添加一条新记录
	public boolean add()
	{
		this.strSql="insert into words ";
		this.strSql=this.strSql + "(content,userid,goodinfoid)";
		this.strSql=this.strSql + "values('" + this.content + "','" + this.userid + "','" + this.goodinfoid + "')";
		boolean isAdd = super.exeSql(this.strSql);

		return isAdd;
	}

  	//获取wordsid对应的留言信息，将这些信息赋值给相应的类变量
	public boolean init()
	{
    	this.strSql="select * from `words` where wordsid=";
        this.strSql=this.strSql + "'" + this.wordsid + "'";
		try