src/com/bar/db/Talk.java

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

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

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

package com.bar.db;
import java.sql.*;
/**
 *
 *DROP TABLE IF EXISTS `talk`;
  CREATE TABLE talk (
  talkid bigint(20) NOT NULL auto_increment,
  content mediumtext,
  userid bigint(20) NOT NULL default '0',
  createtime timestamp   NOT   NULL   default   CURRENT_TIMESTAMP,
  PRIMARY KEY  (talkid),
  UNIQUE KEY talkid (talkid)
  ) TYPE=MyISAM;
 *
 */
public class Talk extends ExecuteDB{
        private long talkid;
	private String content;
	private long userid;
	private String strSql;
public Talk()
{
    this.talkid = 0;
    this.content="";
    this.userid = 0;
    this.strSql ="";
}
//添加新留言
	public boolean add()
	{
		this.strSql="insert into talk ";
		this.strSql=this.strSql + "(content,userid)";
		this.strSql=this.strSql + "values('" + this.content + "','" + this.userid + "')";
		boolean isAdd = super.exeSql(this.strSql);

		return isAdd;
	}
        //删除留言
        public boolean delete(String stalk)
        {
            this.strSql = "delete from talk where talkid in ( ";
            this.strSql = this.strSql + stalk + ")";

            boolean isDelete = super.exeSql(this.strSql);
            return isDelete;
        }

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