Advertisement
Guest User

Untitled

a guest
Nov 3rd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.80 KB | None | 0 0
  1. t java.sql.*; public class DBConnect { private Connection con; private Statement st; private ResultSet rs; public DBConnect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", ""); st = con.createStatement(); } catch (Exception ex) { System.out.println("Error: " + ex); } } public void getData() { try { String query = "select * from persons"; rs = st.executeQuery(query); System.out.println("Records from Database"); while (rs.next()) { String name = rs.getString("name"); String age = rs.getString("age"); System.out.println("Name: " + name + " Age: " + age); } } catch(Exception ex) { System.out.println(ex); } } } public class Main { public static void main(String[] args) { DBConnect connect = new DBConnect(); connect.getData(); }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement