91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 12.77MB
    文件類型: .zip
    金幣: 1
    下載: 0 次
    發(fā)布日期: 2023-07-15
  • 語言: Java
  • 標簽: java??mysql??

資源簡介

功能:系統(tǒng)分管理員界面與用戶界面
管理員:實現(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\description
?????目錄???????????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-rebase.sample
?????文件?????????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個文件信息

評論

共有 條評論