Advertisement
Guest User

Untitled

a guest
May 12th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.65 KB | None | 0 0
  1. public void onTextChanged(CharSequence s, int start, int before, int count) {
  2. if (s.length() > 1) {
  3. insertString = s.toString();
  4. new YourTask().execute(insertString);
  5. }
  6. }
  7.  
  8. protected List<String> doInBackground() {
  9. // fetchning data from MySQL
  10. return list;
  11. }
  12.  
  13. public void onPostExecute(List<String> result) {
  14. if (!result.isEmpty()) {
  15. SomeAdapter adp = new SomeAdapter(context, layout, result);
  16. actv.setAdapter(adp);
  17. }
  18. }
  19.  
  20. import android.content.Context;
  21. import android.util.AttributeSet;
  22. import android.widget.AutoCompleteTextView;
  23.  
  24. public class MyAutoCompleteTextView extends AutoCompleteTextView {
  25.  
  26. public MyAutoCompleteTextView(Context context, AttributeSet attrs,
  27. int defStyle) {
  28. super(context, attrs, defStyle);
  29. }
  30.  
  31. @Override
  32. protected void performFiltering(CharSequence text, int keyCode) {
  33. //Here the AutompleteTextView has determined that the list should be filtered
  34. }
  35.  
  36. }
  37.  
  38. AutoCompleteTextView txtSearch;
  39. PeopleAdapter adapter;
  40. List<People> mList;
  41. TextView idd;
  42. ImageView imgspn;
  43.  
  44.  
  45. @Override
  46. protected void onCreate(Bundle savedInstanceState) {
  47. super.onCreate(savedInstanceState);
  48. setContentView(R.layout.activity_main);
  49.  
  50. mList = retrievePeople();
  51.  
  52. txtSearch = (AutoCompleteTextView) findViewById(R.id.txt_search);
  53.  
  54. adapter = new PeopleAdapter(this, R.layout.activity_main, R.id.lbl_name, mList);
  55. txtSearch.setThreshold(1);
  56. txtSearch.setAdapter(adapter);
  57.  
  58. idd = (TextView) findViewById(R.id.idd);
  59. imgspn = (ImageView) findViewById(R.id.imgspn);
  60. imgspn.setVisibility(View.INVISIBLE);
  61.  
  62. txtSearch.setOnItemClickListener(new OnItemClickListener() {
  63. @Override
  64. public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
  65. String Name = mList.get(position).getId();
  66. idd.setText(Name);
  67. }
  68. });
  69.  
  70. }
  71.  
  72. private List<People> retrievePeople() {
  73.  
  74. List<People> list = new ArrayList<People>();
  75. try {
  76. Class.forName("com.mysql.jdbc.Driver");
  77. Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://182.160.119.77:3306/hrms", "root",
  78. "W1nd0wsL1ve");
  79. Statement st = (Statement) con.createStatement();
  80. ResultSet rs = (ResultSet) st.executeQuery(
  81. "select name,designation_name,id from umdlv_users ut,t_designation td where ut.designation_id = td.designation_id");
  82. while (rs.next()) {
  83.  
  84. list.add(new People(rs.getString(1), rs.getString(2), rs.getString(3)));
  85. }
  86. rs.close();
  87. st.close();
  88. con.close();
  89. } catch (Exception e) {
  90. }
  91. return list;
  92. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement