systemdate.java

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

package admin;

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

public class systemdate
{
	private String Sitename;
	private String Address;
	private String Linkman;
	private String Phone;
	private String Fax;
	private String Web;
	private String Email;
	private String Zipcode;
	
	private String strsql;
	
	conn cn = new conn();
	
	public systemdate()
	{
		Sitename = "";
		Address = "";
		Linkman = "";
		Phone = "";
		Fax = "";
		Web = "";
		Email = "";
		Zipcode = "";
	}
	
	public String getSitename()
	{
		return Sitename;
	}
	public void setSitename(String sitename)
	{
		this.Sitename = sitename;
	}
	
	public String getAddress()
	{
		return Address;
	}
	public void setAddress(String address)
	{
		this.Address = address;
	}
	
	public String getLinkman()
	{
		return Linkman;
	}
	public void setLinkman(String linkman)
	{
		this.Linkman = linkman;
	}
	
	public String getPhone()
	{
		return Phone;
	}
	public void setPhone(String phone)
	{
		this.Phone = phone;
	}
	
	public String getFax()
	{
		return Fax;
	}
	public void setFax(String fax)
	{
		this.Fax = fax;
	}
	
	public String getWeb()
	{
		return Web;
	}
	public void setWeb(String web)
	{
		this.Web = web;
	}
	
	public String getEmail()
	{
		return Email;
	}
	public void setEmail(String email)
	{
		this.Email = email;
	}
	
	public String getZipcode()
	{
		return Zipcode;
	}
	public void setZipcode(String zipcode)
	{
		this.Zipcode = zipcode;
	}
	
	public void execute()
	{
		try
		{
			strsql = "select top 1 * from C_SystemData";
			ResultSet rs = cn.executeQuery(strsql);
			if (rs.next())
			{
				 Sitename = rs.getString(2);
				 Address = rs.getString(3);
				 Linkman = rs.getString(4);
				 Phone = rs.getString(5);
				 Fax = rs.getString(6);
				 Web = rs.getString(7);
				 Email = rs.getString(8);
				 Zipcode = rs.getString(9);
			}
			else
			{
				String strsql1 = "insert into C_SystemData(Sitename,Address,Linkman,Phone,Fax,Web,Email,Zipcode) values('无知堂','黑龙江省哈尔滨市','无名','13674687381','66666666','blog.csdn.net/chenguang79/','[e-mail]','150010')";
			    cn.executeInsert(strsql1);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	

}