policymanage.java

一个基于JAVA技术的销售信息管理系统

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import org.eclipse.swt.SWT;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Combo;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.List;
import org.eclipse.swt.widgets.MessageBox;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.TableItem;
import org.eclipse.swt.widgets.Text;
import org.eclipse.swt.widgets.ToolBar;
import org.eclipse.swt.widgets.ToolItem;

import com.swtdesigner.SWTResourceManager;


public class PolicyManage extends Composite {

	private MessageBox messageBox;
	private Table table;
	private Text text_5;
	private Combo combo;
	private Text text_4;
	private Text text_3;
	private Text text_2;
	private Text text_1;
	private List list;
	private Button button;
	private Button button_1;
	private Button button_2;
	private Button button_3;
	private Button button_4;
	private Button button_6;
	private Label label_1;
	private Label label_2;
	private Label label_3;
	private Label emailLabel;
	private Label label_5;
	private Label label_6;
	private Label label_7;

	private String id;
	private String pwd;
	private String ID;
	private int type;
	private Date datetime;
	private Composite parent;
	private int parentID;
	
	private boolean flag	=	true;
	/**
	 * Create the composite
	 * @param parent
	 * @param style
	 */
	public PolicyManage(final Composite parent, int style,String id,String pwd,String ID) {
		super(parent, style);
		this.parent	=	parent;
		this.id		=	id;
		this.pwd	=	pwd;
		this.ID		=	ID;
		this.setBounds(0, 0, 699, 470);

		final Label label = new Label(this, SWT.SEPARATOR | SWT.HORIZONTAL);
		label.setBounds(0, 45, 700, 2);

		final Label label_4 = new Label(this, SWT.NONE);
		label_4.setFont(SWTResourceManager.getFont("经典行楷繁", 22, SWT.NONE));
		label_4.setAlignment(SWT.CENTER);
		label_4.setText("策略公告管理平台");
		label_4.setBounds(0, 10, 700, 29);

		list = new List(this, SWT.V_SCROLL | SWT.BORDER);
		list.setBounds(36, 68, 624, 130);
		listPolicy();

		final ToolBar toolBar = new ToolBar(this, SWT.NONE);
		toolBar.setBounds(36, 216, 118, 25);

		
		final ToolItem newItemToolItem = new ToolItem(toolBar, SWT.RADIO);
		newItemToolItem.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				list.setEnabled(true);
				listPolicy();
				PublicDisplay();
			}
		});
		newItemToolItem.setText("公告发布");
		newItemToolItem.setSelection(true);

		final ToolItem newItemToolItem_1 = new ToolItem(toolBar, SWT.RADIO);
		newItemToolItem_1.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				list.setEnabled(false);
				DelDisplay();
				searchPolicy();
			}
		});
		newItemToolItem_1.setText("公告删除");

		button_3 = new Button(this, SWT.NONE);
		button_3.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				if(table.getSelectionIndices().length<1)
				{
					messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
					messageBox.setMessage("请选择至少 1 条查询记录");
					messageBox.setText("删除公告信息");
					messageBox.open();
				}
				else
				{
					messageBox = new MessageBox(parent.getShell(),SWT.ICON_QUESTION|SWT.OK|SWT.CANCEL);
					messageBox.setMessage("确定要删除这 " + table.getSelectionIndices().length + " 条记录吗？");
					messageBox.setText("删除确认");
					if(messageBox.open() == SWT.OK)
					{
						String del_id = "";
						for(int i = 0; i < table.getSelectionIndices().length;)
						{
							TableItem temp = table.getItems()[table.getSelectionIndices()[i]];
							del_id	=	del_id + "'" +temp.getText(0) + "'";
							i++;
							if(i < table.getSelectionIndices().length)
								del_id = del_id + ",";
							
						}
						
						delPolicy(del_id);
						
						searchPolicy();
						
						messageBox = new MessageBox(parent.getShell(),SWT.ICON_INFORMATION);
						messageBox.setMessage("成功删除 " + table.getSelectionIndices().length + " 条记录");
						messageBox.setText("删除");
						messageBox.open();
						
					}
				}
			}
		});
		button_3.setText("删 除");
		button_3.setBounds(586, 216, 74, 22);
		//

		PolicyPublic();
		PublicDisplay();
	}

	private void PublicDisplay(){
		
		table.setVisible(false);
		button_3.setVisible(false);
		combo.setVisible(true);
		combo.setEnabled(false);
		label_1.setVisible(true);
		label_2.setVisible(true);
		label_3.setVisible(true);
		emailLabel.setVisible(true);
		label_5.setVisible(true);
		label_6.setVisible(true);
		label_7.setVisible(true);
		text_1.setVisible(true);
		text_2.setVisible(true);
		text_3.setVisible(true);
		text_4.setVisible(true);
		text_5.setVisible(true);
		button.setVisible(true);
		button_1.setVisible(true);
		button_2.setVisible(true);
		button_2.setSelection(true);
		button_4.setVisible(true);
		button_6.setVisible(true);
	}
	
	public void DelDisplay(){

		combo.setVisible(false);
		label_1.setVisible(false);
		label_2.setVisible(false);
		label_3.setVisible(false);
		emailLabel.setVisible(false);
		label_5.setVisible(false);
		label_6.setVisible(false);
		label_7.setVisible(false);
		text_1.setVisible(false);
		text_2.setVisible(false);
		text_3.setVisible(false);
		text_4.setVisible(false);
		text_5.setVisible(false);
		button.setVisible(false);
		button_1.setVisible(false);
		button_2.setVisible(false);
		button_4.setVisible(false);
		button_6.setVisible(false);
		table.setVisible(true);
		button_3.setVisible(true);
		
	}
	
	protected void PolicyPublic(){

		label_1 = new Label(this, SWT.CENTER);
		label_1.setFont(SWTResourceManager.getFont("宋体", 10, SWT.NONE));
		label_1.setText("姓  名");
		label_1.setBounds(35, 265, 60, 15);
		label_1.setVisible(false);

		label_2 = new Label(this, SWT.CENTER);
		label_2.setFont(SWTResourceManager.getFont("宋体", 10, SWT.NONE));
		label_2.setText("联系电话");
		label_2.setBounds(35, 300, 60, 15);
		label_2.setVisible(false);

		emailLabel = new Label(this, SWT.CENTER);
		emailLabel.setFont(SWTResourceManager.getFont("宋体", 10, SWT.NONE));
		emailLabel.setText("E-mail");
		emailLabel.setBounds(35, 335, 60, 15);
		emailLabel.setVisible(false);

		label_5 = new Label(this, SWT.CENTER);
		label_5.setFont(SWTResourceManager.getFont("宋体", 10, SWT.NONE));
		label_5.setText("当前日期");
		label_5.setBounds(35, 370, 60, 15);
		label_5.setVisible(false);

		text_1 = new Text(this, SWT.BORDER);
		text_1.setEnabled(false);
		text_1.setBounds(105, 260, 100, 20);
		text_1.setVisible(false);

		label_3 = new Label(this, SWT.CENTER);
		label_3.setFont(SWTResourceManager.getFont("宋体", 10, SWT.NONE));
		label_3.setText("公告类型");
		label_3.setBounds(35, 405, 60, 15);
		label_3.setVisible(false);

		text_2 = new Text(this, SWT.BORDER);
		text_2.setBounds(105, 294, 100, 20);
		text_2.setVisible(false);

		text_3 = new Text(this, SWT.BORDER);
		text_3.setBounds(105, 329, 100, 20);
		text_3.setVisible(false);

		text_4 = new Text(this, SWT.BORDER);
		text_4.setBounds(105, 365, 100, 20);
		text_4.setVisible(false);

		combo = new Combo(this, SWT.READ_ONLY);
		combo.setVisibleItemCount(8);
		combo.setBounds(272, 402, 95, 20);
		replyObject(combo);

		text_5 = new Text(this, SWT.BORDER);
		text_5.setBounds(220, 287, 438, 98);
		text_5.setVisible(false);
		table = new Table(this, SWT.MULTI | SWT.FULL_SELECTION | SWT.BORDER);
		table.setLinesVisible(true);
		table.setHeaderVisible(true);
		table.setBounds(36, 247, 624, 200);

		final TableColumn newColumnTableColumn = new TableColumn(table, SWT.NONE);
		newColumnTableColumn.setWidth(65);
		newColumnTableColumn.setText("公告编号");

		final TableColumn newColumnTableColumn_1 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_1.setWidth(60);
		newColumnTableColumn_1.setText("发布人");

		final TableColumn newColumnTableColumn_2 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_2.setWidth(65);
		newColumnTableColumn_2.setText("公告类型");

		final TableColumn newColumnTableColumn_3 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_3.setWidth(80);
		newColumnTableColumn_3.setText("E-mail");

		final TableColumn newColumnTableColumn_4 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_4.setWidth(70);
		newColumnTableColumn_4.setText("联系电话");

		final TableColumn newColumnTableColumn_5 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_5.setWidth(70);
		newColumnTableColumn_5.setText("发布时间");

		final TableColumn newColumnTableColumn_6 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_6.setWidth(90);
		newColumnTableColumn_6.setText("回复对应公告");

		final TableColumn newColumnTableColumn_7 = new TableColumn(table, SWT.NONE);
		newColumnTableColumn_7.setWidth(120);
		newColumnTableColumn_7.setText("公告内容");
		
		table.setVisible(false);

		button_4 = new Button(this, SWT.NONE);
		button_4.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				list.removeAll();
				listPolicy();
			}
		});
		button_4.setText("刷 新");
		button_4.setBounds(587, 218, 73, 22);
		
		label_6 = new Label(this, SWT.NONE);
		label_6.setFont(SWTResourceManager.getFont("宋体", 10, SWT.NONE));
		label_6.setText("内  容：");
		label_6.setBounds(222, 263, 60, 15);
		label_6.setVisible(false);

		button_2 = new Button(this, SWT.RADIO);
		button_2.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				
				combo.setEnabled(false);
				
			}
		});
		button_2.setText("公告");
		button_2.setBounds(113, 405, 45, 16);

		button_6 = new Button(this, SWT.RADIO);
		button_6.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(final SelectionEvent e) {
				
				combo.setEnabled(true);
			}
		});
		button_6.setText("回复");