資源簡介
設計一個報刊訂閱應用系統,使系統滿足以下功能和需求:
1)
a一個訂戶可訂多種報刊;一種報刊可被多個用戶訂閱;訂單只能訂閱現有報刊目錄內容;
b投遞時,必須根據訂單的情況進行投遞,不得超出訂單的訂閱品種、數量;
2)、系統功能包括:
a訂戶管理:訂戶添加、修改、刪除、查詢;
b?目錄管理:目錄添加、修改、刪除、查詢;
c訂單管理:完成訂戶訂閱數據的管理(包括添加、修改、刪除、查詢);
d統計查詢:按報刊目錄統計各類報刊的訂閱數量及金額;
e帳號管理:增加管理帳號、刪除帳號。

代碼片段和文件信息
//增加管理員模塊
import?java.awt.BorderLayout;
import?javax.swing.JPanel;
import?javax.swing.Jframe;
//import?java.awt.Dimension;
import?javax.swing.JLabel;
import?java.awt.Rectangle;
import?java.sql.ResultSet;
import?javax.swing.JOptionPane;
import?javax.swing.JTextField;
import?javax.swing.JPasswordField;
import?javax.swing.JButton;
import?javax.swing.SwingConstants;
import?java.awt.Dimension;
public?class?addadmin?extends?Jframe?{
private?static?final?long?serialVersionUID?=?1L;
private?JPanel?jContentPane?=?null;
private?JLabel?jLabel?=?null;
private?JLabel?jLabel1?=?null;
private?JLabel?jLabel2?=?null;
private?JTextField?jTextField?=?null;
private?JPasswordField?jPasswordField?=?null;
private?JPasswordField?jPasswordField1?=?null;
private?JButton?jButton?=?null;
private?JButton?jButton1?=?null;
/**
?*?This?is?the?default?constructor
?*/
public?addadmin()?{
super();
initialize();
setVisible(true);
setLocation(300200);
setResizable(false);
}
/**
?*?This?method?initializes?this
?*
?*?@return?void
?*/
private?void?initialize()?{
this.setSize(270?201);
this.setContentPane(getJContentPane());
this.settitle(“創建管理帳號“);
}
/**
?*?This?method?initializes?jContentPane
?*
?*?@return?javax.swing.JPanel
?*/
private?JPanel?getJContentPane()?{
if?(jContentPane?==?null)?{
jLabel2?=?new?JLabel();
jLabel2.setBounds(new?Rectangle(16?90?93?28));
jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
jLabel2.setText(“確認密碼“);
jLabel1?=?new?JLabel();
jLabel1.setBounds(new?Rectangle(16?52?93?28));
jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
jLabel1.setText(“管理密碼“);
jLabel?=?new?JLabel();
jLabel.setBounds(new?Rectangle(16?13?93?28));
jLabel.setHorizontalAlignment(SwingConstants.CENTER);
jLabel.setText(“新管理帳號“);
jContentPane?=?new?JPanel();
jContentPane.setLayout(null);
jContentPane.add(jLabel?null);
jContentPane.add(jLabel1?null);
jContentPane.add(jLabel2?null);
jContentPane.add(getJTextField()?null);
jContentPane.add(getJPasswordField()?null);
jContentPane.add(getJPasswordField1()?null);
jContentPane.add(getJButton()?null);
jContentPane.add(getJButton1()?null);
}
return?jContentPane;
}
/**
?*?This?method?initializes?jTextField
?*
?*?@return?javax.swing.JTextField
?*/
private?JTextField?getJTextField()?{
if?(jTextField?==?null)?{
jTextField?=?new?JTextField();
jTextField.setBounds(new?Rectangle(124?13?119?28));
jTextField.addFocusListener(new?java.awt.event.FocusAdapter()?{
public?void?focusLost(java.awt.event.FocusEvent?e)?{
try{
Database?DB=new?Database();
DB.OpenConn();
??????????? String?sql=“select?*?from?Login?where?UName=‘“+jTextField.getText()+“‘“;//執行的sql語句在數據庫里查找我們輸的用戶名
???????????? ResultSet?rs=DB.executeQuery(sql);
???????????? if(rs.next()){
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????76555??2018-12-05?13:07??BKDY0zsc.jar
?????文件?????1507328??2008-12-23?19:39??BKDY_Data.MDF
?????文件?????1048576??2008-12-23?19:39??BKDY_Log.LDF
?????文件???????76551??2018-12-05?13:07??BKDYzsc.jar
?????目錄???????????0??2010-06-10?10:37??java\
?????文件????????6640??2009-02-19?13:05??java\addadmin.java
?????文件???????97488??2018-12-05?13:07??java\BKDY0.jar
?????文件?????????661??2010-06-04?23:27??java\Connectdataba
?????文件???????34901??2009-02-19?13:06??java\DDxinxi.java
?????文件????????4315??2009-02-19?13:06??java\deleteadmin.java
?????文件???????22896??2009-02-19?13:08??java\DHTable.java
?????文件????????5376??2009-02-19?13:08??java\LG.java
?????文件????????7088??2010-06-04?22:33??java\myfr
?????文件????????3915??2009-02-19?13:09??java\orderdetail.java
?????文件???????24432??2009-02-19?13:09??java\SimpleTable.java
?????文件?????1114112??2018-12-05?13:07??報刊訂閱.doc
?????文件??????749056??2018-12-05?13:07??數據庫課程設計-報刊訂閱系統.doc
- 上一篇:DSPC6000 CCS矩陣求逆
- 下一篇:攝影網站-網頁大作業
評論
共有 條評論