username and mysql

[javacuriousity]

i am pretty new to java and have an application, i need it to be able to get values entered in a java form (username and password) and compare it to data in the mysql table, if it matches then let the user in, if not then generate a user error message..... can anybody help me with this???

the names of the textfield is username_textField, and password field is passwordField.

[hirak1984]

post the code you have tried.we will fix the code if there is error.

If you didnt start yet,grab a HEAD FIRST WITH JAVA book and start reading it.You will be able to make the application yourself.
Good Luck

i am pretty new to java and have an application, i need it to be able to get values entered in a java form (username and password) and compare it to data in the mysql table, if it matches then let the user in, if not then generate a user error message..... can anybody help me with this???

the names of the textfield is username_textField, and password field is passwordField.

[r035198x]

i am pretty new to java and have an application, i need it to be able to get values entered in a java form (username and password) and compare it to data in the mysql table, if it matches then let the user in, if not then generate a user error message..... can anybody help me with this???

the names of the textfield is username_textField, and password field is passwordField.

Can you connect to the database using jdbc? If you don't know how to do that you might want to have a look at a jdbc tutorial first.

[hirak1984]

I dont think connecting to database will be wise at this satge.

first make the page.see if that is working well ,check with hardcoded values.
then go for backend works.

Can you connect to the database using jdbc? If you don't know how to do that you might want to have a look at a jdbc tutorial first.

[ramusunny]

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class LoginServlet extends HttpServlet
{ Connection con;
Statement st;
ResultSet rs;
public void init()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin: @localhost:1521:oracleex","scott","tiger");
st=con.createStatement();
}
catch (Exception e)
{
e.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
try{
PrintWriter out=res.getWriter();
String H_username=req.getParameter("username");
String H_password=req.getParameter("Password");
st=con.createStatement();
rs=st.executeQuery("select * from THospital_login where H_username='"+H_username+"' and H_password='"+H_password+"'");
out.print("the given values are:"+H_username+H_password);
if(rs.next())
{
out.print("<center>");
out.print("<B>validuser<B>");
out.print("</center>");

}
else
{
out.print("<center>");
out.print("invaliduser");
out.print("</center>");
}
}
catch(Exception e1)
{
e1.printStackTrace();
}
}

public void destroy(){
try
{
System.out.println("destroy the connection");;
}
catch (Exception e2)
{
e2.printStackTrace();
}
}
}

[ramusunny]

this above program is suitble to what ever seiing the table just u can create the table..n..enjoyyyyyyyyyy..thats it..my e-mail address is <email:Removed>...do u have any doubts plz ask..i can improve my skills .......thanku .......bye