Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- class Conn{
- public static void main(String[] args) {
- try{
- Class.forName("com.mysql.jdbc.Driver");
- String URL ="jdbc:mysql://localhost/Database_name?useSSL=false"; //Remove that Database_name and enter your database_name
- String USER = "root"; //Remove root and write your mysql Username
- String PASSWORD = "********"; //same as Username
- Connection con = DriverManager.getConnection(URL, USER, PASSWORD);
- Statement stm = con.createStatement();
- ResultSet res = stm.executeQuery("select * from employee");
- while(res.next()){
- String Comm = res.getString("Commission_pct");
- String Dep = res.getString("department_id");
- String email = res.getString("email");
- String Id = res.getString("employee_id");
- String First = res.getString("first_name");
- String Hire = res.getString("Hire_date");
- String jobid = res.getString("job_id");
- String last = res.getString("last_name");
- String manager_id = res.getString("manager_id");
- String Phone = res.getString("Phone_number");
- String salary = res.getString("salary");
- System.out.println(Comm + " " + Dep + " " + email + " " + Id + " " + First + " " + Hire + " " + jobid + " " +
- " " + last + " " + manager_id + " " + Phone + " " + salary);
- }
- con.close(); //Closing the Connection
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement