@Override
  public int create(Object obj) throws SQLException {
    Line line = (Line) obj;
    String insert =
        String.format(
            "INSERT INTO line( code, name, type, description) VALUES ('%s', '%s', '%s', '%s');",
            line.getCode(), line.getName(), line.getType(), line.getDescription());
    Statement st = conn.createStatement();
    int id = st.executeUpdate(insert, Statement.RETURN_GENERATED_KEYS);
    line.setId(id);

    return id;
  }
  @Override
  public Line read(int id) throws SQLException {
    Line line = null;

    String sql = String.format("SELECT * FROM line WHERE line.id = '%s'", id);

    Statement st;

    st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs = st.executeQuery(sql);

    rs.first();

    line =
        new Line(
            rs.getString("code"),
            rs.getString("name"),
            rs.getString("type"),
            rs.getString("description"));
    line.setId(rs.getInt("id"));

    return line;
  }