button_student.java

一个学生学籍管理的小系统,功能不是非常多,但是大部分已经有了.

/*
 * @(#)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_Student
{
	JFrame f=new JFrame();
	JButton Save;
	JButton Exit;
	JTextField textfield_Sno;
	JTextField textfield_Sname;
	JTextField textfield_Ssex;
	JTextField textfield_Sage;
	Object[] options={"确定"};
	public int as()
		{
			int q=Integer.parseInt(textfield_Sage.getText());
			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 if((q>150)||(q<10)||textfield_Sage.getText().length()==0)
		    {
			String str1=new String("警告！年龄的文本框不能为空或超出日期范围.");
		    JOptionPane.showOptionDialog(null,str1,
			"警告窗口！",JOptionPane.DEFAULT_OPTION,
			JOptionPane.WARNING_MESSAGE,null,options,
			options[0]);
			textfield_Sage.setText("");
		    return 0;
		    }
		    else
		    {
		    	return 1;
		    	}
			}
	public Button_Student()
	{
		
		Container c=f.getContentPane();
	    GridBagLayout gbLayoutObj; 
	    GridBagConstraints gbcObj;
	    
	    gbLayoutObj=new GridBagLayout();
	    gbcObj=new GridBagConstraints();	    		
		c.setLayout(gbLayoutObj); 
	    c.setBackground(Color.cyan);
	    f.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_Sno=new JLabel("输入学生学号:");
	    textfield_Sno=new JTextField(10);
	    JPanel panel_Sno=new JPanel();

	    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);
		
	    JLabel label_Sage=new JLabel("输入学生年龄:");
	    textfield_Sage=new JTextField(10);
	    JPanel panel_Sage=new JPanel();
	    panel_Sage.setLayout(flayout);
	    gbcObj.anchor=GridBagConstraints.WEST;		
		gbcObj.gridx=0;
		gbcObj.gridy=5;		
		gbcObj.gridwidth=1;
		gbcObj.gridheight=1;
		panel_Sage.add(label_Sage);
		panel_Sage.add(textfield_Sage);
		gbLayoutObj.setConstraints(panel_Sage,gbcObj);
		c.add(panel_Sage);
	    
	    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=6;		
		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 student values('"+textfield_Sno.getText()+"','"+textfield_Sname.getText()+"','"+textfield_Ssex.getText()+"','"+textfield_Sage.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()+"年龄:"+Integer.parseInt(textfield_Sage.getText()));
	            String str2=new String("学号:"+textfield_Sno.getText()+"姓名:"+textfield_Sname.getText()+"性别:"+textfield_Ssex.getText()+"年龄:"+Integer.parseInt(textfield_Sage.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_Student");
		f.setBounds(200,200,500,500); 
		f.setVisible(true);
		}
		
}