資源簡介
倉庫管理系統,用JAVA做的,使用的數據庫軟件是MYSQL 課程設計內容一共有管理表格四張,包含曾刪改功能;查詢表格六張,包含精確查找和模糊查找。含有登陸功能,先登陸后出現主界面,登陸有三個權限。壓縮包里包含JAVA源文件和數據庫,導入就可使用。

代碼片段和文件信息
import?java.util.*;
import?java.sql.*;
import?javax.swing.*;
import?java.awt.*;
import?java.awt.event.*;
public?class?LoginBean?{
String?sql;
ResultSet?rs?=?null;
String[]?s?=?new?String[2];
String?user;
String?password;
public?String?Flag;
boolean?success=false;
public?boolean?enter(String?nameString?password)
{
this.user=name;
this.password=password;
Database?DB?=?new?Database();
sql=“select?*?from?admin?“;
try{
DB.OpenConn();
rs?=?DB.executeQuery(sql);
boolean?find=false;
????????while(!find?&&?rs.next())
????????{????s[0]?=?rs.getString(1);
?????s[1]?=?rs.getString(2);
?????
?????rs.beforeFirst();
?????while?(!find?&&?rs.next())???????????????????????//未找到時迭代遍歷結果集
????????????if?(rs.getString(1).equals(user))????????????//用戶名相同
????????????{
????????????????if?(rs.getString(2).equals(password))????//密碼相同
????????????????????{
???????????????? success=true;
???????????????? this.Flag=rs.getString(3);???????????//獲得用戶權限 ????????????????
???????????????? JOptionPane.showMessageDialog(nulluser+“登錄成功!“user+“登錄成功“1);
????????????????????}
????????????????else???????????????????????????????????????//密碼不同
????????????????????JOptionPane.showMessageDialog(nulluser+“密碼錯誤,請重新輸入“?user+“密碼錯誤“0);
????????????????find=true;
????????????}
????????if?(!find)?
????????{?
???????? JOptionPane.showMessageDialog(null?“沒有“+user+“用戶,請重新輸入用戶名““沒有“+user+“用戶“0);
????????}
???????}
?????}??
catch(Exception?e){
}
finally?{
DB.closeStmt();
DB.closeConn();
}
return?success;
?????}
????public?static?void?main(String?[]args)
????{
???? new?LoginBean();
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????8564??2010-12-20?12:44??storemanager\branch.frm
?????文件?????????61??2010-12-17?17:25??storemanager\db.opt
?????文件???????8638??2010-12-31?10:57??storemanager\login.frm
?????文件???????8594??2010-12-22?20:57??storemanager\manager.frm
?????文件???????8808??2010-12-31?11:03??storemanager\sbcg.frm
?????文件???????8718??2011-01-02?20:38??storemanager\sbck.frm
?????文件???????8686??2010-12-26?17:45??storemanager\sbgh.frm
?????文件???????8684??2010-12-26?17:45??storemanager\sbrk.frm
?????文件???????8650??2010-12-26?17:45??storemanager\sbxq.frm
?????文件???????8686??2010-12-26?19:37??storemanager\xyck.frm
?????文件????????565??2010-12-28?22:13??倉庫管理系統\.classpath
?????文件????????394??2010-12-28?22:13??倉庫管理系統\.project
?????文件???????1827??2010-12-28?22:13??倉庫管理系統\LoginBean.java
?????文件?????703265??2010-12-28?22:14??倉庫管理系統\mysql-connector-java-5.1.6-bin.jar
?????文件????????629??2010-12-28?22:14??倉庫管理系統\.settings\org.eclipse.jdt.core.prefs
?????文件????????897??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Admin.class
?????文件???????1254??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Dqck.class
?????文件????????902??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Max_min.class
?????文件???????1947??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Sbcg.class
?????文件???????1319??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Sbck.class
?????文件???????1319??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Sbgh.class
?????文件???????1319??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Sbxq.class
?????文件???????2598??2011-01-05?22:39??倉庫管理系統\bin\com\dto\ti
?????文件???????1072??2011-01-05?22:39??倉庫管理系統\bin\com\dto\Xyck.class
?????文件???????2820??2011-01-05?22:39??倉庫管理系統\bin\com\fr
?????文件????????730??2011-01-05?22:39??倉庫管理系統\bin\com\fr
?????文件???????6132??2011-01-05?22:39??倉庫管理系統\bin\com\fr
?????文件????????269??2011-01-05?22:39??倉庫管理系統\bin\com\fr
?????文件???????4752??2011-01-05?22:56??倉庫管理系統\bin\com\fr
?????文件????????712??2011-01-05?22:39??倉庫管理系統\bin\com\fr
............此處省略86個文件信息
評論
共有 條評論