Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mysql;
- import java.sql.*;
- public class Console {
- //String sqlite_Driver = "org.sqlite.JDBC";
- //String sqlite_Url = "jdbc:sqlite:test.db";
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://localhost/ITDB";
- String user = "root";
- String pass = "abc123";
- Connection conn;
- Statement stmt;
- String sql;
- ResultSet result;
- Console() {
- try {
- // Loading JDBC Driver Class
- Class.forName(driver);
- conn = DriverManager.getConnection(url, user, pass);
- stmt = conn.createStatement();
- sql = "SELECT id, name, email FROM GradeTB";
- //sql = "SELECT id, name, email FROM GradeTB WHERE name='Orange Lee' ";
- result = stmt.executeQuery(sql);
- while(result.next()){
- String id = result.getString("id");
- String name = result.getString("name");
- String email = result.getString("email");
- System.out.println(id + "\n" + name + "\n" + email);
- }
- result.close();
- stmt.close();
- conn.close();
- } catch (Exception e){
- System.out.println("Error: " + e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment