Advertisement
Guest User

Untitled

a guest
Apr 17th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.77 KB | None | 0 0
  1. <ScrollView
  2. android:layout_width="match_parent"
  3. android:layout_height="match_parent">
  4. <LinearLayout
  5. android:id="@+id/scrollView"
  6. android:layout_width="match_parent"
  7. android:layout_height="wrap_content"
  8. android:orientation="vertical">
  9. </LinearLayout>
  10. </ScrollView>
  11.  
  12. //On the onCreate:
  13. scrollView = (LinearLayout) findViewById(R.id.scrollView);
  14.  
  15. public void startThread(){
  16.  
  17. currentThread = new Thread(){
  18. public void run(){
  19.  
  20. alertHandler = new Handler(Looper.getMainLooper());
  21.  
  22. try{
  23.  
  24. Class.forName("org.postgresql.Driver");
  25.  
  26. String url = "jdbc:postgresql://x";
  27. Connection conn = DriverManager.getConnection(url,"x","x");
  28.  
  29. String statementSQL = "SELECT * FROM x.User;";
  30. Statement statement = conn.createStatement();
  31. ResultSet resultSet = statement.executeQuery(statementSQL);
  32.  
  33. while(resultSet.next()){
  34. try{
  35. incident = new Incident();
  36. incident.setID(resultSet.getInt(1));
  37. incident.setType(resultSet.getString(2));
  38. incident.setNature(resultSet.getString(3));
  39. resultsData.add(incident);
  40.  
  41. alertHandler.post(new Runnable() {
  42. @Override
  43. public void run() {
  44. setScrollViewElements(incident.getID());
  45. }
  46. });
  47. }catch (Exception ex){
  48. ex.printStackTrace();
  49. }
  50. }
  51.  
  52. conn.close();
  53.  
  54. } catch (SQLException se){
  55. se.printStackTrace();
  56.  
  57. } catch (ClassNotFoundException e){
  58. e.printStackTrace();
  59. } catch (Exception ex){
  60. ex.printStackTrace();
  61. }
  62. Thread.currentThread().interrupt();
  63. }
  64. };
  65.  
  66. if (currentThread.getState() == Thread.State.NEW){
  67. currentThread.start();
  68. }
  69. }
  70.  
  71. public void setScrollViewElements(int id){
  72. try{
  73. TextView scrollElement = new TextView(this);
  74. scrollElement.setOnClickListener(listener);
  75.  
  76. scrollElement.setId(id);
  77. scrollElement.setText("Incidencia No." + id);
  78.  
  79. scrollView.addView(scrollElement);
  80. }catch (Exception ex){
  81. ex.printStackTrace();
  82. }
  83. }
  84.  
  85. public class Incident {
  86. private String type;
  87. private String nature;
  88. private Date date;
  89. private int id;
  90. private double latitude;
  91. private double longitude;
  92.  
  93. public void setType(String type) {
  94. this.type = type;
  95. }
  96. public String getType() {
  97. return type;
  98. }
  99.  
  100. public void setNature(String nature) {
  101. this.nature = nature;
  102. }
  103. public String getNature() {
  104. return nature;
  105. }
  106.  
  107. public void setDate(Date date) {
  108. this.date = date;
  109. }
  110. public Date getDate() {
  111. return date;
  112. }
  113.  
  114. public void setID(int id) {
  115. this.id = id;
  116. }
  117. public int getID() {
  118. return id;
  119. }
  120.  
  121. public void setLatitude(double lat) {
  122. this.latitude = lat;
  123. }
  124. public double getLatitude() {
  125. return latitude;
  126. }
  127.  
  128. public void setLongitude(double lon) {
  129. this.longitude = lon;
  130. }
  131. public double getLongitude() {
  132. return longitude;
  133. }
  134.  
  135. }
  136.  
  137. public View.OnClickListener listener = new View.OnClickListener() {
  138.  
  139. @Override
  140. public void onClick(View v) {
  141. for (Incident inc: resultsData){
  142. if(inc.getID() == v.getId()){
  143. Log.d("Error",""+inc.getID());
  144. }
  145. }
  146. }
  147. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement