Last active
February 10, 2021 02:28
-
-
Save akhyaruu/d5454f7787e5634fb68f0ef57577ade4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import java.sql.*; | |
| public class JDBCExample { | |
| static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; | |
| static final String DB_URL = "jdbc:mysql://localhost/EMP"; | |
| static final String USER = "username"; | |
| static final String PASS = "password"; | |
| public static void main(String[] args) { | |
| Connection conn = null; | |
| try { | |
| Class.forName("com.mysql.jdbc.Driver"); | |
| System.out.println("Connecting to database..."); | |
| conn = DriverManager.getConnection(DB_URL,USER,PASS); | |
| System.out.println("Creating statement..."); | |
| Statement stmt = conn.createStatement(); | |
| String sql; | |
| sql = "SELECT id, first, last, age FROM Employees"; | |
| ResultSet rs = stmt.executeQuery(sql); | |
| while(rs.next()) { | |
| int id = rs.getInt("id"); | |
| int age = rs.getInt("age"); | |
| String first = rs.getString("first"); | |
| String last = rs.getString("last"); | |
| System.out.print("ID: " + id); | |
| System.out.print(", Age: " + age); | |
| System.out.print(", First: " + first); | |
| System.out.println(", Last: " + last); | |
| } | |
| rs.close(); | |
| stmt.close(); | |
| conn.close(); | |
| } catch(SQLException se) { | |
| se.printStackTrace(); | |
| } catch(Exception e) { | |
| e.printStackTrace(); | |
| } finally { | |
| try { | |
| if (conn!=null) | |
| conn.close(); | |
| } catch(SQLException se) { | |
| se.printStackTrace(); | |
| } | |
| } | |
| System.out.println("Goodbye!"); | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment