src/com/bar/db/Systems.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/**
 * @(#)System.java
 *
 *
 * @author
 * @version 1.00 2009/11/27
 */
package com.bar.db;

import java.sql.*;

public class Systems extends ExecuteDB {


    //定义类成员变量
	private long sid;
	private String sitename;
	private String description;
	private String keywords;
	private String author;
	private String email;
	private String tel;
	private String strSql;

public Systems()
{
	    super();
		this.sid=1;
		this.sitename="汽车销售系统";
		this.description="汽车销售管理系统";
		this.keywords="汽车 销售";
		this.author="@@@";
		this.email="";
		this.tel="";
		this.strSql="";
}
//修改sID对应的网站信息
public boolean update()
	{
		this.strSql="update systems set";
		this.strSql=this.strSql + " sitename=" + "'" + this.sitename + "',";
		this.strSql=this.strSql + " description=" + "'" + this.description + "',";
		this.strSql=this.strSql + " keywords=" + "'" + this.keywords + "',";
		this.strSql=this.strSql + " author=" + "'" + this.author + "',";
		this.strSql=this.strSql + " email=" + "'" + this.email + "',";
		this.strSql=this.strSql + " tel=" + "'" + this.tel + "'";
		this.strSql=this.strSql + " where sid='" + this.sid + "'";
		boolean isUpdate = super.exeSql(this.strSql);

		return isUpdate;
	}
	 	//获得sID对应的用户的信息，将这些信息赋值给相应的类变量
	public boolean init()
	{
		this.strSql="select * from `systems` where sid=";
		this.strSql=this.strSql + "'" + this.sid + "'";

		try
		{
			ResultSet rs = super.exeQuery(this.strSql);