import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ChuBanSheTianjia extends JFrame implements ActionListener{
	public final static int TO_INSEART=1,TO_UPDATE=2;
	int insql;
	ShuJuKu db=new ShuJuKu();
	ResultSet rs;
    public JTextField fields[];
    JLabel labels[];
    public JTextArea textArea;
    JButton b1,b2;
    String labelsName[]={"出版社名字","出版社地址","出版社網站","出版社郵箱"};
    public ChuBanSheTianjia(int inseartOrUpdate){
        super("出版社管理");
        insql=inseartOrUpdate;
        labels=new JLabel[4];
        fields=new JTextField[4];
        JPanel p1=new JPanel();
        JPanel p2=new JPanel();
        JPanel p3=new JPanel();
        JPanel p4=new JPanel();
        JPanel p5=new JPanel();
        p1.setLayout(new GridLayout(4,1,0,10));
        p2.setLayout(new GridLayout(4,1,0,10));
        for(int i=0;i<4;i++){
            labels[i]=new JLabel(labelsName[i]+":");
            fields[i]=new JTextField(15);
            p1.add(labels[i]);
            p2.add(fields[i]); 
        }
        p3.setBorder(BorderFactory.createTitledBorder("出版社簡介"));
        textArea=new JTextArea(5,15);
        JScrollPane t=new JScrollPane(textArea);
        b1=new JButton("確定按鈕");
        b1.addActionListener(this);
        b2=new JButton("取消按鈕");
        b2.addActionListener(this);
        p3.add(t);
        p4.add(p1);
        p4.add(p2);
        p4.add(p3);
        p5.add(b1);
        p5.add(b2);
        Container c=getContentPane();
        c.add(p4,BorderLayout.CENTER);
        c.add(p5,BorderLayout.SOUTH);
        if(insql==1){
        
        fields[0].setEnabled(true);}  
        else{
        	fields[0].setEnabled(false);
        } 
    }
    
   
    public void actionPerformed(ActionEvent e) {
        if(e.getSource()==b2)
		{
			db.closeConnection();
			this.dispose();
		}
        else if(e.getSource()==b1){
           	if(fields[0].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"出版社名不能為空");
			}
			else if(fields[1].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"出版社地址不能為空");
			}
			else if(fields[2].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"出版社網站不能為空");
			}
			else if(fields[3].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"出版社地址不為空");
			}	
			else
			{  
			 //--設置窗口功能--
			 if(insql==1){
				try
				{
					String strSQL="insert into chubanshe(chubansheming,dizhi,chubanshewang,chubansheyou,chubanshebeizhu) values('"+
					fields[0].getText().trim()+"','"+
					fields[1].getText().trim()+"','"+
					fields[2].getText().trim()+"','"+
					fields[3].getText().trim()+"','"+
					textArea.getText().trim()+"')";
					
					
					if(db.updateSql(strSQL))
					{
						JOptionPane.showMessageDialog(null,"添加信息成功！");
						//this.dispose();
					}
					else
					{
						JOptionPane.showMessageDialog(null,"添加信息失敗請認真填寫各項信息!");
						this.dispose();
					}
					db.closeConnection();
				}
			        catch(Exception ex)
			        {
				      System.out.println(ex.toString());
			        }
			}
			//--修改口功能--
			else{
			  try
				{
					String strSQL="update chubanshe set dizhi='"+fields[1].getText().trim()+"',"+"chubanshewang='"+fields[2].getText().trim()+"',"+"chubansheyou='"+fields[3].getText().trim()+"',"+"chubanshebeizhu='"+textArea.getText().trim()+"'where chubansheming='"+fields[0].getText().trim()+"'";
					if(db.updateSql(strSQL))
					{
						JOptionPane.showMessageDialog(null,"修改信息成功！");
						this.dispose();
					}
					else
					{
						JOptionPane.showMessageDialog(null,"修改信息失敗！");
						this.dispose();
					}
					db.closeConnection();
				}
			        catch(Exception ex)
			        {
				      System.out.println(ex.toString());
			        }	
			}
          }
        }
    }
    
}