Advertisement
Guest User

Untitled

a guest
May 12th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. Class.forName("com.mysql.jdbc.Driver");
  2.  
  3. String url = "jdbc:mysql://localhost:3306";
  4. Connection conn = DriverManager.getConnection(url, "root", "admin");
  5. Statement st = conn.createStatement();
  6. ResultSet srs = st.executeQuery("SELECT * FROM userID");
  7. while (srs.next()) {
  8. Person person = new Person();
  9. person.setName(srs.getString("Name"));
  10. person.setJobtitle(srs.getString("Job"));
  11. personlist.add(person);
  12. }
  13.  
  14. public class Person {
  15. private String name;
  16. private String jobtitle;
  17.  
  18. public String getJobtitle() {
  19. return jobtitle;
  20. }
  21.  
  22. public void setJobtitle(String jobtitle) {
  23. this.jobtitle = jobtitle;
  24. }
  25.  
  26. public String getName() {
  27. return name;
  28. }
  29.  
  30. public void setName(String name) {
  31. this.name = name;
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement