Home
JAVA JDBC
A Complex Query
Here is a sample code to execute a complex query
import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.io.*; public class check extends HttpServlet { Connection com; String str,uid,pwd,stq; ResultSet rs; Statement st; boolean fnd; public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e){} try { PrintWriter pw = response.getWriter(); response.setContentType("text/html"); com=DriverManager.getConnection("jdbc:odbc:yahoo"); uid= request.getParameter("txtname"); pwd= request.getParameter("txtpassword"); st = com.createStatement(); stq="select *from userinfo"; rs = st.executeQuery(stq); while(rs.next()) { if(rs.getString("name").equals(uid)) if(rs.getString("password").equals(pwd)) { fnd=true; break; } else { fnd=false; } } if(fnd) { pw.println("<font color=gold><h2> You are Welcome </h2></font>"); } else { pw.println("<font color=red><h2> Invalid user name or password </h2></font>"); } st.close(); com.close(); pw.close(); } catch(SQLException se) { System.out.println(se); } } }
Previous
Next