add.java

基于mod1编程的Java程序

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

public class Add extends JFrame
{
	JPanel contentPane;
	JLabel label1=new JLabel("输入新的学生资料",JLabel.CENTER);
	JTextField stu_number=new JTextField();
	JTextField name=new JTextField();
	JTextField sex=new JTextField();
	JTextField age=new JTextField();
	JTextField department=new JTextField();
	JTextField classes=new JTextField();
	JTextField pho_number=new JTextField();
	JTextField qinshi=new JTextField();
	JTextField remark=new JTextField();
	JLabel 学号=new JLabel("学号：",JLabel.CENTER);
	JLabel 姓名=new JLabel("姓名：",JLabel.CENTER);
	JLabel 性别=new JLabel("性别：",JLabel.CENTER);
	JLabel 年龄=new JLabel("年龄：",JLabel.CENTER);
	JLabel 系别=new JLabel("系别：",JLabel.CENTER);
	JLabel 班级=new JLabel("班级：",JLabel.CENTER);
	JLabel 电话=new JLabel("电话：",JLabel.CENTER);
	JLabel 寝室=new JLabel("寝室：",JLabel.CENTER);
	JLabel 备注=new JLabel("备注：",JLabel.CENTER);
	JButton button1=new JButton("ADD");
	JButton button2=new JButton("CANCEL");
	int x=0,y=0,w,h;

	public Add()
	{
		final JFrame frame=this;
		contentPane = (JPanel) this.getContentPane();
		contentPane.setLayout(null);
		label1.setFont(new java.awt.Font("Dialog", 1, 20));
		contentPane.add(label1,null);
		contentPane.add(学号,null);
		contentPane.add(stu_number,null);
		contentPane.add(姓名,null);
		contentPane.add(name,null);
		contentPane.add(性别,null);
		contentPane.add(sex,null);
		contentPane.add(年龄,null);
		contentPane.add(age,null);
		contentPane.add(系别,null);
		contentPane.add(department,null);
		contentPane.add(班级,null);
		contentPane.add(classes,null);
		contentPane.add(电话,null);
		contentPane.add(pho_number,null);
		contentPane.add(寝室,null);
		contentPane.add(qinshi,null);
		contentPane.add(备注,null);
		contentPane.add(remark,null);
        contentPane.add(button1,null);
		contentPane.add(button2,null);
		this.setBounds(new Rectangle(150,150,400,350));
		w=this.getSize().width;
		h=this.getSize().height;
		x=w/8;
		y=h/12;
		label1.setBounds(new Rectangle(2*x,0,4*x,2*y));
		学号.setBounds(new Rectangle(0,2*y,2*x,y));
		stu_number.setBounds(new Rectangle(2*x,2*y,3*x,y));

		姓名.setBounds(new Rectangle(0,3*y,2*x,y));
		name.setBounds(new Rectangle(2*x,3*y,2*x,y));

		性别.setBounds(new Rectangle(0,4*y,2*x,y));
		sex.setBounds(new Rectangle(2*x,4*y,x,y));

		年龄.setBounds(new Rectangle(0,5*y,2*x,y));
		age.setBounds(new Rectangle(2*x,5*y,x,y));

		系别.setBounds(new Rectangle(0,6*y,2*x,y));
		department.setBounds(new Rectangle(2*x,6*y,3*x,y));

		班级.setBounds(new Rectangle(0,7*y,2*x,y));
		classes.setBounds(new Rectangle(2*x,7*y,2*x,y));

		电话.setBounds(new Rectangle(0,8*y,2*x,y));
		pho_number.setBounds(new Rectangle(2*x,8*y,3*x,y));

		寝室.setBounds(new Rectangle(0,9*y,2*x,y));
		qinshi.setBounds(new Rectangle(2*x,9*y,2*x,y));

		备注.setBounds(new Rectangle(0,10*y,2*x,y));
		remark.setBounds(new Rectangle(2*x,10*y,5*x,y));

		button1.setBounds(new Rectangle(5*x,2*y,2*x,y));
		button2.setBounds(new Rectangle(5*x,4*y,2*x,y));
		button1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				if(e.getSource()==button1)
		       {
					if(stu_number.getText().equals(""))
				   {
						JOptionPane.showMessageDialog(null,"不能空！","Message",0);
				   }
				   else
				   {
					   try
					   {
						   Addstudent();
					   }
					   catch(SQLException ee)
					   {
					   }
				   }
			   }
			}
		});

		this.setResizable(false);
		this.setTitle("Add");
		this.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		this.show();
	}
    public void Addstudent() throws SQLException
	{
		String s="'"+stu_number.getText()+"'"+"'"+name.getText()+"'"+"'"+sex.getText()+"'"+"'"+age.getText()+"'"+"'"+department.getText()+"'"+"'"+classes.getText()+"'"+"'"+pho_number.getText()+"'"+"'"+qinshi.getText()+"'"+"'"+remark.getText()+"'";
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
		}
		Connection con=DriverManager.getConnection("jdbc:odbc:asan","","");
		Statement sql=con.createStatement();
		String s1="INSERT INTO student VALUES"+"("+s+")";
		sql.executeUpdate(s1);
		JOptionPane.showMessageDialog(null,"Username or Password Error!","Message",0);
	}

	//public static void main(String args[])
	//{
		//Add add=new Add();
	//}
}