package com.customer;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.dbconn.DbConn;

public class Discuss {

	private int id;
	private String title;
	private String content;
	private String submiter;
	private String date;
	DbConn db=new DbConn();
	
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	public String getSubmiter() {
		return submiter;
	}
	public void setSubmiter(String submiter) {
		this.submiter = submiter;
	}
	public String getDate() {
		return date;
	}
	public void setDate(String date) {
		this.date = date;
	}
	
	public String getHeaderName(String userName){
		
		String sql="select * from user where name='"+userName+"'";
		ResultSet rs=db.query(sql);
		if(rs!=null){
			try {
				while(rs.next()){
					String headerName=rs.getString("header");
					return headerName;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return "";
	}
	
	
}