mySQL_QueryEmp5 |
Code :
/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package template1; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; /** * * @author Manas9 */ public class Template1 { /** * @param args the command line arguments */ public static void main(String args[]) { // TODO code application logic here System.out.println("main block executing "); Connection c = null; Statement st = null; ResultSet rs = null; // result set object String dbURL = "jdbc:mysql://localhost/test?"; String user = "Manas9"; String pwd = "Manas9237"; Properties param = new Properties(); // connecting to db try { //replacing Class.forName("org.postgresql.Driver"); param.put("user",user); param.put("password",pwd); c = DriverManager.getConnection(dbURL, param); st= c.createStatement(); System.out.println("Connected to database successfully"); rs = st.executeQuery("SELECT * FROM emp5"); while(rs.next()) { int eno= rs.getInt("EMPNO"); String name = rs.getNString("ename"); String job = rs.getNString("JOB"); int manager = rs.getInt("MGR"); Date date = rs.getDate("HIREDATE"); int salary = rs.getInt("SAL"); //int commision = rs.getInt("COMM"); int deptno = rs.getInt("DEPTNO"); System.out.println( "enpno " + eno+ "deptno " + deptno+ " name " + name +" JOB" + job +" manager " + manager + "hired" + date + "sal" + salary ); } } catch (SQLException ex) { ex.getErrorCode(); String message = ex.getMessage(); System.out.println(message); } finally { System.out.println("going through final block"); try { if (st== null || st.isClosed()) { } else { st.close(); } if (c != null && !c.isClosed()) { c.close(); } } catch (SQLException ex) { ex.getErrorCode(); ex.getMessage(); } } System.out.println("dis-Connected to database successfully"); // st.close(); con.commit();con.close(); } // main block ends here } |
Confirmed with PHP application:
|