Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package jason;
- import java.sql.*;
- public class Second {
- //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 getConn;
- Statement createComm;
- String comm;
- ResultSet data;
- Second() {
- try {
- // Loading JDBC Driver Class
- Class.forName(driver);
- getConn = DriverManager.getConnection(url, user, pass);
- createComm = getConn.createStatement();
- comm = "SELECT id, name, email FROM GradeTB";
- data = createComm.executeQuery(comm);
- while(data.next()){
- String id = data.getString("id");
- String name = data.getString("name");
- String email = data.getString("email");
- System.out.println(id + "\n" + name + "\n" + email);
- }
- data.close();
- createComm.close();
- getConn.close();
- } catch (Exception e){
- System.out.println(e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment