資源簡介
用Java編寫的圖形用戶界面通訊錄package myaddressbody;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
public class Demonstr

代碼片段和文件信息
package?myaddressbody;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.Date;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?javax.swing.JButton;
public?class?Demonstrationacction?implements?ActionListener?{
public?void?actionPerformed(ActionEvent?e)?{
if?(((JButton)?e.getSource()).getText().equals(“顯示查詢結果“))?{
String?dburl?=?“jdbc:odbc:driver={Microsoft?Access?Driver?(*.mdb)};DBQ=main.mdb“;
String?sql;
Connection?con;
Statement?stmt;
String?nm?sx?mp?ph?em?ca?ha?nb?gp?lbMQ?all;
boolean?bdr;
Date?bd;
try?{
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“);
}?catch?(java.lang.ClassNotFoundException?e2)?{
System.err.print(“ClassNotFoundException:“);
System.err.println(e2.getMessage());
}
try?{
con?=?DriverManager.getConnection(dburl?““?““);
stmt?=?con.createStatement();
sql?=?“SELECT*FROM?address“;
ResultSet?ws?=?stmt.executeQuery(sql);
while?(ws.next())?{
nm?=?ws.getString(1);
sx?=?ws.getString(2);
bd?=?ws.getDate(3);
mp?=?ws.getString(4);
ph?=?ws.getString(5);
ca?=?ws.getString(6);
em?=?ws.getString(7);
ha?=?ws.getString(8);
gp?=?ws.getString(9);
nb?=?ws.getString(10);
lbMQ?=?ws.getString(11);
all?=?“姓名:“?+?nm?+?“????性別:“?+?sx?+?“????生日:“?+?bd
+?“???移動電話:“?+?mp?+?“???固定電話:“?+?ph?+?“?MSN/QQ:“
+?lbMQ?+?“???公司地址:“?+?ca?+?“???EMail:“?+?em
+?“???家庭地址:“?+?ha?+?“??組別“?+?gp?+?“??備注:“?+?nb
+?“\n“;
Demonstrationaframe.lbdem.append(all);
}
stmt.close();
con.close();
}?catch?(Exception?ex)
{
System.out.println(“Exception:“?+?ex.getMessage());
}
}
if?(((JButton)?e.getSource()).getText().equals(“退出全部查詢“))?{
Demonstrationaframe.lbdem.setText(““);
Demonstrationaframe.demframe.setVisible(false);
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????226??2007-12-29?08:17??個人通訊錄管理系統\.classpath
?????文件????????593??2008-01-04?13:07??個人通訊錄管理系統\.project
?????文件???????1751??2008-01-06?12:22??個人通訊錄管理系統\Checkst
?????文件?????561152??2008-01-10?16:45??個人通訊錄管理系統\main.mdb
?????文件???????6542??2008-01-05?19:45??個人通訊錄管理系統\SQL錯誤代碼.txt
?????文件???????3404??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Demonstrationacction.class
?????文件???????2043??2008-01-08?19:30??個人通訊錄管理系統\myaddressbody\Demonstrationacction.java
?????文件???????1784??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Demonstrationafr
?????文件???????1101??2008-01-07?21:05??個人通訊錄管理系統\myaddressbody\Demonstrationafr
?????文件???????1570??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Dlfr
?????文件???????1012??2008-01-07?13:59??個人通訊錄管理系統\myaddressbody\Dlfr
?????文件???????2565??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Dlfr
?????文件???????1379??2008-01-08?20:21??個人通訊錄管理系統\myaddressbody\Dlfr
?????文件???????1643??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Fdfr
?????文件???????1063??2008-01-08?21:11??個人通訊錄管理系統\myaddressbody\Fdfr
?????文件???????4205??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Fdfr
?????文件???????2926??2008-01-08?21:13??個人通訊錄管理系統\myaddressbody\Fdfr
?????文件???????1645??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Fdkeep.class
?????文件???????1080??2008-01-07?13:59??個人通訊錄管理系統\myaddressbody\Fdkeep.java
?????文件???????3749??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Fdkeepacction.class
?????文件???????2459??2008-01-08?19:09??個人通訊錄管理系統\myaddressbody\Fdkeepacction.java
?????文件???????1668??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\fr
?????文件???????1129??2008-01-08?19:37??個人通訊錄管理系統\myaddressbody\fr
?????文件????????812??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Image.class
?????文件????????474??2008-01-08?21:27??個人通訊錄管理系統\myaddressbody\Image.java
?????文件???????2037??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Loginfr
?????文件???????1418??2008-01-07?21:06??個人通訊錄管理系統\myaddressbody\Loginfr
?????文件???????3270??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\LoginIn.class
?????文件???????2067??2008-01-06?13:02??個人通訊錄管理系統\myaddressbody\LoginIn.java
?????文件????????646??2008-01-09?08:54??個人通訊錄管理系統\myaddressbody\Myaddress$1.class
............此處省略22個文件信息
評論
共有 條評論