Database Queries (ii)

1  Packagecom. Jdbc.proc;2 3 ImportJava.sql.*; 4 5  Public classpreparestatement {6     Private Static FinalString dbdriver = "Com.mysql.jdbc.Driver";7     Private Static FinalString Dburl = "JDBC:MYSQL://LOCALHOST:3306/MLDN";8     Private Static FinalString DBUSER = "root";9     Private Static FinalString dbpass = "root";Ten      Public Static voidMain (string[] args)throwsexception{ One          AConnection conn=NULL;  -PreparedStatement psmt=NULL;  -ResultSet rs=NULL;  the Class.forName (Dbdriver);  -              -conn =drivermanager.getconnection (Dburl, DBUSER, dbpass); -String sql= "Select Empno,ename" + "from emp" + "where empno=?";  +psmt=conn.preparestatement (SQL); -Psmt.setint (1, 123);  +                    Ars=psmt.executequery (); at          while(Rs.next ()) { -System.out.println (Rs.getint (1) + "---" +rs.getstring (2));  -         }  - rs.close (); - psmt.close (); - conn.close (); in          -     }  to}

Database Queries (ii)