add.java

简单java成绩管理 提供添加 统计 修改功能

import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextField;

/**
* This code was edited or generated using CloudGarden's Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE.
*/
public class add extends JFrame implements ActionListener{
	private JLabel label_c0;
	private JLabel label_c1;
	private JLabel label_c2;
	private JLabel label_c3;
	private JLabel label_c4;
	private JLabel label_c5;
	
	private JTextField textfield_c0;
	private JTextField textfield_c1;
	private JTextField textfield_c2;
	private JTextField textfield_c3;
	private JTextField textfield_c4;
	private JTextField textfield_c5;
	
	private JButton button_next;
	private JButton button_close;
	databasemanager dbm;
	public add(databasemanager dbm){
		this.dbm=dbm;
		initframe();
		//this.transferFocusBackward()
	}
	public void initframe(){
		this.setTitle("添加成绩");
		this.setSize(344, 290);
		getContentPane().setLayout(new GridLayout(7,2));
		
		
		{
			label_c0 = new JLabel("学号",JLabel.CENTER);
			label_c0.setFont(allset.font_label);
			label_c0.setFocusable(false);
			getContentPane().add(label_c0);
			textfield_c0=new JTextField("0710070701");
			getContentPane().add(textfield_c0);
			
			textfield_c0.addActionListener(this);
			//label_c1.setPreferredSize(new java.awt.Dimension(97, 51));
		}
		
		{
			label_c1 = new JLabel("Java语言",JLabel.CENTER);
			label_c1.setFont(allset.font_label);
			label_c1.setFocusable(false);
			getContentPane().add(label_c1);
			textfield_c1=new JTextField();
			getContentPane().add(textfield_c1);
			
			textfield_c1.addActionListener(this);
			//label_c1.setPreferredSize(new java.awt.Dimension(97, 51));
		}
		{
			label_c2 = new JLabel("C语言",JLabel.CENTER);
			label_c2.setFont(allset.font_label);
			label_c2.setFocusable(false);
			getContentPane().add(label_c2);
			textfield_c2=new JTextField();
			getContentPane().add(textfield_c2);
			textfield_c2.addActionListener(this);
			//label_c1.setPreferredSize(new java.awt.Dimension(97, 51));
		}
		{
			label_c3 = new JLabel("数据库",JLabel.CENTER);
			label_c3.setFont(allset.font_label);
			label_c3.setFocusable(false);
			getContentPane().add(label_c3);
			textfield_c3=new JTextField();
			getContentPane().add(textfield_c3);
			textfield_c3.addActionListener(this);
			//label_c1.setPreferredSize(new java.awt.Dimension(97, 51));
		}
		{
			label_c4 = new JLabel("操作系统",JLabel.CENTER);
			label_c4.setFont(allset.font_label);
			label_c4.setFocusable(false);
			getContentPane().add(label_c4);
			textfield_c4=new JTextField();
			getContentPane().add(textfield_c4);
			textfield_c4.addActionListener(this);
			//label_c1.setPreferredSize(new java.awt.Dimension(97, 51));
		}
		{
			label_c5 = new JLabel("日语",JLabel.CENTER);
			label_c5.setFont(allset.font_label);
			label_c5.setFocusable(false);
			getContentPane().add(label_c5);
			textfield_c5=new JTextField();
			getContentPane().add(textfield_c5);
			textfield_c5.addActionListener(this);
			//label_c1.setPreferredSize(new java.awt.Dimension(97, 51));
		}
		{
			button_next=new JButton("下一个");
			button_close=new JButton("关闭");
			
			button_next.setFont(allset.font_label);
			button_close.setFont(allset.font_label);
			getContentPane().add(button_next);
			getContentPane().add(button_close);
			button_next.addActionListener(this);
			button_close.addActionListener(this);
		}
		this.setVisible(true);
	}
	public static void main(String[] args) {
		new add(new databasemanager());	

	}
	public void next(){
		//String[] ss=new String[2];
		
		boolean ifalladdright=true;
		
		String sql=dbm.createsql("insert into 成绩表 (学号,课程代码,成绩) values('??',?,?)",
				textfield_c0.getText());
		//System.out.println(sql);
		String[] ss=new String[2];
		if(textfield_c1.getText().length()>0){
			ss[0]="070101";
			ss[1]=textfield_c1.getText();
			int n=dbm.insert(sql,ss);
			System.out.println(n);
			if(n==0){
				ifalladdright=false;
				error("添加成绩<"+label_c1.getText()+">成绩出错!");
			}
			else{
				textfield_c1.setText("");
			}
		}
		
		if(textfield_c2.getText().length()>0){
			ss[0]="070102";
			ss[1]=textfield_c2.getText();
			int n=dbm.insert(sql,ss);
			if(n==0){
				ifalladdright=false;
				error("添加成绩<"+label_c2.getText()+">成绩出错!");
			}
			else{
				textfield_c2.setText("");
			}
		}
		
		
		if(textfield_c3.getText().length()>0){
			ss[0]="070103";
			ss[1]=textfield_c3.getText();
			int n=dbm.insert(sql,ss);
			if(n==0){
				ifalladdright=false;
				error("添加成绩<"+label_c3.getText()+">成绩出错!");
			}
			else{
				textfield_c3.setText("");
			}
		}
		
		
		if(textfield_c4.getText().length()>0){
			ss[0]="070104";
			ss[1]=textfield_c4.getText();
			int n=dbm.insert(sql,ss);
			if(n==0){
				ifalladdright=false;
				error("添加成绩<"+label_c4.getText()+">成绩出错!");
			}
			else{
				textfield_c4.setText("");
			}
		}
		
		
		if(textfield_c5.getText().length()>0){
			ss[0]="070105";
			ss[1]=textfield_c5.getText();
			int n=dbm.insert(sql,ss);
			if(n==0){
				ifalladdright=false;
				error("添加成绩<"+label_c5.getText()+">成绩出错!");
			}
			else{
				textfield_c5.setText("");
			}
		}
		
		
		
		if(ifalladdright==true){
			textfield_c0.setText("");
			textfield_c0.requestFocus();
		}
		
	}
	public void error(String ss){
		JOptionPane.showMessageDialog(this,ss,"错误",JOptionPane.ERROR_MESSAGE);
	}
	public boolean ifallhastext(){
		boolean ifhas=false;
		if(textfield_c1.getText().length()>0&&
				textfield_c2.getText().length()>0&&
				textfield_c3.getText().length()>0&&
				textfield_c4.getText().length()>0&&
				textfield_c5.getText().length()>0){
			ifhas=true;
		}
		
		return ifhas;
	}
	public void actionPerformed(ActionEvent ae) {
		if(ae.getSource().equals(button_next)){
			next();
			
		}
		else if(ae.getSource().equals(button_close)){
			dispose();
		}
		else{
			if(ifallhastext()==true){
				next();
			}
		}
		
		
	}
	
}