Whats wrong? JSP in netbeans?

nithinks · 06-03-2007, 11:23 PM

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<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 dbconn;
ResultSet results;
PreparedStatement sql;
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
try
{

dbconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/project","root","");
uid = request.getParameter("nme");
upwd = request.getParameter("pwd");
sql = dbconn.prepareStatement("SELECT anm FROM login WHERE nm='"+uid+"'");

results = sql.executeQuery();
dpwd="admin";
dpwd = results.getString("anm");

%>
<p><%= dpwd%></p>
<%
}catch (SQLException s)
{
out.println("SQL Error<br>");
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>

</BODY>
</HTML>
------------------------------------------
The above program gives SQL exception why? can you give me the corrected code?

::cyborg:: · 07-03-2007, 12:24 AM

write down system before the "out.println"

nithinks · 07-03-2007, 06:38 AM

no.. not working...

planetcall · 07-03-2007, 09:40 AM

I am not into JSP but I can see that in the exception block you are throwing a custom string. I would suggest you rather print out the Exception message and Stack Trace instead of printing "SQL Exception". I hope that will give you greater insight of what is happening.

nithinks · 07-03-2007, 11:10 PM

im getting error for using "where" any way to solve this?
__________
problem solved.. i used LIKE instead of = near 'where'

planetcall · 08-03-2007, 12:05 AM

its good you did it yourself. Always remember that Exceptions are meant not just to throw a custom string but they are powerful tools for showing you the precise information about the error/crash.

Desi-Tek.com · 08-03-2007, 05:08 AM

u r mixing business logic with presentation? this is not good

Code:

 
<HTML>
<HEAD>
<%@ page import="java.sql.*" %>
<TITLE>JSP Example 2</TITLE>
</HEAD>
<BODY>
<H1>JSP Example 3</H1>
<%
  String uid, upwd, dpwd;
  String Connection = dbconn;
  String ResultSet = results;
  String PreparedStatement = sql;
  try {
    Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    dbconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/project", "root", "");
    uid = request.getParameter("nme");
    upwd = request.getParameter("pwd");
    sql = dbconn.prepareStatement("SELECT anm FROM login WHERE nm='" + uid + "'");
    results = sql.executeQuery();
    dpwd = "admin";
    dpwd = results.getString("anm");
%>
<p><%= dpwd%></p>
<%
  } catch (SQLException s) {
    out.println("SQL Error<br>");
  }
  catch (ClassNotFoundException err) {
    out.println("Class loading error");
  }
  }
%>
</BODY>
</HTML>

Popular Categories

Popular Articles

Content Categories

Sister Sites

Follow Us

Facebook Channels

Digit Magazine