package?想打包;

import?java.awt.BorderLayout;
import?java.awt.frame;
import?java.awt.GridLayout;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?javax.swing.JButton;
import?javax.swing.JDialog;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JPanel;
import?javax.swing.JTextField;

public?class?StuAddDialog?extends?JDialog?implements?ActionListener{
	//定義我需要的swing組件
	JLabel?jl1jl2jl3jl4jl5jl6;
	JButton?jb1jb2;
	JTextField?jtf1jtf2jtf3jtf4jtf5jtf6;
	JPanel?jp1jp2jp3;
	
	//owner它的父窗口;title窗口名;model指定是模態(tài)窗口，還是非模態(tài)
	public?StuAddDialog（frame?ownerString?titleboolean?modal）
	{
		super（ownertitlemodal）;//調(diào)用父類構(gòu)造方法，達到模式對話框效果
		jl1=new?JLabel（“學(xué)號“）;
		jl2=new?JLabel（“名字“）;
		jl3=new?JLabel（“性別“）;
		jl4=new?JLabel（“年齡“）;
		jl5=new?JLabel（“籍貫“）;
		jl6=new?JLabel（“系別“）;
		
		jtf1=new?JTextField（）;
		jtf2=new?JTextField（）;
		jtf3=new?JTextField（）;
		jtf4=new?JTextField（）;
		jtf5=new?JTextField（）;
		jtf6=new?JTextField（）;
		
		jb1=new?JButton（“添加“）;
		jb2=new?JButton（“取消“）;
		
		jp1=new?JPanel（）;
		jp2=new?JPanel（）;
		jp3=new?JPanel（）;
		
		//設(shè)置布局
		jp1.setLayout（new?GridLayout（61））;
		jp2.setLayout（new?GridLayout（61））;
		
		//添加組件
		jp1.add（jl1）;
		jp1.add（jl2）;
		jp1.add（jl3）;
		jp1.add（jl4）;
		jp1.add（jl5）;
		jp1.add（jl6）;
		
		jp2.add（jtf1）;
		jp2.add（jtf2）;
		jp2.add（jtf3）;
		jp2.add（jtf4）;
		jp2.add（jtf5）;
		jp2.add（jtf6）;
		
		jp3.add（jb1）;
		jp3.add（jb2）;
		
		this.add（jp1BorderLayout.WEST）;
		this.add（jp2BorderLayout.CENTER）;
		this.add（jp3BorderLayout.SOUTH）;
		
		//注冊監(jiān)聽
		jb1.addActionListener（this）;
		jb2.addActionListener（this）;
		
		//展現(xiàn)
		this.setSize（300?250）;
		this.setLocation（500200）;
		this.setVisible（true）;
	}

	@Override
	public?void?actionPerformed（ActionEvent?e）?{
		//用戶點擊添加按鈕后的響應(yīng)動作
		if（e.getSource（）==jb1）{
			//連接數(shù)據(jù)庫
			Connection?ct=null;
			Statement?stmt=null;
			ResultSet?rs=null;
			PreparedStatement?ps=null;
			//連接數(shù)據(jù)庫
			try?{
				//1、加載驅(qū)動
				//Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
				//2、得到連接
				//ct=DriverManager.getConnection（“jdbc:sqlserver://192.168.232.185:1433;DatabaseName=vvv““sa““zxr1997813“）;
				
				Class.forName（“com.mysql.jdbc.Driver“）;?????//加載MYSQL?JDBC驅(qū)動程序??
				//2、得到連接
				ct?=?DriverManager.getConnection（
				??????????“jdbc:mysql://rm-bp1603n299o7q2u71lo.mysql.rds.aliyuncs.com:3306/vvv?useSSL=false““root““@zxr1997813“）;
				
				String?strsql=“insert?into?stu?values（??????）“;
				ps=ct.prepareStatement（strsql）;
				ps.setString（1jtf1.getText（））;
				ps.setString（2jtf2.getText（））;
				ps.setString（3jtf3.getText（））;
				ps.setInt（4Integer.parseInt（jtf4.getText（）））;
				ps.setString（5jtf5.getText（））;

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

?????文件????????318??2019-04-01?20:40??zzz\.classpath

?????文件????????385??2019-03-31?14:40??zzz\.project

?????文件????????761??2016-09-24?20:34??zzz\com\mysql\fabric\FabricCommunicationException.class

?????文件???????4762??2016-09-24?20:34??zzz\com\mysql\fabric\FabricConnection.class

?????文件???????1434??2016-09-24?20:34??zzz\com\mysql\fabric\FabricStateResponse.class

?????文件???????1188??2016-09-24?20:34??zzz\com\mysql\fabric\HashShardMapping$ReverseShardIndexSorter.class

?????文件???????2798??2016-09-24?20:34??zzz\com\mysql\fabric\HashShardMapping.class

?????文件???????4797??2016-09-24?20:34??zzz\com\mysql\fabric\hibernate\FabricMultiTenantConnectionProvider.class

?????文件???????2443??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\ErrorReportingExceptionInterceptor.class

?????文件????????748??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\FabricMySQLConnection.class

?????文件????????678??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\FabricMySQLConnectionProperties.class

?????文件??????77335??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\FabricMySQLConnectionProxy.class

?????文件???????4447??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\FabricMySQLDataSource.class

?????文件???????3396??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\FabricMySQLDriver.class

?????文件????????763??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\JDBC4FabricMySQLConnection.class

?????文件???????3070??2016-09-24?20:34??zzz\com\mysql\fabric\jdbc\JDBC4FabricMySQLConnectionProxy.class

?????文件???????2290??2016-09-24?20:34??zzz\com\mysql\fabric\proto\xmlrpc\AuthenticatedxmlRpcMethodCaller.class

?????文件???????7155??2016-09-24?20:34??zzz\com\mysql\fabric\proto\xmlrpc\DigestAuthentication.class

?????文件???????5331??2016-09-24?20:34??zzz\com\mysql\fabric\proto\xmlrpc\InternalxmlRpcMethodCaller.class

?????文件???????2418??2016-09-24?20:34??zzz\com\mysql\fabric\proto\xmlrpc\ResultSetParser.class

?????文件??????15334??2016-09-24?20:34??zzz\com\mysql\fabric\proto\xmlrpc\xmlRpcClient.class

?????文件????????483??2016-09-24?20:34??zzz\com\mysql\fabric\proto\xmlrpc\xmlRpcMethodCaller.class

?????文件???????1364??2016-09-24?20:34??zzz\com\mysql\fabric\RangeShardMapping$RangeShardIndexSorter.class

?????文件???????2097??2016-09-24?20:34??zzz\com\mysql\fabric\RangeShardMapping.class

?????文件???????2274??2016-09-24?20:34??zzz\com\mysql\fabric\Response.class

?????文件???????3400??2016-09-24?20:34??zzz\com\mysql\fabric\Server.class

?????文件???????1968??2016-09-24?20:34??zzz\com\mysql\fabric\ServerGroup.class

?????文件???????1323??2016-09-24?20:34??zzz\com\mysql\fabric\ServerMode.class

?????文件???????1368??2016-09-24?20:34??zzz\com\mysql\fabric\ServerRole.class

?????文件????????807??2016-09-24?20:34??zzz\com\mysql\fabric\ShardIndex.class

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