資源簡介
功能:系統(tǒng)分管理員界面與用戶界面
管理員:實現(xiàn)對圖書的增、刪、改、查,對所有借閱歷史的搜索及所有賬戶的信息,用戶的權(quán)限與管理,設(shè)定密碼,借閱圖書及對自己賬戶的資料修改
用戶:實現(xiàn)對圖書的借閱功能、查看自己的借閱歷史,在用戶賬戶方面實現(xiàn)修改密碼以及修改個人信息功能
另外:當數(shù)據(jù)庫中用戶表為空,則第一個注冊的用戶默認為管理員
https://blog.csdn.net/kongsanjin/article/details/97611293
管理員:實現(xiàn)對圖書的增、刪、改、查,對所有借閱歷史的搜索及所有賬戶的信息,用戶的權(quán)限與管理,設(shè)定密碼,借閱圖書及對自己賬戶的資料修改
用戶:實現(xiàn)對圖書的借閱功能、查看自己的借閱歷史,在用戶賬戶方面實現(xiàn)修改密碼以及修改個人信息功能
另外:當數(shù)據(jù)庫中用戶表為空,則第一個注冊的用戶默認為管理員
https://blog.csdn.net/kongsanjin/article/details/97611293
代碼片段和文件信息
package?database;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?javax.swing.JOptionPane;
public?class?Adduser?{
public?static?Boolean?adduser(String?user?String?studentid?String?name?String?password)?{
Connection?con?=?ConnectDatabase.connectDB();
PreparedStatement?preSql;
String?sqlStr=null;
if(userlist())?{
sqlStr?=?“insert?into?usertable?values?(????0)“;
}else?{
sqlStr?=?“insert?into?usertable?values?(????1)“;
}
try?{
preSql?=?con.prepareStatement(sqlStr);
preSql.setString(1?user);
preSql.setString(2?studentid);
preSql.setString(3?name);
preSql.setString(4?password);
int?ok?=?preSql.executeUpdate();
con.close();
return?true;
}?catch?(SQLException?e)?{
JOptionPane.showMessageDialog(null?“用戶名已存在“?“警告“?JOptionPane.WARNING_MESSAGE);
return?false;
}
}
//判斷用戶是否存在
public?static?boolean?userlist()?{
Connection?con?=?ConnectDatabase.connectDB();
PreparedStatement?preSql;
ResultSet?rs;
String?sqlStr?=?“select?*?from?usertable“;
try?{
preSql?=?con.prepareStatement(sqlStr);
rs?=?preSql.executeQuery();
boolean?flag?=?false;
while(rs.next())?{
flag?=?true;
return?true;
}
if(!flag)?{
return?false;
}
con.close();
return?false;
}?catch?(SQLException?e)?{
return?false;
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-12-31?10:35??Java_Library_Management_System\
?????文件?????????470??2019-12-31?08:54??Java_Library_Management_System\.classpath
?????目錄???????????0??2019-12-31?10:49??Java_Library_Management_System\.git\
?????文件???????????7??2019-12-31?10:48??Java_Library_Management_System\.git\COMMIT_EDITMSG
?????文件??????????23??2019-12-31?10:34??Java_Library_Management_System\.git\HEAD
?????文件?????????324??2019-12-31?10:49??Java_Library_Management_System\.git\config
?????文件??????????73??2019-12-31?10:34??Java_Library_Management_System\.git\desc
?????目錄???????????0??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\
?????文件?????????478??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\applypatch-msg.sample
?????文件?????????896??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\commit-msg.sample
?????文件????????3327??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\fsmonitor-watchman.sample
?????文件?????????189??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\post-update.sample
?????文件?????????424??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\pre-applypatch.sample
?????文件????????1638??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\pre-commit.sample
?????文件????????1348??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\pre-push.sample
?????文件????????4898??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\pre-reba
?????文件?????????544??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\pre-receive.sample
?????文件????????1492??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\prepare-commit-msg.sample
?????文件????????3610??2019-12-31?10:34??Java_Library_Management_System\.git\hooks\update.sample
?????文件????????4766??2019-12-31?10:48??Java_Library_Management_System\.git\index
?????目錄???????????0??2019-12-31?10:34??Java_Library_Management_System\.git\info\
?????文件?????????240??2019-12-31?10:34??Java_Library_Management_System\.git\info\exclude
?????目錄???????????0??2019-12-31?10:34??Java_Library_Management_System\.git\logs\
?????文件????????1593??2019-12-31?10:48??Java_Library_Management_System\.git\logs\HEAD
?????目錄???????????0??2019-12-31?10:34??Java_Library_Management_System\.git\logs\refs\
?????目錄???????????0??2019-12-31?10:34??Java_Library_Management_System\.git\logs\refs\heads\
?????文件????????1593??2019-12-31?10:48??Java_Library_Management_System\.git\logs\refs\heads\master
?????目錄???????????0??2019-12-31?10:34??Java_Library_Management_System\.git\logs\refs\remotes\
?????目錄???????????0??2019-12-31?10:49??Java_Library_Management_System\.git\logs\refs\remotes\origin\
?????文件?????????205??2019-12-31?10:34??Java_Library_Management_System\.git\logs\refs\remotes\origin\HEAD
?????文件?????????146??2019-12-31?10:49??Java_Library_Management_System\.git\logs\refs\remotes\origin\master
............此處省略285個文件信息
評論
共有 條評論