package?com.dianming.lyh;
import?java.awt.Color;
import?java.awt.Container;
import?java.awt.GridLayout;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.Statement;

import?javax.swing.JButton;
import?javax.swing.JDialog;
import?javax.swing.Jframe;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JTextField;
import?javax.swing.SwingConstants;


public?class?Add?implements?ActionListener?{
	JDialog?dialog;
	JTextField?tF1?=?new?JTextField（）;
	JTextField?tF2?=?new?JTextField（）;
	JTextField?tF3?=?new?JTextField（）;
	JTextField?tF4?=?new?JTextField（）;

	public?Add（）?{
		Jframe?f?=new?Jframe（）;
		dialog?=?new?JDialog（f?“添加學生信息“?true）;
		Container?dialogPane?=?dialog.getContentPane（）;
		dialogPane.setLayout（new?GridLayout（5?2））;
		JLabel?a1?=?new?JLabel（“學號“?SwingConstants.CENTER）;
		a1.setForeground（Color.BLUE）;
		dialogPane.add（a1）;
		dialogPane.add（tF1）;
		JLabel?a2?=?new?JLabel（“班級“?SwingConstants.CENTER）;
		a2.setForeground（Color.BLUE）;
		dialogPane.add（a2）;
		dialogPane.add（tF2）;
		JLabel?a3?=?new?JLabel（“姓名“?SwingConstants.CENTER）;
		a3.setForeground（Color.BLUE）;
		dialogPane.add（a3）;
		dialogPane.add（tF3）;
		JLabel?a4?=?new?JLabel（“性別“?SwingConstants.CENTER）;
		a4.setForeground（Color.BLUE）;
		dialogPane.add（a4）;
		dialogPane.add（tF4）;
		JButton?b1?=?new?JButton（“確定“）;
		b1.setForeground（Color.BLACK）;
		dialogPane.add（b1）;
		JButton?b2?=?new?JButton（“取消“）;
		b2.setForeground（Color.BLACK）;
		dialogPane.add（b2）;
		b1.addActionListener（this）;
		b2.addActionListener（this）;
		dialog.setBounds（200?150?400?200）;
		dialog.getRootPane（）.setDefaultButton（b1）;?
		dialog.setVisible（true）;

	}

	public?void?actionPerformed（ActionEvent?e）
	{
		String?cmd?=?e.getActionCommand（）;
		boolean?result?=?false;

		if?（cmd.equals（“確定“））?{

			if?（this.tF1.getText（）.trim（）.equals（““））?{
				JOptionPane.showMessageDialog（dialog?“學號不能為空“）;
				result?=?true;
			}?else?if?（tF2.getText（）.trim（）.equals（““））?{
				JOptionPane.showMessageDialog（dialog?“班級信息不能為空“）;
				result?=?true;
			}?else?if?（tF3.getText（）.trim（）.equals（““））?{
				JOptionPane.showMessageDialog（dialog?“姓名不能為空“）;
				result?=?true;
			}?else?if?（tF4.getText（）.trim（）.equals（““））?{
				JOptionPane.showMessageDialog（dialog?“學生性別不能為空“）;
				result?=?true;
			}
			
			if?（!result）?{
				try?{
					int?ID?=?Integer.parseInt（this.tF1.getText（）.trim（））;
					String?gread?=?this.tF2.getText（）.trim（）;
					String?name?=?this.tF3.getText（）.trim（）;
					String?sex?=?this.tF4.getText（）.trim（）;

					Connection?con?=?new?connection（）.getCon（）;
					Statement?sm?=?con.createStatement（）;
					ResultSet?rs?=?sm.executeQuery（“Select?xuehao?From?student“）;
					PreparedStatement?pstmt?=?con.prepareStatement（“INSERT?INTO?student（xuehaoclassnamesexAttendAbsentMar

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????352??2008-12-29?15:55??RandomRollCall\.classpath

?????文件????????390??2008-12-22?20:34??RandomRollCall\.project

?????文件???????4760??2011-07-07?14:40??RandomRollCall\com\dianming\lyh\Add.class

?????文件???????3781??2011-07-07?14:40??RandomRollCall\com\dianming\lyh\Add.java

?????文件????????993??2011-07-06?22:29??RandomRollCall\com\dianming\lyh\connection.class

?????文件????????517??2011-07-06?22:29??RandomRollCall\com\dianming\lyh\connection.java

?????文件???????3405??2011-07-07?01:11??RandomRollCall\com\dianming\lyh\Delete.class

?????文件???????2047??2011-07-07?01:11??RandomRollCall\com\dianming\lyh\Delete.java

?????文件???????1761??2011-07-07?21:30??RandomRollCall\com\dianming\lyh\Loada$1.class

?????文件????????703??2011-07-07?21:30??RandomRollCall\com\dianming\lyh\Loada$2.class

?????文件???????2250??2011-07-07?21:30??RandomRollCall\com\dianming\lyh\Loada.class

?????文件???????2190??2011-07-07?21:30??RandomRollCall\com\dianming\lyh\Loada.java

?????文件????????708??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage$1.class

?????文件????????711??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage$2.class

?????文件????????709??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage$3.class

?????文件????????711??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage$4.class

?????文件????????747??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage$5.class

?????文件???????1616??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage$6.class

?????文件???????2199??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage.class

?????文件???????2689??2011-07-07?21:28??RandomRollCall\com\dianming\lyh\Mainpage.java

?????文件???????3751??2011-07-07?21:29??RandomRollCall\com\dianming\lyh\Search.class

?????文件???????2185??2011-07-07?21:29??RandomRollCall\com\dianming\lyh\Search.java

?????文件???????4111??2011-07-07?21:43??RandomRollCall\com\dianming\lyh\Sign.class

?????文件???????2187??2011-07-07?21:43??RandomRollCall\com\dianming\lyh\Sign.java

?????文件?????626688??2011-07-08?09:17??RandomRollCall\com\dianming\lyh\Student.mdb

?????文件???????3447??2011-07-07?21:39??RandomRollCall\com\dianming\lyh\StuInfo.class

?????文件???????2115??2011-07-07?21:39??RandomRollCall\com\dianming\lyh\StuInfo.java

?????文件??????40890??2011-07-08?12:37??RandomRollCall\com.rar

?????文件???????2850??2008-12-29?15:55??RandomRollCall\lib\AbsoluteLayout.jar

?????文件?????118103??2008-12-29?15:55??RandomRollCall\lib\swing-layout-1.0.3.jar

............此處省略16個文件信息