Пример #1
0
  public List getDownloadHistorydao(int user_id) {
    Connection con = null;
    List list = new ArrayList();
    try {
      // Class.forName(classname);

      // con=DriverManager.getConnection(split[0],split[1],split[2]);
      con = DatasourceConnection.getConnection();
      Statement st1 = con.createStatement();

      String query =
          "select * from downloadhistory where user_id=" + user_id + " order by download_id desc";

      System.out.print(query);
      ResultSet rs = st1.executeQuery(query);
      while (rs.next()) {
        modeldownload obj = new modeldownload();
        obj.setSong_name(rs.getString("song_name"));
        obj.setDtime(rs.getString("dtime"));
        obj.setUrl(rs.getString("url"));
        list.add(obj);
      }
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      return list;
    } catch (Exception e) {
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      System.out.print("Error in downloadhistory dao" + e);
      list = null;
      return list;
    }
  }
Пример #2
0
  public List adminsearchartistdao(String q) {
    Connection con = null;
    List list = new ArrayList();
    try {
      // Class.forName(classname);
      // con=DriverManager.getConnection(split[0],split[1],split[2]);
      con = DatasourceConnection.getConnection();
      Statement st = con.createStatement();
      String query =
          "select distinct Album_id,Album_name,Artist_name,img_url from album where Artist_name LIKE '"
              + q
              + "' or Artist_name like '"
              + q
              + "_' or Artist_name like '"
              + q
              + "%' or Artist_name like '%"
              + q
              + "%'";
      System.out.print(query);
      ResultSet rs = st.executeQuery(query);
      Statement st1 = con.createStatement();
      Statement st2 = con.createStatement();

      // rs.beforeFirst();
      while (rs.next()) {
        // ResultSet rs1=st2.executeQuery("select Album_name from Album where
        // Album_id='"+rs.getString(1)+"'");
        // ResultSet rs2=st2.executeQuery("select Genre from GENRE where
        // Genre_id=\'"+rs.getString(6) +"\'");

        modelsearch obj = new modelsearch();
        obj.setAlbum_id(rs.getInt(1));
        obj.setAlbum_name(rs.getString(2));
        // obj.setSong_id(rs.getString(3));
        // obj.setSong_name(rs.getString(4));
        // obj.setSong_url(rs.getString(5));
        // obj.setGenre(rs2.getString(1));
        obj.setArtist_name(rs.getString(3));
        obj.setImg_url(rs.getString("img_url"));
        list.add(obj);
      }
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      return list;

    } catch (Exception e) {
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      System.out.print("adminsearchartistdao" + e);
      list.add("Error");
      return list;
    }
  }
Пример #3
0
  public List searchsongdao(String q) {
    Connection con = null;
    List list = new ArrayList();
    try {
      // Class.forName(classname);
      // con=DriverManager.getConnection(split[0],split[1],split[2]);
      con = DatasourceConnection.getConnection();
      Statement st = con.createStatement();
      String query =
          "select distinct song.Album_id,Album_name,song_id,Song_name,song_url,song.Genre_id,song.Artist_name,img_url from song join album using(Album_id) where Song_name LIKE \'"
              + q
              + "\' or Song_name like \'"
              + q
              + "_\' or Song_name like \'"
              + q
              + "%\' or Song_name like \'%"
              + q
              + "%\'";
      System.out.print(query);
      ResultSet rs = st.executeQuery(query);
      Statement st1 = con.createStatement();

      // rs.beforeFirst();
      while (rs.next()) {
        ResultSet rs1 =
            st1.executeQuery("select Genre from genre where Genre_id=\'" + rs.getString(6) + "\'");
        rs1.next();
        modelsearch obj = new modelsearch();
        obj.setAlbum_id(rs.getInt(1));
        obj.setAlbum_name(rs.getString(2));
        obj.setSong_id(rs.getInt(3));
        obj.setSong_name(rs.getString(4));
        obj.setSong_url(rs.getString(5));
        obj.setGenre(rs1.getString(1));
        obj.setArtist_name(rs.getString(7));
        obj.setImg_url(rs.getString("img_url"));
        list.add(obj);
      }
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      return list;

    } catch (Exception e) {
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      System.out.print("Search Song dao" + e);
      list.add("Error");
      return list;
    }
  }
Пример #4
0
  public List adminsearchusernamedao(String q) {
    Connection con = null;
    List list = new ArrayList();
    try {
      // Class.forName(classname);
      // con=DriverManager.getConnection(split[0],split[1],split[2]);
      con = DatasourceConnection.getConnection();
      Statement st = con.createStatement();
      String query =
          "select * from customer where username like \'"
              + q
              + "\' or username like \'"
              + q
              + "_\' or username like \'_"
              + q
              + "\' or username like \'"
              + q
              + "%\'  or username like \'%"
              + q
              + "\' or username like \'%"
              + q
              + "%\'";
      System.out.println(query + "@Query Ended@");
      ResultSet rs = st.executeQuery(query);
      while (rs.next()) {
        modelregister obj = new modelregister();
        obj.setUser_id(rs.getInt("user_id"));
        obj.setUsername(rs.getString("username"));

        obj.setFname(rs.getString("first_name"));
        obj.setLname(rs.getString("last_name"));

        obj.setSex(rs.getString("sex"));
        obj.setDob(rs.getString("dob"));
        obj.setCity(rs.getString("city"));
        obj.setEmail(rs.getString("email"));

        list.add(obj);
      }
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      return list;
    } catch (Exception e) {
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      System.out.print("adminsearchusernamedao" + e);
      return list;
    }
  }
Пример #5
0
  public int setDownloadHistorydao(int user_id, String song_name, String url) {
    Connection con = null;
    try {
      // Class.forName(classname);
      //  con=DriverManager.getConnection(split[0],split[1],split[2]);
      con = DatasourceConnection.getConnection();
      Statement st1 = con.createStatement();
      String q =
          "insert into downloadhistory(user_id,song_name,url) values("
              + user_id
              + ",'"
              + song_name
              + "','"
              + url
              + "')";
      int i = st1.executeUpdate(q);
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      if (i == 1) {
        if (con != null) {
          DatasourceConnection.closeConnection(con);
        }
        return 1;
      } else {
        if (con != null) {
          DatasourceConnection.closeConnection(con);
        }
        return 0;
      }

    } catch (Exception e) {
      if (con != null) {
        DatasourceConnection.closeConnection(con);
      }
      System.out.print("Error in insert" + e);
      return 0;
    }
  }