package?business;

import?java.awt.BorderLayout;
import?java.awt.Dimension;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?javax.swing.Jframe;
import?javax.swing.JLabel;
import?javax.swing.JScrollPane;
import?javax.swing.JTable;

public?class?chakanxiaoxi?{

	String?driver?=?“com.mysql.jdbc.Driver“;
	String?url?=?“jdbc:mysql://localhost:3306/jdbc“;		
	String?username?=?“root“;
	String?password?=?“1“;	
	private?static?Statement?stmt?=?null;	
	int?rowcount?=?0;
	?Jframe?b?=?new?Jframe（）;
	?public?chakanxiaoxi（）
	?{
		?try?{
				Class.forName（driver）;	
					JLabel?title?=?new?JLabel（“消息記錄“JLabel.CENTER）;	
				?????Connection?con?=?DriverManager.getConnection（url?username?password）;
				?????String[]?head?=?{“消息記錄“};
				?????String?sql?=?“select*from?xiaoxijilu“;
				?????stmt?=?con.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_UPDATABLE）;
				?????ResultSet?rs?=?stmt.executeQuery（sql）;
				????			?	
				?	?rs.last（）;
				?????rowcount?=?rs.getRow（）;	
				?????object[][]?xinxi?=?new?object[rowcount][head.length];
				?	?b.add（titleBorderLayout.NORTH）;	?		?	
				?	//?JPanel?j?=?new?JPanel（）;
				?	?JScrollPane?jsp=new?JScrollPane（）;
					?b.settitle（“查看消息記錄“）;
					?b.setBounds（500?300?500?300）;
					?b.setVisible（true）;
					?b.setDefaultCloseOperation（Jframe.DISPOSE_ON_CLOSE）;	
					?try{
						?rs.first（）;
						?xinxi[0][0]=rs.getString（1）;
						
						?int?i?=1;
						?int?k?=?0;
						?while（rs.next（））
						?{
							?xinxi[i][k++]=rs.getString（1）;
						
							?i++;
							?k=0;
						?}
						?JTable?table?=?new?JTable（xinxihead）;
						?table.setPreferredScrollableViewportSize（new?Dimension（500330））;
						?
					?	?table.setVisible（true）;
					?	?jsp.getViewport（）.add（table）;
		
					?	b.add（jspBorderLayout.CENTER）;
					?}
					?	catch（Exception?e）
						?{
							?e.printStackTrace（）;
						?}
						
				}?catch?（ClassNotFoundException?e2）?{
					
					e2.printStackTrace（）;
				}?catch?（Exception?e1）?{
		
					e1.printStackTrace（）;
				}
	?}
	public?static?void?main（String[]?args）?{
		//?TODO?Auto-generated?method?stub
		new?chakanxiaoxi（）;
	}

}

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

?????文件????????436??2006-11-19?13:12??JYW\.classpath

?????文件????????379??2007-10-22?10:04??JYW\.project

?????文件????????629??2007-10-22?10:04??JYW\.settings\org.eclipse.jdt.core.prefs

?????文件???????3317??2006-11-23?10:07??JYW\bin\business\chakanxiaoxi.class

?????文件???????3041??2006-11-23?10:07??JYW\bin\business\Client$Reciver.class

?????文件???????4724??2006-11-23?10:07??JYW\bin\business\Client.class

?????文件???????4865??2006-11-23?10:07??JYW\bin\business\denglu.class

?????文件???????2748??2006-11-23?10:07??JYW\bin\business\Server$Client.class

?????文件???????2533??2006-11-23?10:07??JYW\bin\business\Server.class

?????文件???????4122??2006-11-23?10:07??JYW\bin\business\tianjia.class

?????文件????????421??2006-11-23?10:07??JYW\bin\util\Constant.class

?????文件???????2328??2006-11-20?08:42??JYW\src\business\chakanxiaoxi.java

?????文件???????4466??2006-11-20?09:00??JYW\src\business\Client.java

?????文件???????3589??2006-11-20?08:41??JYW\src\business\denglu.java

?????文件???????3043??2006-11-20?09:56??JYW\src\business\Server.java

?????文件???????2949??2006-11-20?09:10??JYW\src\business\tianjia.java

?????文件????????240??2007-11-12?11:31??JYW\src\util\Constant.java

?????目錄??????????0??2006-11-29?09:17??JYW\bin\business

?????目錄??????????0??2006-11-29?09:17??JYW\bin\util

?????目錄??????????0??2006-11-29?09:17??JYW\src\business

?????目錄??????????0??2006-11-29?09:17??JYW\src\util

?????目錄??????????0??2006-11-29?09:17??JYW\.settings

?????目錄??????????0??2006-11-29?09:17??JYW\bin

?????目錄??????????0??2006-11-29?09:17??JYW\src

?????目錄??????????0??2006-11-29?09:17??JYW

-----------?---------??----------?-----??----

????????????????43830????????????????????25