Advertisement
Guest User

Untitled

a guest
Sep 14th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. public class DBSelectQuery extends DBConnection {
  2. public static void main(String[] args) {
  3. selectCourier();
  4. }
  5. public static String selectCourier() {
  6. queryStmt += "SELECT * FROM courier";
  7. System.out.println(queryStmt);
  8. return queryStmt;
  9. }
  10. }
  11.  
  12. public class DBConnection {
  13. public static Connection con;
  14. public static String queryStmt;
  15. public static void main(String[] args) {
  16. // TODO Auto-generated method stub
  17. try {
  18. Class.forName("com.mysql.jdbc.Driver");
  19. con = DriverManager.getConnection("jdbc:mysql://localhost:3306/java_activity", "root", "root");
  20. System.out.println("Database Connected");
  21. Statement stmt = con.createStatement();
  22. ResultSet rs = stmt.executeQuery(queryStmt);
  23. while (rs.next())
  24. System.out.println(rs.getInt(1) + " " + rs.getString(2));
  25. con.close();
  26. }
  27.  
  28. catch (Exception e) {
  29. System.out.println(e);
  30. }
  31.  
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement