Advertisement
Guest User

jdbc with mysql

a guest
May 25th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. class MysqlCon {
  4.  
  5. public static void main(String args[]) {
  6. try {
  7. Class.forName("com.mysql.jdbc.Driver");
  8. Connection con = DriverManager.getConnection(
  9. "jdbc:mysql://localhost:3306/test_database", "root", "");
  10. Statement stmt = con.createStatement();
  11. ResultSet rs = stmt.executeQuery("select * from jdbc ");
  12. while (rs.next()) {
  13. System.out.println("Connected to Mysql Server successfully >>" + "\n\n" + rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3) + " " + rs.getString(4) + " " + rs.getString(5) + " " + rs.getString(6) + " " + rs.getString(7) + " " + rs.getString(8) + "\n");
  14. }
  15. con.close();
  16. } catch (Exception e) {
  17. System.out.println(e);
  18. }
  19. }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement