honorupdate.java

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

package until;

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

public class honorupdate
{
	private int id;
	private String title;
	private String times;
	private String content;
	
	conn cn = new conn();
	
	public honorupdate()
	{
		id = 1;
		title = "";
		times = "";
		content = "";
	}
	
	public void setId(int id)
	{
		this.id = id;
	}
	public String getTitle()
	{
		return title;
	}
	public String getTimes()
	{
		return times;
	}
	public String getContent()
	{
		return content;
	}
	
	public void updatehonor()
	{
		try
		{
			String strsql = "select * from C_Honor where id="+id+"";
			ResultSet rs = cn.executeQuery(strsql);
			if(rs.next())
			{
				title = rs.getString("title");
				times = rs.getString("datatimes");
				content = rs.getString("content");
			}
			cn.closestmt();
			cn.closeconn();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}