Пример #1
0
 static {
   try {
     // registered jdbc driver
     Class.forName(
         ConfigManager.get(
             "db.driverClass",
             ConfigManager.get("spring.datasource.driverClassName", "com.mysql.jdbc.Driver")));
   } catch (ClassNotFoundException e) {
     e.printStackTrace();
     System.exit(-1);
   }
 }
Пример #2
0
  /** 修改头像 */
  @RequestMapping(value = "/avatar/mod", method = RequestMethod.POST)
  public ResponseMessage modAvatar(
      HttpServletRequest request, long uid, @RequestParam(value = "img") MultipartFile file)
      throws Exception {
    // save the source avatar image file, 原始尺寸
    String filename = ImageController.uploadImg(request, file).getValue();
    AvatarDetail origin = new AvatarDetail();
    origin.setPhoto(filename);
    origin.setUserId(uid);
    origin.setTime(new Timestamp(System.currentTimeMillis()));
    avatarDetailRepository.save(origin);

    // generate image of the specified size and save,指定尺寸
    String avatar =
        ThumbnailGen.getInstance(request)
            .setUploadPath(FilenameUtils.concat(ConfigManager.get("upload.basePath"), "avatar"))
            .setUid(String.valueOf(uid))
            .gen(FilenameUtils.concat(ServerHelper.getContextPath(request), filename));

    AvatarDetail thumbnail = new AvatarDetail();
    thumbnail.setPhoto(avatar);
    thumbnail.setUserId(uid);
    thumbnail.setTime(new Timestamp(System.currentTimeMillis()));
    avatarDetailRepository.save(thumbnail);

    User user = userRepository.findById(uid);
    user.setAvatar(avatar);
    userRepository.save(user);
    return new ResponseMessage().set("filename", avatar).set("url", WebMvcConfig.getUrl(avatar));
  }
Пример #3
0
 /**
  * 上传图片文件
  *
  * @param request http 请求
  * @param file 照片文件
  * @throws IOException
  */
 public static Pair<String, String> uploadImg(HttpServletRequest request, MultipartFile file)
     throws IOException {
   String uploadPath = FilenameUtils.concat(ConfigManager.get("upload.basePath"), "image");
   return MultipartFileUploader.getInstance(request)
       .setUploadPath(uploadPath)
       .setDefaultExtension("png")
       .upload(file);
 }
Пример #4
0
/** Created by zhuyin on 7/6/14. */
public class JdbcDAO {
  String url = ConfigManager.get("db.url", ConfigManager.get("spring.datasource.url"));
  String username =
      ConfigManager.get("db.username", ConfigManager.get("spring.datasource.username"));
  String password =
      ConfigManager.get("db.password", ConfigManager.get("spring.datasource.password"));
  Connection conn = null;

  static {
    try {
      // registered jdbc driver
      Class.forName(
          ConfigManager.get(
              "db.driverClass",
              ConfigManager.get("spring.datasource.driverClassName", "com.mysql.jdbc.Driver")));
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
      System.exit(-1);
    }
  }

  public String getUrl() {
    return url;
  }

  /**
   * @param url a database url of the form <code>jdbc:<em>subprotocol</em>:<em>subname</em></code>
   *     <br>
   *     MySQL的JDBC URL格式: jdbc:mysql//[hostname][:port]/[dbname][?param1=value1][&param2=value2]….
   *     <br>
   *     for example:jdbc:mysql://localhost:3306/sample_db?user=root&password=your_password
   */
  public JdbcDAO setUrl(String url) {
    this.url = url;
    return this;
  }

  public String getUsername() {
    return username;
  }

  public JdbcDAO setUsername(String username) {
    this.username = username;
    return this;
  }

  public String getPassword() {
    return password;
  }

  public JdbcDAO setPassword(String password) {
    this.password = password;
    return this;
  }
  /**
   * get db connection
   *
   * @return db connection
   */
  public Connection getConn() throws SQLException {
    if (this.conn != null) return this.conn;
    this.conn = DriverManager.getConnection(this.url, this.username, this.password);
    return this.conn;
  }

  /**
   * 行查询数据库的SQL语句,返回一个结果集(ResultSet)对象
   *
   * @throws SQLException
   */
  public Object executeQuery(String sql, ResultSetFetcher fetcher) throws SQLException {
    try (Statement stat = this.getConn().createStatement()) {
      try (ResultSet rs = stat.executeQuery(sql)) {
        return fetcher.fetch(rs);
      }
    }
  }

  /**
   * 用于执行INSERT、UPDATE或DELETE语句以及SQL DDL语句,如:CREATE TABLE和DROP TABLE等
   *
   * @throws SQLException
   */
  public int executeUpdate(String sql) throws SQLException {
    try (Statement stat = this.getConn().createStatement()) {
      return stat.executeUpdate(sql);
    }
  }

  public interface ResultSetFetcher {
    Object fetch(ResultSet rs) throws SQLException;
  }
}