- Beranda
- Programmer Forum
<ask><help>error di Java server page(JSP)
...
![hooligans46](https://s.kaskus.id/user/avatar/2011/03/26/avatar2747583_2.gif)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
TS
hooligans46
<ask><help>error di Java server page(JSP)
permisi agan2 para sesepuh programmer stuff ![Big Grin emoticon-Big Grin](https://s.kaskus.id/images/smilies/sumbangan/14.gif)
ane ada sedikit problem nih,jadi lagi belajar JSP(java server page) untuk form login yang kekoneksi dengan database
disini ane punya3 file "Login.jsp","doLogin.jsp", dan "welcome.jsp"
sumpah ane stuck banget,mohon koreksi +bantuannya gan![Big Grin emoticon-Big Grin](https://s.kaskus.id/images/smilies/sumbangan/14.gif)
Login.jsp
doLogin.jsp
welcome.jsp
ane ngerunning lewat maven,tapi pas masukin user sama password sesuai dengan database malah error![Busa emoticon-Busa](https://s.kaskus.id/images/smilies/sumbangan/q20.gif)
errornya
skema database
![Big Grin emoticon-Big Grin](https://s.kaskus.id/images/smilies/sumbangan/14.gif)
ane ada sedikit problem nih,jadi lagi belajar JSP(java server page) untuk form login yang kekoneksi dengan database
disini ane punya3 file "Login.jsp","doLogin.jsp", dan "welcome.jsp"
sumpah ane stuck banget,mohon koreksi +bantuannya gan
![Big Grin emoticon-Big Grin](https://s.kaskus.id/images/smilies/sumbangan/14.gif)
Login.jsp
Code:
<html>
<head>
[removed]
function ccheck()
{
uid=document.f1.uid.value;
cpass=document.f1.cpass.value;
if(uid=="" || uid==null)
{
alert("Plz. Enter Your User ID");
document.f1.uid.focus();
return false;
}
if(cpass=="" || cpass==null)
{
alert("Plz. Enter Your Password");
document.f1.cpass.focus();
return false;
}
return true;
}
[removed]
<title>Login Page in Jsp</title>
</head>
<body>
<h2>LOGIN PAGE IN JSP</h2>
<form id="f1" name="f1" action="doLogin.jsp" method="post">
<table>
<tr>
<td><b>User ID</b></td>
<td><input name="uid" type="text"/></td>
</tr>
<tr>
<td><b>Password</b></td>
<td><input name="cpass" type="password"/></td>
</tr>
<tr>
<td><input type="submit" value="Submit" /> </td>
<td><input type="reset" value="Reset" /></td>
</tr>
</table>
</form>
</body>
</html>
doLogin.jsp
Code:
<%@ page import="java.sql.*" %>
<%! String cid="",pass="";Connection con; %>
<%
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:8080/test","root","");
Statement stmt=con.createStatement();
ResultSet rs;
cid=request.getParameter("uid");
pass=request.getParameter("cpass");
//System.out.println("cid="+cid+" pass="+pass);
rs=stmt.executeQuery("select * from login where userid='"+cid+"' and password='"+pass+"' ");
if(rs.next())
{
session.setAttribute("scid",cid);
con.close();
response.sendRedirect("welcome.jsp");
}
else
{
%>
<html>
<body>
<h1>Invalid UserID or Password</h1>
<jsp:include page="login.html" />
<%
}
%>
</body>
</html>
welcome.jsp
Code:
<%@ page import="java.sql.*" %>
<%! String scid=""; %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Login Page</title>
</head>
<body>
<%
scid=(String)session.getAttribute("scid");
%>
<div id="welcome">
<h2><span>Welcome:::<strong><font color='Red'><%= scid %></font></strong></span></h2>
</div>
</body>
</html>
ane ngerunning lewat maven,tapi pas masukin user sama password sesuai dengan database malah error
![Busa emoticon-Busa](https://s.kaskus.id/images/smilies/sumbangan/q20.gif)
errornya
Spoiler for error:
skema database
Spoiler for database:
0
1.8K
11
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
![Programmer Forum](https://s.kaskus.id/r200x200/ficon/image-176.png)
Programmer Forum![KASKUS Official KASKUS Official](https://s.kaskus.id/kaskus-next/next-assets/images/icon-official-badge.svg)
20.2KThread•4.4KAnggota
Urutkan
Terlama
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya