/**
 *  Title  pams
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2005-05-11
 *  SysConfig encapsulation  
 *  Filename:SysConfig.java
 **/

package pams.system;

import pams.database.DBConnect;
import pams.util.DataConvert;

import java.sql.*;
import java.util.*;

public class SysConfig {

	public String SCName, Description, SCValue, Type;

	public SysConfig() {
	};

	public String getSCName() {
		return SCName;
	}

	public void setSCName(String s) {
		this.SCName = s;
	}

	public String getDescription() {
		return Description;
	}

	public void setDescription(String s) {
		this.Description = s;
	}

	public String getSCValue() {
		return SCValue;
	}

	public void setSCValue(String s) {
		this.SCValue = s;
	}

	public String getType() {
		return Type;
	}

	public void setType(String s) {
		this.Type = s;
	}

	/*
	 * Find SysConfig by Name
	 */
	public static SysConfig FindByName(String _SCName) {
		DBConnect dbc = null;
		SysConfig sysconfig = new SysConfig();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM sysconfig WHERE Name = ?");
			dbc.setString(1, _SCName);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				sysconfig.setSCName(rs.getString("Name"));
				sysconfig.setSCValue(rs.getString("SCValue"));
				sysconfig.setDescription(rs.getString("Description"));
				sysconfig.setType(rs.getString("Type"));
			} else {
				sysconfig = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				sysconfig = null;
			}
		}
		return sysconfig;

	}
	
	/*
	 * Add SysConfig
	
	public static String Add(String _SCName, String _SCValue,
			String _Description,String _Type, String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("INSERT INTO sysconfig (Name,SCValue,Description,Type) VALUES (?,?,?,?)");
			dbc.setString(1, _SCName);
			dbc.setString(2, _SCValue);
			dbc.setString(3, _Description);
			dbc.setString(4, _Type);
			dbc.executeUpdate();
			Log.Add(_UserName, "sysconfig", "Add");
			dbc.close();
			return "1";

		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}
	}
 */
	/*
	 * Modify SysConfig
	 */

	public static String Modify(String _SCName, String _SCValue,
			String _Description, String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE sysconfig SET Description=?,SCValue=? WHERE Name=?");
			dbc.setString(1, _Description);
			dbc.setString(2, _SCValue);
			dbc.setString(3, _SCName);
			dbc.executeUpdate();
			Log.Add(_UserName, "sysconfig", "Modify");
			dbc.close();
			return "1";

		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}
	
	/*
	 * Delete SysConfig
	
	public static String Delete(String _SCName,String _UserName) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM sysconfig WHERE Name=?");
			dbc.setString(1, _SCName);
			dbc.executeUpdate();
			Log.Add(_UserName, "sysconfig", "Delete");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}
 */	
	/*
	 * List SysConfig By Type
	 */
	public static Vector ListByType(String _Type) {
		DBConnect dbc = null;
		Vector SysConfigVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM sysconfig WHERE Type=? ORDER BY Name ASC");
			dbc.setString(1, _Type);
			ResultSet rs = dbc.executeQuery();
			rs = dbc.executeQuery();
			while (rs.next()) {
				SysConfig sysconfig = new SysConfig();
				sysconfig.setSCName(rs.getString("Name"));
				sysconfig.setSCValue(rs.getString("SCValue"));
				sysconfig.setDescription(rs.getString("Description"));
				sysconfig.setType(rs.getString("Type"));
				SysConfigVector.add(sysconfig);
			}
		} catch (Exception e) {
			System.err.println("error:" + e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return SysConfigVector;
	}
}