项目描述
上传时间
浏览人数
本文主要是教师端展示及核心代码展示
教师登录后
增加其他功能的按钮
点击新增按钮
新增数据
结果
数据库:
点击”李四”修改按钮:
其中姓名无法修改,其余皆可修改
更改其中内容,并点击修改,成绩页面自动变化
数据库中发生变化:
点击”赵六”的删除之前
点击”赵六”的删除之后:
数据库中内容发生变化:
核心代码展示:
Dao层中
// 连接数据库
public Connection connect() {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/data", "root", "123456");
return c;
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
// 查询每条的所有信息(登录)
public Pojo search(String username) {
String sql = "select * from data.info where username = '" + username + "';";
try {
PreparedStatement pre = connect().prepareStatement(sql);
ResultSet re = pre.executeQuery();
// 需要先写Pojo
Pojo pj = new Pojo();
while (re.next()) {
pj.setUsername(username);
pj.setPassword(re.getString("password"));
pj.setGender(re.getString("gender"));
pj.setChinese(re.getString("chinese"));
pj.setMath(re.getString("math"));
pj.setEnglish(re.getString("english"));
pj.setComplex(re.getString("complex"));
pj.setInfo(re.getString("info"));
pj.setNote(re.getString("note"));
pj.setIndex(re.getString("index"));
}
return pj;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
// 更改内容
public int update(String username, String password, String gender, String chinese, String math, String english,
String complex, String info, String note) {
String sql = "UPDATE data.info SET password='" + password + "',gender='" + gender + "',chinese='" + chinese
+ "',math='" + math + "',english='" + english + "',complex='" + complex + "',info='" + info + "',note='"
+ note + "' WHERE username='" + username + "';";
try {
PreparedStatement pre = connect().prepareStatement(sql);
int i = pre.executeUpdate();
connect().close();
return i;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
// 删除
public int delete(String username) {
String sql = "DELETE FROM data.info WHERE username='" + username + "';";
try {
PreparedStatement pre = connect().prepareStatement(sql);
int i = pre.executeUpdate();
connect().close();
return i;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
// 增加验证码库
public int addMsg(String phonenum, String code) {
String sql = "INSERT INTO data.msg (phonenum, code) VALUES ('" + phonenum + "', '" + code + "');";
try {
PreparedStatement pre = connect().prepareStatement(sql);
int i = pre.executeUpdate();
connect().close();
return i;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0;
}
// 搜索验证码
public msgPojo selectMsg(String phonenum) {
String sql = "select * from data.msg where phonenum='" + phonenum + "';";
try {
PreparedStatement pre = connect().prepareStatement(sql);
ResultSet re = pre.executeQuery();
connect().close();
msgPojo msgP = new msgPojo();
while (re.next()) {
msgP.setPhonenum(phonenum);
msgP.setCode(re.getString("code"));
}
return msgP;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}