sorry for annoying, i am quite stupid in it.

<html>
<head>
<title>Welcome to the online Auction...</title></head>
<body>
 
 
<% try
 
{
 
	String strUsername = request.getParameter("username"); 
	String strPassword = request.getParameter("password"); 
	
	Class.forName ("mysql-connector-java-5.0.8-bin"); 
 
 	Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost/user.jsp,admin,admin");
 	
 	Statement myStatement = myConn.createStatement ();
 	
	String strSQL = "SELECT UserName,UserPwd from user where UserName="",UserPwd="";
	
 
	ResultSet myResult = myStatement.executeQuery(strSQL);
	
	String strUser = myResult.getString("UserName");
	String strPass = myResult.getString("Password");
	
	while(myResult.next())
    
    {
	
	if(strUsername.equals(strUser) && strPassword.equals(strPass))
	
                {
                    out.println("Login Successful!");
                }
                else
                {
                    out.println("Login Fail!");
                }
	
	}	
		
	myConn.close();
}
	catch(Exception e){} 
%>
			
</body> 
</html>

i am new to this.

Please help me with this.

my jar file name is mysql-connector-java-5.0.8-bin

Please help me out.

thanks

For once do not use JSP to connect to DB. JSP is for presentation and servlet is for logic. The order should be JSP collect data from user pass it on servlet. Servlet will validate data and if they correct it will attempt to connect to DB. If conection goes well DB operation is processed (insert/update/delete/chceck/retrieve) and servlet retrieve DB respond, after that servlet will either go to next page or return to previous

There is somewhere example how to do it that I posted about 2 years ago and it was recently re-open by somebody

can you show me some example for that...

i am too confuse with it

thanks

i saw ur code for the connection

public class SomeClassName extends HttpServlet
{
Connection conn;
Statement stmt;
	
public void init() throws ServletException
{
	try
	{
		Class.forName("com.mysql.jdbc.Driver").newInstance();
	}
	catch (Exception ex)
	{
		System.out.println("Exception is : " + ex.toString() );
	}
}
	
public void doPost( HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
	try
	{
		conn = DriverManager.getConnection("jdbc:mysql://localhost/processing.jsp"
			+ "visualogic?UserName=admin&UserPwd=admin");
		stmt = conn.createStatement();
	}
	catch(SQLException ex)
	{
		System.out.println("SQLException : " + ex.getMessage() );
	}public class SomeClassName extends HttpServlet
{
Connection conn;
Statement stmt;
	
public void init() throws ServletException
{
	try
	{
		Class.forName("com.mysql.jdbc.Driver").newInstance();
	}
	catch (Exception ex)
	{
		System.out.println("Exception is : " + ex.toString() );
	}
}
	
public void doPost( HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
	try
	{
		conn = DriverManager.getConnection("jdbc:mysql://localhost/processing.jsp" 
			+ "visualogic?UserName=admin&UserPwd=admin");
		stmt = conn.createStatement();
	}
	catch(SQLException ex)
	{
		System.out.println("SQLException : " + ex.getMessage() );
	}

am i doing right?
what file shall i save to?
.jsp or.....

Above example is servlet so it should ba save as java class

i get error for it
here is the error

org.apache.jasper.JasperException: /processing.jsp(1,17) quote symbol expected
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:88)
org.apache.jasper.compiler.Parser.parseAttribute(Parser.java:200)
org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:150)
org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:162)
org.apache.jasper.compiler.ParserController.getPageEncodingForJspSyntax(ParserController.java:451)
org.apache.jasper.compiler.ParserController.determineSyntaxAndEncoding(ParserController.java:392)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:173)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:153)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:294)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:281)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

Your connection string

conn = DriverManager.getConnection("jdbc:mysql://localhost/processing.jsp"
			+ "visualogic?UserName=admin&UserPwd=admin");

VS


my connection string

conn = DriverManager.getConnection("jdbc:mysql://localhost/" 						+ "database_name?user=my_username&password=my_password");

Can you explain me what is the purpose of processing.jsp in your code?

it is trying to get to authencate the username and password.

The "processing.jsp" is not supposed to be there. Connection string uses the database URL jdbc:mysql://localhost/ , database name database_name , database user name UserName=admin and password UserPwd=admin to establish connection with database.

Please read through these Java tutorials, just be aware they using Derby database instead of MySQL

hmm, not really understand it

sorry for annoying

Well then tell us what you do not understand

conn = DriverManager.getConnection("jdbc:mysql://localhost:8080/"
			+ "visualogic UserName=admin&UserPwd=admin");
conn = DriverManager.getConnection("jdbc:mysql://localhost/" 						+ "database_name?user=my_username&password=my_password");		conn = DriverManager.getConnection("jdbc:mysql://localhost/" 						+ "database_name?user=my_username&password=my_password");

Behind the localhost/ what shall i put?
and the database_name=my database name?
my_username&password=my database username and password?

This is correct

conn = DriverManager.getConnection("jdbc:mysql://localhost/"+ "visualogic UserName=admin&UserPwd=admin");

port number is only used when you connecting to IP address of server, however as DB is on local machine the keyword "localhost" is used. Secondly 8080 is port for Tomcat not for database

oh, let me try it again

thanks

another question, after i wrote this code

public class SomeClassName extends HttpServlet
{
Connection conn;
Statement stmt;
	
public void init() throws ServletException
{
	try
	{
		Class.forName("com.mysql.jdbc.Driver").newInstance();
	}
	catch (Exception ex)
	{
		System.out.println("Exception is : " + ex.toString() );
	}
}
	
public void doPost( HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
	try
	{
		conn = DriverManager.getConnection("jdbc:mysql://localhost:/"
			+ "visualogic UserName=admin&UserPwd=admin");
		stmt = conn.createStatement();
	}
	catch(SQLException ex)
	{
		System.out.println("SQLException : " + ex.getMessage() );
	}public class SomeClassName extends HttpServlet
{

what shall i do?

or can i use this code

<%@page import=java.util.*"%>
<jsp:useBean id="idhandler" class="authenticate.login"scope="request">
<jsp:setProperty name="idhandler" property="*"/>
</jsp:useBean>
<%
	if(idhandler.authenticate()){
%>
<jsp:forward page="details.jsp"/>
<% }
else{ %>
<jsp:forward page="error.jsp"/>
<% } %>
package authenticate;
import java.sql.*;
public class Login{
private String username="";
private String password="";
public Login(){
}
public void setUsername(String username){
this.username=username;
}

public void setPassword(String password){
this.password=password;
}

piblic String getUsername()
{
	return username;
}

public String getPassword()
{
	return password;
}

public boolean authenticate(){
String query="select * from user;";
String DbUserName;
String DbUserPwd;
try{
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:/"+ "visualogic UserName=admin&UserPwd=admin");
	Statement st=con.createStatement();
	ResultSet rs=st.executeQuery(query);

while(rs.next()){
DbUsername=rs.getString("username");
System.out.println("username:"+DbUserName);
System.out.println("Entered user name:"+username);
DbUserPwd=rs.getString("Password");
System.out.println("Password="+DbUserPwd);
System.out.println("Entered password:"+password);
if(username.equals(DbUserName) && password.equals(DbUserPwd))
{
	return true;
}
}
}catch(Exception e){
e.printStackTrace();
}
return false;
}
}

Use the first code, the second one is a bad practice.

To your question what should you do with first code. This code is general bridge to setup connection, before this you should collect some data from the form and now you would try to put them in DB or somebody just pressed one of the buttons that has functionality based on some sort of DB communication (get total sum for monthly income in shop for example). So JSP provide input and pass it on the servlet from which you have the opening part. Servlet does form validation if neccesary, proces or retrieve data from DB and provide appropriate re-direction to next JSP (usualy).

Read the tutorials which I gave you link and apply that to what you already got. Also you may want to look at this too

kid's still insisting on doing database access from JSP.
Maybe if it would stop trying that it would get somewhere...

Jwenting, thanks for the advise.
I get the second part from another site. :)

lets me try it again

thanks alot

let see this
user login page

<html>
<head>
<title>User Login Page</title>
<body>
<h2><center>Visualogic </center></h2><br>
<b>
<center><form name="form" method="post" action="????????">
	Username: <input type="text"name="username" value=""><br><br>
	
	Password: <input type="password" name="password" value=""><br><p></p>
	
	<input type="submit" name="Submit" value="Login">
	
	<input type="reset" name="Reset" value="Reset"><br><p></p></center>
</form> 
</body>
</html>

connector.java

import java.sql.*;
public class SomeClassName extends HttpServlet
{
Connection conn;
Statement stmt;
	
public void init() throws ServletException
{
	try
	{
		Class.forName("com.mysql.jdbc.Driver").newInstance();
	}
	catch (Exception ex)
	{
		System.out.println("Exception is : " + ex.toString() );
	}
}
	
public void doPost( HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
	try
	{
		conn = DriverManager.getConnection("jdbc:mysql://localhost:/"
			+ "visualogic UserName=admin&UserPwd=admin");
		stmt = conn.createStatement();
	}
	catch(SQLException ex)
	{
		System.out.println("SQLException : " + ex.getMessage() );
	}public class SomeClassName extends HttpServlet
{

for the form action, do i set it as connection.java so that when the user login , the data will validate it from the database?

Action requere direction (file name) where to go next so it can look like this

action="http://localhost:8080/ProjectDirectoryName/servlet/NameOfServletWithoutExtension"

, there is advanced way how to work with action element but for that you would have to know something about servlet mapping so leave it for now.
So now on submit button click you go to your servlet, that will initialize connection string, you should retrive values from JSP, validate them and then open connection to DB and do what ever you need. After that do not forget to close conection to DB and redirect process flow to appropriate page.
Note: Validation is part of your job, you have to design it.

What is exactly ur problem..which one r u using java/jsp?

jsp
peter_budo , thanks for the advise

if i have another question, i will post it in here

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.