Mohammed Thanveer
What is the error in this coding?
0 Answer(s)      4 years and 3 months ago
Posted in : JDBC

<% Class.forName("com.ibm.db2.jcc.DB2Driver"); System.out.println("driver loaded sucesssssssssssssssssss"); Connection Conn=DriverManager.getConnection("jdbc:db2://localhost:50000/VOTERS","db2admin","friends"); String Login_name=request.getParameter("Login Id"); String Password_id=request.getParameter("Password"); PreparedStatement Stmt=Conn.prepareStatement("SELECT NAME FROM
LOGINDETAILS WHERE LOGIN ID='"+Loginname+"' AND PASSWORD='"+Password_id+"'"); System.out.println("Statement loaded sucesssssssssssssssssss"); Stmt.executeQuery(); ResultSet rs=Stmt.getResultSet(); System.out.println("query execute loaded sucesssssssssssssssssss"); String name= null; while(rs.next()) { Login=rs.getString(1); } rs.close();Stmt.close();Conn.close(); if(name != null) out.println("Welcome to "+login); else out.println("Please check your Login Id and Password..."); %>

Advertisement
View Answers