/*
 * @(#)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_Print
{
	String sql1;
	JFrame f=new JFrame();
	JButton Save;
	JButton Exit;
	JTextField textfield_1;
	JTextField textfield_2;
	JTextArea chinesetext=new JTextArea(5,30);
	Object[] options={"確定"};
	Container c=f.getContentPane();
	GridBagLayout gbLayoutObj; 
	GridBagConstraints gbcObj;	
	public Button_Print()
	{
		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_wel=new JLabel("學籍管理系統");
		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); 
	     
	    JLabel label_1=new JLabel("輸入學生學號:");
	    textfield_1=new JTextField(10);
	    JPanel panel_1=new JPanel();
	    panel_1.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=2;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_1.add(label_1);
		panel_1.add(textfield_1);
		gbLayoutObj.setConstraints(panel_1,gbcObj);
		c.add(panel_1);
		
		JLabel label_2=new JLabel("輸入學生姓名:");
	    textfield_2=new JTextField(10);
	    JPanel panel_2=new JPanel();
	    panel_2.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=3;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_2.add(label_2);
		panel_2.add(textfield_2);
		gbLayoutObj.setConstraints(panel_2,gbcObj);
		c.add(panel_2);
		
	     
	    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=4;		
		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((textfield_1.getText().length()==0)&&(textfield_2.getText().length()==0))
				{
					String str1=new String("警告！你沒有輸入任何數據.");
				    JOptionPane.showOptionDialog(null,str1,
					"警告窗口！",JOptionPane.DEFAULT_OPTION,
					JOptionPane.WARNING_MESSAGE,null,options,
					options[0]);				
					return;	
					}  
				else if(textfield_1.getText().length()==0)
				{
					sql1=new String("select student.Sno,student.Sname,student.Scno,student.Sage,class.Cname,class.Cdepartment,course.Cno,course.Cname,result.Cresult,teacher.Teacher from student,class,course,result,teacher where student.Sname='"+textfield_2.getText()+"' and result.Cname='"+textfield_2.getText()+"' and result.COno=course.Cno and student.Scno=class.Cno and result.COno=teacher.Cno;");
					}
				else if(textfield_2.getText().length()==0) 	
				{
					sql1=new String("select student.Sno,student.Sname,student.Scno,student.Sage,class.Cname,class.Cdepartment,course.Cno,course.Cname,result.Cresult,teacher.Teacher from student,class,course,result,teacher where student.Sno='"+textfield_1.getText()+"' and result.Sno='"+textfield_1.getText()+"' and result.COno=course.Cno and student.Scno=class.Cno and result.COno=teacher.Cno;");
					}
				else
				{
					sql1=new String("select student.Sno,student.Sname,student.Scno,student.Sage,class.Cname,class.Cdepartment,course.Cno,course.Cname,result.Cresult,teacher.Teacher from student,class,course,result,teacher where student.Sno='"+textfield_1.getText()+"' and result.Sno='"+textfield_1.getText()+"' and result.COno=course.Cno and student.Scno=class.Cno and result.COno=teacher.Cno;");
					}
				Connection con;
		        Statement stm;					       				
				try {Class.forName("com.mysql.jdbc.Driver").newInstance();  }
	            catch(Exception e)
	            {  System.out.println(e.getMessage());}
	            try{con=DriverManager.getConnection("jdbc:mysql://localhost/shujuku?user=root&password=linbaowei");            
	            stm=con.createStatement();	     
			    ResultSet rs=stm.executeQuery(sql1); 
			    String string1;
			    String string2;
			    String string3;
			    String string4;
			    String string5;
			    String string6;
			    String string7;
			    String string8;
			    String string9;
			    String string10;
			    chinesetext.append("學號"+'■'+"姓名"+'■'+"班級"+'■'+"年齡"+'■'+"專業"+'■'+"學院"+'■'+"課程代碼"+'■'+"課程名"+'■'+"成績"+'■'+"教師"+'\n');
			    while (rs.next())
			     {
			      string1=rs.getString(1); 
			      string2=rs.getString(2);
			      string3=rs.getString(3);
			      string4=rs.getString(4);
			      string5=rs.getString(5); 
			      string6=rs.getString(6);
			      string7=rs.getString(7);
			      string8=rs.getString(8);
			      string9=rs.getString(9); 
			      string10=rs.getString(10);			          
			      chinesetext.append(string1+'■'+string2+'■'+string3+'■'+string4+'■'+string5+'■'+string6+'■'+string7+'■'+string8+'■'+string9+'■'+string10); 
			     }
			    stm.close(); 
	            con.close();
	            }
	            catch(SQLException ep){ System.out.println(	ep.getMessage()); }		
		  }});
		  Exit.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent asd)
			{	
				System.exit(0);
				}});
		chinesetext.setBackground(Color.pink);  
	    JLabel label_4=new JLabel("查詢的結果:");
	    JPanel panel_4=new JPanel();
	    panel_2.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=5;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_4.add(label_4);
		panel_4.add(chinesetext);
		gbLayoutObj.setConstraints(panel_4,gbcObj);
		c.add(panel_4);
	     
		f.setSize(600,300);
		f.setTitle("Button_Print");
		f.setBounds(200,200,500,500); 
		f.setVisible(true);
		}	
	}