QuestionAsk Questions?
sreenivasa
What is the full form of JSP?
View Answers
April 29, 2008 at 7:55 PM
Hi friend,
<%@ page language ="java" import="java.sql.*" %>
<html>
<body>
<form name="f1" method="post">
<table border="1" bgcolor="pink">
<tr>
<td>User Name</td><td><input type="text" name="username" ></td>
</tr>
<td>Password</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submit" value="LogIn"></td>
</tr>
</table>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
String user=request.getParameter("username");
String pass=request.getParameter("password");
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select username,password from userlogin");
while(rs.next()){
String username=rs.getString(1);
String password=rs.getString(2);
if(user.equals(username) && pass.equals(password)){
%>
<jsp:forward page="/LoginSuccess.jsp" />
<%}
else
out.println("Login Failed,Please try Againe");
%>
<%}
}
catch(Exception e){
System.out.println(e);
}
%>
</form>
</body>
</html>
----------------------------
read for more information,
http://www.roseindia.net/jsp/
<%@ page language ="java" import="java.sql.*" %>
<html>
<body>
<form name="f1" method="post">
<table border="1" bgcolor="pink">
<tr>
<td>User Name</td><td><input type="text" name="username" ></td>
</tr>
<td>Password</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submit" value="LogIn"></td>
</tr>
</table>
<%
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
String user=request.getParameter("username");
String pass=request.getParameter("password");
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select username,password from userlogin");
while(rs.next()){
String username=rs.getString(1);
String password=rs.getString(2);
if(user.equals(username) && pass.equals(password)){
%>
<jsp:forward page="/LoginSuccess.jsp" />
<%}
else
out.println("Login Failed,Please try Againe");
%>
<%}
}
catch(Exception e){
System.out.println(e);
}
%>
</form>
</body>
</html>
----------------------------
read for more information,
http://www.roseindia.net/jsp/
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
