/** 插入数据 */ public Integer insertUser(User user) { QueryRunner queryRunner = new QueryRunner(JdbcUtils.getDataSource()); try { String sql = "INSERT INTO user VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; Object param[] = { getID(), user.getUsername(), user.getPassword(), user.getSex(), user.getProfession(), user.getFavourite(), user.getNote(), user.getType() }; int update = queryRunner.update(sql, param); return update; } catch (SQLException e) { e.printStackTrace(); return null; } }
/** * 数据库操作 更新个人用户数据 * * @param user */ public void updateinfo(User user) { QueryRunner queryRunner = new QueryRunner(JdbcUtils.getDataSource()); String sql = "UPDATE user SET username = ?, password = ?, sex = ?, profession = ?, favourite = ?, note = ? WHERE id = ?;"; try { queryRunner.update( sql, new Object[] { user.getUsername(), user.getPassword(), user.getSex(), user.getProfession(), user.getFavourite(), user.getNote(), user.getId() }); } catch (SQLException e) { e.printStackTrace(); } }