src/com/bar/db/Article.java

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

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

package com.bar.db;

import java.sql.*;

public class Article extends ExecuteDB
{
	//定义类成员变量
	private long articleid;
	private String title;
	private String content;
	private long userid;
	private int readcount;
	private int recount;
        private long typeid;
        private String createtime;
	private String strSql;

    //构造函数，对成员变量进行初始化赋值
	public Article()
	{
		this.articleid=0;
		this.title="";
		this.content="";
		this.readcount=0;
                this.recount=0;
		this.userid=0;
                this.typeid=0;
                this.createtime="";
		this.strSql="";
	}

	//添加新文章，往articles数据表中添加一条新记录
	public boolean add()
	{
		this.strSql="insert into articles ";
		this.strSql=this.strSql + "(";
		this.strSql=this.strSql + "title,content,userid,readcount,recount,typeid)";
		this.strSql=this.strSql + "values('" + this.title + "','" + this.content + "','" + this.userid + "','" + this.readcount + "','" + this.recount + "','" + this.typeid + "')";
		boolean isAdd = super.exeSql(this.strSql);

		return isAdd;
	}

  	//删除articleid对应的文章的信息
		public boolean delete(String sActicleid)
	{
		this.strSql="delete from articles";
		this.strSql=this.strSql + "  where articleid in ("+ sActicleid +")";

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

	//验证articleid和userid是否匹配
	public boolean valid()
	{
		this.strSql="select articleid from `articles` ";
		this.strSql=this.strSql + " where articleid='" + this.articleid + "'";
		this.strSql=this.strSql + "  and userid='"+ this.userid + "'";
		System.out.println(this.strSql);