QuestionAsk Questions?
ikramlim
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();
}
}
View Answers
July 23, 2012 at 5:52 PM
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:
July 24, 2012 at 4:45 AM
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);
}
}
}
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
