Re: Connection to mysql using jsp/jdbc
Posted by:
raj kris
Date: December 14, 2007 01:11AM
<HTML>
<HEAD>
<%@ PAGE import="java.io.*" import="java.lang.*" import="java.sql.*" %>
<TITLE>JSP Example 2</TITLE>
</HEAD>
<BODY>
<H1>JSP Example 3</H1>
<%
String uid, upwd, dpwd ;
Connection conn;
ResultSet results;
PreparedStatement sql;
try
{
Class.forname("org.gjt.mm.mysql.driver").newInstance();
TRY
{
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:8080/visitor","","admin");
uid = request.getParameter("userId");
upwd = request.getParameter("password");
sql = conn.prepareStatement("SELECT Password FROM login WHERE UseId = '" + uid + "'");
results = sql.executeQuery();
dpwd = results.getString(Password);
if(upwd==dpwd)
{
}
else
{
out.println("Invalid Username or Password");
}
}
catch (SQLException s)
{
out.println("SQL Error<br>");
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>
</BODY>
</HTML>
error
org.apache.jasper.JasperException: /dbconnect.jsp(3,4) Invalid directive
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.parseDirective(Parser.java:516)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1557)
org.apache.jasper.compiler.Parser.parse(Parser.java:127)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:212)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:101)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:156)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:296)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
please help me...........
Subject
Written By
Posted
November 15, 2006 04:20AM
November 15, 2006 10:57AM
November 27, 2005 05:27AM
September 24, 2006 09:39AM
September 24, 2006 10:26AM
December 27, 2007 11:53PM
December 31, 2007 09:54PM
February 15, 2006 12:12AM
February 19, 2006 11:57PM
February 20, 2006 01:46AM
Re: Connection to mysql using jsp/jdbc
December 14, 2007 01:11AM
February 20, 2006 12:20AM
November 15, 2006 04:15AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.