第一次写博客,刚打开有点惊讶,没想到是用markdown写的,不过又一想好像博客大都是用markdown写的。上次用markdown都是去年了,时间过得真快啊,现在markdown的东西大部分都忘了,等后面再慢慢熟悉起来。
虽然是第一天写,好歹也写点今天自己的学习感受。
整合代码真是太麻烦了,要一点点的去看,修改大家标准不同的地方,不同的类名,方法名~~
2-1.1=0.89999999…
功能实现的两种方式
// 学生查看自己的信息(通过接口,但这种方法为了尝试,改了一下,没有处理异常的步骤,不建议)
public void chaXun() throws SQLException {
in = new Scanner(System.in);
System.out.println("请输入想要查询学生的用户名");
String user_id = in.next();
Connection con = DBHelper.getConnection();
String sql = "select * from status where user_id= ? ";
Object[] parameters = new Object[] { user_id };
ResultSet rs = DBHelper.executeQuery(sql, parameters, con);
Status adminObj = null;
while (rs.next()) {
// 获取数据库的值
adminObj = new Status();
adminObj.setStatus_id(rs.getString(1));
adminObj.setName(rs.getString(2));
adminObj.setUser_id(rs.getString(3));
adminObj.setDate(rs.getString(4));
adminObj.setAchievement_point(rs.getFloat(5));
adminObj.setId_card(rs.getString(6));
adminObj.setSex(rs.getString(7));
adminObj.setHomeplace(rs.getString(8));
adminObj.setSchool_status(rs.getString(9));
}
if (adminObj != null) {
System.out.println(adminObj);
} else if (adminObj == null) {
System.out.println("查询失败,该用户不存在");
}
}
// 删除功能(用接口,但在statusServiceImpl里面是处理了异常的)
public int delStatus(String user_id) throws Exception {
Connection con = DBHelper.getConnection();
String sql = "delete from status where user_id = ?";
Object[] parameters = new Object[] { user_id };
int rs = DBHelper.execute(sql, parameters, con);
return rs;
}
// 增加数据的方法(不用接口,但是处理了异常)
public void addNewsPaper() throws SQLException {
StringBuffer sb = new StringBuffer();
sb.append("insert into status VALUES ");
in = new Scanner(System.in);
// 向数据库中添加数据
System.out.println("请输入学号:" + "\t");
String a = in.next();
sb.append("(" + "'" + a + "'");
System.out.println("请输入姓名:" + "\t");
String b = in.next();
sb.append("," + "'" + b + "'");
System.out.println("请输入用户id:");
String c = in.next();
sb.append("," + "'" + c + "'");
System.out.println("请输入入学日期:");
String d = in.next();
sb.append("," + "( to_date ('" + d + "', 'YYYY-MM-DD' ))");
System.out.println("请输入绩点:");
float e = in.nextFloat();
sb.append("," + e);
System.out.println("请输入身份证号:" + "\t");
String f = in.next();
sb.append("," + "'" + f + "'");
System.out.println("请输入性别:" + "\t");
String g = in.next();
sb.append("," + "'" + g + "'");
System.out.println("请输入籍贯:" + "\t");
String h = in.next();
sb.append("," + "'" + h + "'");
System.out.println("请输入学校:" + "\t");
String i = in.next();
sb.append("," + "'" + i + "'" + ")");
System.out.println(sb);
String AddSQL = sb.toString();
java.sql.PreparedStatement ptmt = null;
try {
ptmt = conn.prepareStatement(AddSQL);
} catch (SQLException e1) {
e1.printStackTrace();
}
conn.setAutoCommit(false);
try {
// 执行SQL语句
ptmt.executeUpdate();
conn.commit();
System.out.println("插入成功");
} catch (SQLException e1) {
e1.printStackTrace();
System.out.println("插入失败");
}
}