I using netbeans to coonect.. why always error.. help pls.. thx
index.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <form name="f1" action="userdetail.java" method="get"> Username:<input type="text" name="uname"> Password:<input type="text" name="upass"> <input type="submit" value="Send"> </form> </body> </html> userdetail.java import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; Connection myConn=null; Statement myStmt=null; ResultSet myRs=null; protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try {Class.forName("com.mysql.jdbc.Driver").newInstance(); myConn=DriverManager.getConnection("jdbc.mysql://localhost:3306/Login/userdetail.java","root",""); myStmt=myConn.createStatement(); String query="select * from user"; myRs=myStmt.executeQuery(query); while(myRs.next()); { out.println("Username"+myRs.getString("uname")); out.println("Password"+myRs.getString("upass")); out.println("</br>"); } } catch(Exception e) { System.out.println("Exception"+e); } finally { try { myConn.close(); myStmt.close(); myRs.close(); } catch(Exception e) { System.out.println("Exception from finally"+e); } out.close(); } }
There were some mistakes in your code. We have modified your code.
Here it is:
1) index.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%> <html> <head> <title>JSP Page</title> </head> <body> <form name="f1" action="../userdetail" method="post"> <pre> Username:<input type="text" name="uname"> Password:<input type="text" name="upass"> <input type="submit" value="Send"> </pre> </form> </body> </html>
2) userdetail.java
import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class LoginServlet extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String user=request.getParameter("uname"); String pass=request.getParameter("upass"); try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection myConn=DriverManager.getConnection("jdbc.mysql://localhost:3306/Login ","root","root"); Statement myStmt=myConn.createStatement(); String query="select * from user where username='"+user+"' and password='"+pass+"'"; ResultSet myRs=myStmt.executeQuery(query); if(myRs.next()); { out.println("Welcome "+user); } } catch(Exception e) { System.out.println("Exception"+e); } } }
In the above code, Login should be your database name and user should
be your table name.
For more information, visit the following link:
same can't to run.. error also please help.. index.jsp <%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <form name="f1" action="userdetail.java" method="post"> <pre> Username:<input type="text" name="uname"> Password:<input type="text" name="upass"> <input type="submit" value="Send"> </pre> </form> </body> </html> **userdetail.java** (server I'm using wamp server to connect. add library - MySQL JDBC Driver-mysql-connector-java-5.1.13-bin.jar - apache tomcat In the services, in NetBeans IDE already at server -jdbc:mysql://localhost:3306/userdetail[root on Default schema import java.io.*; import java.net.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; @WebServlet(name = "userdetail", urlPatterns = {"/userdetail"}) public class userdetail extends HttpServlet { public class LoginServlet extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String user=request.getParameter("uname"); String pass=request.getParameter("upass"); try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection myConn=DriverManager.getConnection("jdbc.mysql://localhost:3306/Login","root","root"); Statement myStmt=myConn.createStatement(); String query="select * from user where username='"+user+"' and password='"+pass+"'"; ResultSet myRs=myStmt.executeQuery(query); if(myRs.next()); { out.println("Welcome "+user); } } catch(Exception e) { System.out.println("Exception"+e); } } }
Ads