Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. class Conn{
  4.  
  5. public static void main(String[] args) {
  6. try{
  7. Class.forName("com.mysql.jdbc.Driver");
  8.  
  9. String URL ="jdbc:mysql://localhost/Database_name?useSSL=false"; //Remove that Database_name and enter your database_name
  10. String USER = "root"; //Remove root and write your mysql Username
  11. String PASSWORD = "********"; //same as Username
  12.  
  13. Connection con = DriverManager.getConnection(URL, USER, PASSWORD);
  14. Statement stm = con.createStatement();
  15. ResultSet res = stm.executeQuery("select * from employee");
  16.  
  17. while(res.next()){
  18. String Comm = res.getString("Commission_pct");
  19. String Dep = res.getString("department_id");
  20. String email = res.getString("email");
  21. String Id = res.getString("employee_id");
  22. String First = res.getString("first_name");
  23. String Hire = res.getString("Hire_date");
  24. String jobid = res.getString("job_id");
  25. String last = res.getString("last_name");
  26. String manager_id = res.getString("manager_id");
  27. String Phone = res.getString("Phone_number");
  28. String salary = res.getString("salary");
  29.  
  30. System.out.println(Comm + " " + Dep + " " + email + " " + Id + " " + First + " " + Hire + " " + jobid + " " +
  31. " " + last + " " + manager_id + " " + Phone + " " + salary);
  32. }
  33. con.close(); //Closing the Connection
  34. }catch(Exception e){
  35. e.printStackTrace();
  36. }
  37. }
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement