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);
}
}
}