《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
CREATE TABLE staff (
num varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
sex varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
salary varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
phone varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
dept varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
duty varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (num) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
– Records of staff
INSERT INTO staff VALUES (‘1001’, ‘张三’, ‘男’, ‘50000’, ‘13332259632’, ‘大数据部’, ‘部长’);
INSERT INTO staff VALUES (‘1002’, ‘李四’, ‘男’, ‘30000’, ‘13332259632’, ‘大数据部’, ‘科长’);
INSERT INTO staff VALUES (‘1003’, ‘王五’, ‘男’, ‘20000’, ‘13332259632’, ‘后勤部’, ‘职员’);
SET FOREIGN_KEY_CHECKS = 1;
二、系统展示
======
1.登录系统
2.主页面
3.部门管理
4.职位管理
5.员工管理
三、部分代码
======
AdminDao.java
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import utils.DBUtil;
import vo.Admin;
public class AdminDao {
// 判断有无此用户
public static boolean isUser(Admin admin) {
String sql = “select * from login where username=? and password = ?”;
ResultSet rs;
// 定义数组用来存放账号和密码
String[] adminString = new String[] {admin.getUserName(), admin.getPassword()};
try {
rs = DBUtil.execQuery(sql, adminString);
if (rs.next())
return true;
else
return false;
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
DBUtil.close();
}
}
// 测试
public static void main(String[] args) {
Admin admin = new Admin();
admin.setUserName(“admin”);
admin.setPassword(“admin”);
boolean flag = isUser(admin);
System.out.println(flag);
}
}
DeptDao.java
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import utils.DBUtil;
import utils.SqlHelper;
import vo.Dept;
/**
-
部门管理
*/
public class DeptDao {
static public int update(Dept dept, int flag) throws SQLException {
int result = -1;
String sqlCondition[] = null;
try {
switch (flag) {
case SqlHelper.INSERT:
sqlCondition = new String[] { dept.getNum(), dept.getName(), dept.getAddress() };
break;
case SqlHelper.DELETE:
sqlCondition = new String[] { dept.getNum() };
break;
case SqlHelper.UPDATE:
sqlCondition = new String[] { dept.getName(), dept.getAddress(), dept.getNum() };
break;
}
result = DBUtil.execUpdate(SqlHelper.DeptSqls[flag], sqlCondition);
return result;
} catch (SQLException e) {
} finally {
DBUtil.close();
}
return result;
}
static public Dept query(final Dept dept) throws SQLException {
ResultSet rs;
try {
rs = DBUtil.execQuery(“select * from dept where num=?”, new String[] { dept.getNum() });
if (rs.next()) {
dept.setName(rs.getString(“name”));
dept.setAddress(rs.getString(“address”));
System.out.println(“查到该数据”);
} else {
System.out.println(“没有查到该数据”);
return null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} finally {
DBUtil.close();
}
return dept;
}
}
DutyDao.java
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import utils.DBUtil;
import utils.SqlHelper;
import vo.Duty;
/**
-
职务管理
*/
public class DutyDao {
static public int update(Duty duty, int flag) throws SQLException {
int result = -1;
String sqlCondition[] = null;
try {
switch (flag) {
case SqlHelper.INSERT:
sqlCondition = new String[] { duty.getNum(), duty.getName(), duty.getLow(), duty.getHigh() };
break;
case SqlHelper.DELETE:
sqlCondition = new String[] { duty.getNum() };
break;
case SqlHelper.UPDATE:
sqlCondition = new String[] { duty.getName(), duty.getLow(), duty.getHigh(), duty.getNum() };
break;
}
result = DBUtil.execUpdate(SqlHelper.DutySqls[flag], sqlCondition);
return result;
} catch (SQLException e) {
} finally {
DBUtil.close();
}
return result;
}
static public Duty query(final Duty duty) throws SQLException {
ResultSet rs;
try {
rs = DBUtil.execQuery(“select * from duty where num=?”, new String[] { duty.getNum() });
if (rs.next()) {
duty.setNum(rs.getString(“num”));
duty.setName(rs.getString(“name”));
duty.setLow(rs.getString(“low”));
duty.setHigh(rs.getString(“high”));
System.out.println(“查到该数据”);
} else {
System.out.println(“没有查到该数据”);
return null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} finally {
DBUtil.close();
}
return duty;
}
}
StaffDao.java
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import utils.DBUtil;
import utils.SqlHelper;
import vo.Staff;
/**
-
职员管理
*/
public class StaffDao {
static public int update(Staff staff, int flag) throws SQLException {
int result = -1;
String sqlCondition[] = null;
try {
switch (flag) {
case SqlHelper.INSERT:
sqlCondition = new String[] { staff.getNum(), staff.getName(),
staff.getSex(), staff.getSalary(), staff.getPhone(),
staff.getDept(), staff.getDuty() };
break;
case SqlHelper.DELETE:
sqlCondition = new String[] { staff.getNum() };
break;
case SqlHelper.UPDATE:
sqlCondition = new String[] { staff.getName(), staff.getSex(),
staff.getSalary(), staff.getPhone(), staff.getDept(),
staff.getDuty(), staff.getNum() };
break;
}
result = DBUtil.execUpdate(SqlHelper.StaffSqls[flag],
sqlCondition);
return result;
} catch (SQLException e) {
} finally {
DBUtil.close();
}
return result;
}
static public Staff query(final Staff staff) throws SQLException {
ResultSet rs;
try {
rs = DBUtil.execQuery(“select * from staff where num=?”,
new String[] { staff.getNum() });
if (rs.next()) {
staff.setNum(rs.getString(“num”));
staff.setName(rs.getString(“name”));
staff.setSex(rs.getString(“sex”));
staff.setSalary(rs.getString(“salary”));
staff.setPhone(rs.getString(“phone”));
staff.setDept(rs.getString(“dept”));
staff.setDuty(rs.getString(“duty”));
System.out.println(“查到该数据” + staff.getNum());
} else {
System.out.println(“没有查到该数据”);
return null;
}
} catch (SQLException e) {
e.printStackTrace();
return null;
} finally {
DBUtil.close();
}
return staff;
}
static public ResultSet checkSalary(Staff staff) {
ResultSet dutyRs = null;
try {
dutyRs = DBUtil.execQuery(“select * from duty where name=?”,
new String[] { staff.getDuty() });
} catch (SQLException e) {
e.printStackTrace();
}
return dutyRs;
}
static public ResultSet checkDept(Staff staff) {
ResultSet dutyRs = null;
try {
dutyRs = DBUtil.execQuery(“select name from dept where name=?”,
new String[] { staff.getDept() });
} catch (SQLException e) {
e.printStackTrace();
}
return dutyRs;
}
static public ResultSet checkDuty(Staff staff) {
ResultSet dutyRs = null;
try {
dutyRs = DBUtil.execQuery(“select name from duty where name=?”,
new String[] { staff.getDuty() });
} catch (SQLException e) {
e.printStackTrace();
}
return dutyRs;
}
}
四、其他
=====
1.更多系统
JavaSwing系统系列实现
Java+JSP系统系列实现
Java+Servlet系统系列实现
那么如何才能正确的掌握Redis呢？
为了让大家能够在Redis上能够加深，所以这次给大家准备了一些Redis的学习资料，还有一些大厂的面试题，包括以下这些面试题
-
并发编程面试题汇总
-
JVM面试题汇总
-
Netty常被问到的那些面试题汇总
-
Tomcat面试题整理汇总
-
Mysql面试题汇总
-
Spring源码深度解析
-
Mybatis常见面试题汇总
-
Nginx那些面试题汇总
-
Zookeeper面试题汇总
-
RabbitMQ常见面试题汇总
JVM常频面试:
Mysql面试题汇总（一）
Mysql面试题汇总（二）
Redis常见面试题汇总（300+题）
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
助取款机系统-TXT存储数据]( )
Java+JSP系统系列实现
Java+Servlet系统系列实现
那么如何才能正确的掌握Redis呢？
为了让大家能够在Redis上能够加深，所以这次给大家准备了一些Redis的学习资料，还有一些大厂的面试题，包括以下这些面试题
-
并发编程面试题汇总
-
JVM面试题汇总
-
Netty常被问到的那些面试题汇总
-
Tomcat面试题整理汇总
-
Mysql面试题汇总
-
Spring源码深度解析
-
Mybatis常见面试题汇总
-
Nginx那些面试题汇总
-
Zookeeper面试题汇总
-
RabbitMQ常见面试题汇总
JVM常频面试:
[外链图片转存中…(img-921tY1vS-1714474617196)]
Mysql面试题汇总（一）
[外链图片转存中…(img-V7T6bxbW-1714474617197)]
Mysql面试题汇总（二）
[外链图片转存中…(img-wcywlFdZ-1714474617197)]
Redis常见面试题汇总（300+题）
[外链图片转存中…(img-ZGARFskG-1714474617197)]
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
852
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
