package?Database;


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?java.util.ArrayList;
import?java.util.List;

import?javax.swing.JOptionPane;

import?Sniffer.mainframe;

public?class?databaseManage?{

	List?list=new?ArrayList（）;
	public?object[][]?data;
	
	public?mainframe?parent;
	public?Connection?con;
	int?j=0;
	public?databaseManage（mainframe?parent）
	{
		
		this.parent=parent;
	
	}
	
	public?object?[][]?getData（）
	{
		object[][]?temp?=?null;
		int?row=0;
		int?index=0;
		if（null==con）
		{con=getCon（）;System.out.print（“null“）;}
		String?sql?=?“select?*?from?packet“;
		?try?{
		????	
	????	
	????		
	????		?Statement?stmt=con.createStatement（）;?
	????		?ResultSet?rs?=?stmt.executeQuery（sql）;??
	????	
	????	
	????	
	????
	????	
	????	?temp?=new?object[100][7];
	????	?while（rs.next（））
	????	?{
	????	
	????			?for（int?i=1;i<=7;i++）
	????			?{
	????				?temp[index][i-1]=new?object（）;
	????				?temp[index][i-1]=rs.getString（i）.toString（）;
	????		
	????			?}
	????	????	index++;
	????	????		
	????	?}
	????	?
			JOptionPane.showMessageDialog（null?“Open?file?successfully.?“?“Sniffer?2016“JOptionPane.INFORMATION_MESSAGE）;
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			JOptionPane.showMessageDialog（null?“Fail?to?file?file.?“?“Sniffer?2016“JOptionPane.INFORMATION_MESSAGE）;?
		}
		return?temp;
	}
	public?void?insert（）
	{
		data=parent.databaseFile;
		String?sql?=?“insert?into?packet?（No?Time?ProtocolDestinationScourceLengthInfo）?values?（???????）“;
		PreparedStatement?ps;
		if（null==con）
			{con=getCon（）;System.out.print（“null“）;}
		????try?{
		????	
		????	?for?（int?i=0;i		????	?{
		????		
		????		?ps?=con.prepareStatement（sql）;
		????		?ps.setString（1?data[i][0].toString（））;
		????		?ps.setString（2?data[i][1].toString（））;
		????		?ps.setString（3?data[i][2].toString（））;
		????		?ps.setString（4?data[i][3].toString（））;
		????		?ps.setString（5?data[i][4].toString（））;
		????		?ps.setString（6?data[i][5].toString（））;
		????		?ps.setString（7?data[i][6].toString（））;
		????		?ps.executeUpdate（）;
		????	?}
				JOptionPane.showMessageDialog（null?“Saved?successfully.?“?“Sniffer?2016“JOptionPane.INFORMATION_MESSAGE）;
				
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				JOptionPane.showMessageDialog（null?“Fail?to?save?file.?“?“Sniffer?2016“JOptionPane.INFORMATION_MESSAGE）;?
			}
		
		
		
		
	}
	public?Connection?getCon（）
	{
		?Connection?con?=?null;
		?String?driver?=?“com.mysql.jdbc.Driver“;
	?????//URL指向要訪問的數據庫名mydata
	?????String?url?=?“jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false“;
	?????//MySQL配置時的用戶名
	?????String?user?=?“root“;
	?????//MySQL配置時的密碼
	?????String

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-10-13?18:23??sniffer\
?????文件?????????535??2016-10-10?12:55??sniffer\.classpath
?????文件?????????383??2016-10-10?12:29??sniffer\.project
?????目錄???????????0??2016-10-10?12:29??sniffer\.settings\
?????文件?????????598??2016-10-10?12:29??sniffer\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2016-10-14?02:07??sniffer\bin\
?????目錄???????????0??2016-10-14?02:09??sniffer\bin\Database\
?????文件????????4467??2016-10-14?03:29??sniffer\bin\Database\databaseManage.class
?????文件????????2886??2016-10-14?02:07??sniffer\bin\Database\test.class
?????文件?????????915??2016-10-14?02:07??sniffer\bin\Database\test2.class
?????目錄???????????0??2016-10-14?02:07??sniffer\bin\Sniffer\
?????文件?????????711??2016-10-14?02:07??sniffer\bin\Sniffer\DispalyNetPacket$1.class
?????文件????????1791??2016-10-14?02:07??sniffer\bin\Sniffer\DispalyNetPacket.class
?????文件????????2237??2016-10-14?02:07??sniffer\bin\Sniffer\MyTableModel.class
?????文件????????5345??2016-10-14?02:07??sniffer\bin\Sniffer\ScreenShot$CameraJPanel.class
?????文件????????1018??2016-10-14?02:07??sniffer\bin\Sniffer\ScreenShot.class
?????文件????????3014??2016-10-14?02:07??sniffer\bin\Sniffer\TestPacketReceiver.class
?????文件?????????946??2016-10-14?02:07??sniffer\bin\Sniffer\colorTableRender.class
?????文件????????2838??2016-10-14?02:07??sniffer\bin\Sniffer\downJPanel.class
?????文件????????2947??2016-10-14?02:07??sniffer\bin\Sniffer\goToPacket.class
?????文件????????4561??2016-10-14?02:07??sniffer\bin\Sniffer\infoframe$1.class
?????文件????????6417??2016-10-14?02:07??sniffer\bin\Sniffer\infoframe.class
?????文件????????6413??2016-10-14?02:07??sniffer\bin\Sniffer\interfaceframe.class
?????文件???????16443??2016-10-14?03:28??sniffer\bin\Sniffer\mainframe.class
?????文件????????2313??2016-10-14?02:07??sniffer\bin\Sniffer\myPacketAdd.class
?????文件????????6294??2016-10-14?02:07??sniffer\bin\Sniffer\optionframe.class
?????文件????????2073??2016-10-14?02:07??sniffer\bin\Sniffer\packetDetailData.class
?????文件????????4237??2016-10-14?02:07??sniffer\bin\Sniffer\packetDetailTree.class
?????文件????????4385??2016-10-14?02:07??sniffer\bin\Sniffer\packetTree.class
?????文件????????3484??2016-10-14?02:32??sniffer\bin\Sniffer\packetsTable$JDTableModel.class
?????文件?????????655??2016-10-14?02:32??sniffer\bin\Sniffer\packetsTable$TableView.class
............此處省略123個文件信息