articleview.java

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

/**
 * @(#)articleview.java
 *
 *
 * @author Administrator
 * @version 1.00 2006/10/9
 */
package until;

import java.sql.*;
import database.conn;
import javax.*;

public class articleview 
{
	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 content;
	
	conn cn = new conn();

    public articleview() 
    {
    	id = 1;
    	BigClass = "";
    	SmallClass = "";
    	title = "";
    	keyword = "";
    	author = "";
    	source = "";
    	propert_r = "";
    	propert_t = "";
    	datetimes = "";
    	content = "";
    }
    public void setId(int id)
    {
    	this.id = id;
    }
    public String getBigclass()
    {
    	return BigClass;
    }
    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 getContent()
    {
    	return content;
    }
    
    public void views()
    {
    	try
    	{
    		String strsql = "select * from C_Article where id="+id+"";
    		ResultSet rs = cn.executeQuery(strsql);
    		if(rs.next())
    		{
    			BigClass = rs.getString("BigClass");
    	        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");
    	        content = rs.getString("content");
    		}
    		cn.closestmt();
    		cn.closeconn();
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}
    }
    
}