articleupdate.java

是一个JSP与数据库应用系统

package until;

import java.sql.*;
import admin.article;
import database.conn;

public class articleUpdate
{
	private int id;
	private String BigClass;
	private String SmallClass;
	private String title;
	private String keyword;
	private String author;
	private String source;
	private String propert_r;
	private String propert_t;
	private String datetimes;
	private String isno;
	private String content;
	
	conn cn = new conn();
	
	public void setId(int id)
	{
		this.id = id;
	}
	public void setBigClass(String BigClass)
	{
		this.BigClass = BigClass;
	}
	
	public articleUpdate()
	{
		id = 1;
		BigClass = "";
		SmallClass = "";
		title = "";
		keyword = "";
		author = "";
		source = "";
		propert_r = "";
		propert_t = "";
		datetimes = "";
		isno = "";
		content = "";
	}
	
	public String getSmallClass()
	{
		return SmallClass;
	}
	
	public String getTitle()
	{
		return title;
	}
	
	public String getKeyword()
	{
		return keyword;
	}
	
	public String getAuthor()
	{
		return author;
	}
	
	public String getSource()
	{
		return source;
	}
	
	public String getPropert_r()
	{
		return propert_r;
	}
	
	public String getPropert_t()
	{
		return propert_t;
	}
	
	public String getDatetimes()
	{
		return datetimes;
	}
	
	public String getIsno()
	{
		return isno;
	}
	
	public String getContent()
	{
		return content;
	}
	
	
	
	
	
	public boolean list()
	{
		boolean flag = false;
		try
		{
			String strsql = "select * from C_Article where id="+id+"";
			ResultSet rs = cn.executeQuery(strsql);
			if (rs.next())
			{
				SmallClass = rs.getString("SmallClass");
				title = rs.getString("title");
				keyword = rs.getString("keyword");
				author = rs.getString("author");
				source = rs.getString("source");
				propert_r = rs.getString("propert_r");
				propert_t = rs.getString("propert_t");
				datetimes = rs.getString("datetimes");
				isno = rs.getString("isno");
				content = rs.getString("content");
				flag = true;
			}
			else
			{
				flag = false;
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		return flag;
	}
}