import?java.awt.*;
import?javax.swing.*;
import?java.sql.*;
import?java.awt.event.*;

public?class?AddC?extends?JPanel?implements?ActionListener{
	JTextField?庫存蔬菜名稱;
	JButton?錄入;
	
public?AddC（）{
	try?{UIManager.setLookAndFeel（UIManager.getSystemLookAndFeelClassName（））;}
	catch（Exception?e）{System.err.println（“不能設置外觀:???“+e）;}
	
	庫存=new?JTextField（12）;
	蔬菜名稱=new?JTextField（12）;
	錄入=new?JButton（“錄入“）;
	錄入.addActionListener（this）;
	
	Box?box1=Box.createHorizontalBox（）;
	Box?box2=Box.createHorizontalBox（）;
	Box?box3=Box.createHorizontalBox（）;
	Box?box4=Box.createHorizontalBox（）;
	box1.add（new?JLabel（“庫存:“））;
	box1.add（庫存）;
	box2.add（new?JLabel（“蔬菜名稱:“））;
	box2.add（蔬菜名稱）;
	box4.add（錄入）;
	Box?boxH=Box.createVerticalBox（）;
	boxH.add（box1）;
	boxH.add（box2）;
	boxH.add（box3）;
	boxH.add（box4）;
	boxH.add（Box.createVerticalGlue（））;
	JPanel?messPanel=new?JPanel（）;
	messPanel.add（boxH）;
	setLayout（new?BorderLayout（））;
	add（messPanelBorderLayout.CENTER）;
	validate（）;
}

public?void?actionPerformed（ActionEvent?c）{
	object?obj=c.getSource（）;
	if（obj==錄入）{
		if（庫存.getText（）.equals（““）||蔬菜名稱.getText（）.equals（““））{
			JOptionPane.showMessageDialog（this“倉庫信息請填滿再錄入！“?）;
		}
		Statement?stmt=null;
		ResultSet?rs=nullrs1=null;
		String?sqlsql1;
		????sql1=“select?*?from?C?where?Cweight=‘“+庫存.getText（）+“‘“;
		????sql=“insert?into?C?values（‘“+庫存.getText（）+“‘‘“+蔬菜名稱.getText（）+“‘）“;
	???try{
		???Connection?dbConn1=CONN（）;
			stmt=（Statement）dbConn1.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			rs1=stmt.executeQuery（sql1）;
			if（rs1.next（））{JOptionPane.showMessageDialog（this“該蔬菜以存在，無法添加“）;}
			else{
			stmt.executeUpdate（sql）;	
			JOptionPane.showMessageDialog（this“添加成功“）;
			}		
			rs1.close（）;
			
			stmt.close（）;
	???}
	???catch（SQLException?e）{
		???System.out.print（“SQL?Exception?occur.Message?is:“+e.getMessage（））;
		???}
	}
}

public?static?Connection?CONN（）{
	???String?driverName?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;???
	???String?dbURL?=?“jdbc:sqlserver://localhost:1433;?DatabaseName=蔬菜收購系統“;???
	???String?userName?=?“林楚羽1“;??
	???String?userPwd?=?“123456“;??
	???Connection?dbConn=null;
	???try?{
	???Class.forName（driverName）;
	???dbConn?=?DriverManager.getConnection（dbURL?userName?userPwd）;
	???System.out.println（“數據庫連接成功!“）;?
	???}?catch?（Exception?e）?{
	???e.printStackTrace（）;
	???}
	???return?dbConn;
}
}

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

?????文件????????301??2017-08-19?14:42??VGS\.classpath

?????文件????????379??2017-08-19?14:42??VGS\.project

?????文件????????598??2017-08-19?14:42??VGS\.settings\org.eclipse.jdt.core.prefs

?????文件???????4520??2017-08-26?16:00??VGS\bin\AddC.class

?????文件???????4628??2017-08-26?16:00??VGS\bin\Addstu.class

?????文件???????5346??2017-08-26?16:00??VGS\bin\DelC.class

?????文件???????5569??2017-08-26?16:00??VGS\bin\Delstu.class

?????文件????????581??2017-08-25?23:13??VGS\bin\Menu$1.class

?????文件???????5711??2017-08-25?23:13??VGS\bin\Menu.class

?????文件???????3067??2017-08-26?16:00??VGS\bin\SelC.class

?????文件???????4840??2017-08-26?16:00??VGS\bin\Selstu.class

?????文件???????3077??2017-08-26?16:00??VGS\bin\Students.class

?????文件???????6226??2017-08-26?16:00??VGS\bin\Updatastu.class

?????文件???????5863??2017-08-26?16:18??VGS\bin\UpdateC.class

?????文件???????2510??2017-08-26?16:00??VGS\bin\User$BHandler.class

?????文件????????681??2017-08-26?16:00??VGS\bin\User$EXIT.class

?????文件???????3298??2017-08-26?16:00??VGS\bin\User.class

?????文件???????2570??2017-10-10?02:45??VGS\src\AddC.java

?????文件???????2724??2017-10-10?02:46??VGS\src\Addstu.java

?????文件???????3614??2017-10-10?02:46??VGS\src\DelC.java

?????文件???????3806??2017-10-10?02:47??VGS\src\Delstu.java

?????文件???????3566??2017-10-10?02:48??VGS\src\Menu.java

?????文件???????1636??2017-10-10?02:48??VGS\src\SelC.java

?????文件???????3880??2017-10-10?02:49??VGS\src\Selstu.java

?????文件???????1721??2017-10-10?02:49??VGS\src\Students.java

?????文件???????5003??2017-10-10?02:52??VGS\src\Updatastu.java

?????文件???????4564??2017-10-10?02:53??VGS\src\UpdateC.java

?????文件???????2916??2017-10-10?02:53??VGS\src\User.java

?????目錄??????????0??2017-08-26?16:48??VGS\.settings

?????目錄??????????0??2017-08-26?16:48??VGS\bin

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