/*
 * @(#)Database.java 1.0 06/06/23
 * @作者：林寶尉
 */
package myprojects.ButtonsAction;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Button_Corse
{
	JFrame f=new JFrame();
	JButton Save;
	JButton Exit;
	JTextField textfield_Sno;
	JTextField textfield_Sname;
	JTextField textfield_Ssex;
	Object[] options={"確定"};
	Container c=f.getContentPane();
	GridBagLayout gbLayoutObj; 
	GridBagConstraints gbcObj;	
	public int as()
		{
			if(textfield_Sno.getText().length()==0)
			{
				System.out.println("警告！課程名文本框不能為空");
				String str1=new String("警告！課程名文本框不能為空.");
			    JOptionPane.showOptionDialog(null,str1,
				"警告窗口！",JOptionPane.DEFAULT_OPTION,
				JOptionPane.WARNING_MESSAGE,null,options,
				options[0]);
				textfield_Sno.setText("");
				return 0;
			}
			else if((textfield_Sname.getText().length()==0))
			{
				String str1=new String("警告！課程編號文本框不能為空.");
			    JOptionPane.showOptionDialog(null,str1,
				"警告窗口！",JOptionPane.DEFAULT_OPTION,
				JOptionPane.WARNING_MESSAGE,null,options,
				options[0]);
				textfield_Sname.setText("");
				return 0;
			}	
			else if((textfield_Ssex.getText().length()==0))
			{
				String str1=new String("警告！課程教師文本框不能為空.");
			    JOptionPane.showOptionDialog(null,str1,
				"警告窗口！",JOptionPane.DEFAULT_OPTION,
				JOptionPane.WARNING_MESSAGE,null,options,
				options[0]);
				textfield_Ssex.setText("");	
				return 0;			
			}		
		    else
		    {
		    	return 1;
		    	}
			} 
	public Button_Corse()
	{
		Container c=f.getContentPane();
	    GridBagLayout gbLayoutObj; 
	    GridBagConstraints gbcObj;
	    
	    gbLayoutObj=new GridBagLayout();
	    gbcObj=new GridBagConstraints();	    		
		c.setLayout(gbLayoutObj); 
	    c.setBackground(Color.cyan);
	    FlowLayout flayout;
	    flayout=new FlowLayout(FlowLayout.RIGHT,0,0);	    
	    
	    JLabel label_Sno=new JLabel("輸入課程名稱:");
	    textfield_Sno=new JTextField(10);
	    JPanel panel_Sno=new JPanel();

        JLabel label_wel=new JLabel("學籍管理系統(tǒng)");
		Font ft=new Font("宋體",Font.BOLD,26);
        label_wel.setFont(ft);
		gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=0;		
		gbLayoutObj.setConstraints(label_wel,gbcObj);
		c.add(label_wel);
	    
	    JLabel label_we=new JLabel("----課程基本信息錄入");
		Font ftt=new Font("隸書",Font.BOLD,24);
        label_we.setFont(ftt);
		gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=1;		
		gbLayoutObj.setConstraints(label_we,gbcObj);
		c.add(label_we);

	    panel_Sno.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=2;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_Sno.add(label_Sno);
		panel_Sno.add(textfield_Sno);
		gbLayoutObj.setConstraints(panel_Sno,gbcObj);
		c.add(panel_Sno);
	    
	    JLabel label_Sname=new JLabel("輸入課程編號:");
	    textfield_Sname=new JTextField(10);
	    JPanel panel_Sname=new JPanel();
	    panel_Sname.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=3;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_Sname.add(label_Sname);
		panel_Sname.add(textfield_Sname);
		gbLayoutObj.setConstraints(panel_Sname,gbcObj);
		c.add(panel_Sname);
		
		JLabel label_Ssex=new JLabel("輸入課程教師:");
	    textfield_Ssex=new JTextField(10);
	    JPanel panel_Ssex=new JPanel();
	    panel_Ssex.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=4;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_Ssex.add(label_Ssex);
		panel_Ssex.add(textfield_Ssex);
		gbLayoutObj.setConstraints(panel_Ssex,gbcObj);
		c.add(panel_Ssex);
	    
	    JPanel panel_button=new JPanel();
	    Save=new JButton("提交");
	    Exit=new JButton("退出");
	    FlowLayout flayout1=new FlowLayout(FlowLayout.CENTER,0,0);	    
	    panel_button.setLayout(flayout1);
	    gbcObj.anchor=GridBagConstraints.CENTER;		
		gbcObj.gridx=0;
		gbcObj.gridy=5;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_button.add(Save);
		panel_button.add(Exit);
		gbLayoutObj.setConstraints(panel_button,gbcObj);
		c.add(panel_button);
		Save.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent asd)
			{
				if(as()==1)
			    {  	
			    System.out.println("wqe");	    
			    Connection con;
		        Statement stm;				       				
				try {Class.forName("com.mysql.jdbc.Driver").newInstance();; System.out.println(	"try1"); }
	            catch(Exception e)
	            {  System.out.println(	e.getMessage());      }
	            try{con=DriverManager.getConnection("jdbc:mysql://localhost/shujuku?user=root&password=linbaowei");  
	                stm=con.createStatement();     
	                stm.executeUpdate("insert into course values('"+textfield_Sno.getText()+"','"+textfield_Sname.getText()+"','"+textfield_Ssex.getText()+"');");           
	            	stm.close(); 
	                con.close(); System.out.println("try2"); }
	            catch(SQLException ep){ System.out.println(	ep.getMessage()); }
	            System.out.println("課程號:"+textfield_Sno.getText()+"姓名:"+textfield_Sname.getText()+"性別:"+textfield_Ssex.getText());
	            String str2=new String("課程號:"+textfield_Sno.getText()+"姓名:"+textfield_Sname.getText()+"性別:"+textfield_Ssex.getText());
	            JOptionPane.showOptionDialog(null,str2,
				"警告窗口！",JOptionPane.DEFAULT_OPTION,
				JOptionPane.WARNING_MESSAGE,null,options,
				options[0]);			
		        }  
		  }});
	    Exit.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent asd)
			{	
				System.exit(0);
				}});
		f.setSize(400,400);
		f.setTitle("Button_Corse");
		f.setBounds(200,200,500,500); 
		f.setVisible(true);
		}	
	}