Forum:

JSP code Error

Greenhorn

Posts: 5

posted 2 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<style>
/* Style the body */
body 
{
  font-family: Comic Sans MS;
  margin: 0;
}
.header 
{
  padding: 5px;
  text-align: center;
  background: #1abc9c;
  color: white;
  font-size: 20px;
}
/* For mobile phones: */
[class*="col-"] 
{
  width: 100%;
}
@media only screen and (min-width: 600px) 
{
  /* For tablets: */
  .col-s-1 {width: 8.33%;}
  .col-s-2 {width: 16.66%;}
  .col-s-3 {width: 25%;}
  .col-s-4 {width: 33.33%;}
  .col-s-5 {width: 41.66%;}
  .col-s-6 {width: 50%;}
  .col-s-7 {width: 58.33%;}
  .col-s-8 {width: 66.66%;}
  .col-s-9 {width: 75%;}
  .col-s-10 {width: 83.33%;}
  .col-s-11 {width: 91.66%;}
  .col-s-12 {width: 100%;}
}
@media only screen and (min-width: 768px) 
{
  /* For desktop: */
  .col-1 {width: 8.33%;}
  .col-2 {width: 16.66%;}
  .col-3 {width: 25%;}
  .col-4 {width: 33.33%;}
  .col-5 {width: 41.66%;}
  .col-6 {width: 50%;}
  .col-7 {width: 58.33%;}
  .col-8 {width: 66.66%;}
  .col-9 {width: 75%;}
  .col-10 {width: 83.33%;}
  .col-11 {width: 91.66%;}
  .col-12 {width: 100%;}
}
.content {
  max-width: 1800px;
  margin: auto;
  background: white;
}
.button {
  width: 105px;
  height: 30px;
  background-color: #008CBA;
  border: none;
  color: white;
  text-align: center;
  text-decoration: none;
  display: inline-block;
  font-size: 14px;
  margin: 4px 2px;
  cursor: pointer;
}
.ex1 {
  margin: 200px 120px;
}

</style>
</head>
<body>
<div class="header">
  <h1>Report Table is given below..
</div>

<%@page import = "java.sql.DriverManager,java.sql.Connection,java.sql.Statement,java.sql.ResultSet,java.sql.SQLException, java.util.Vector" %>
   <%
      Statement stmt = null;
      Connection con = null;
      ResultSet rsT = null;

boolean errFlag = false;
      String str = null;
      
      String sdbName, sregion,sregion1,sregion2,
      sdbName = request.getParameter("scaleup");
	  sregion = request.getParameter("region");
	  sregion1 = request.getParameter("region1");
	  sregion2 = request.getParameter("region2");
     	  
	  int result=0;
      
      try
      {
         Class.forName("com.mysql.jdbc.Driver");
         con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/" + sdbName,"root","");
         stmt = con.createStatement();
       
		//System.out.println("select * from scaleupdata where sregion= '" + region + "' and sregion1='" + region1 + "' and sregion2='" + region2 + "'");		   
		rsT = stmt.executeQuery("select * from scaleupdata where sregion= '" + region + "' and sregion1='" + region1 + "' and sregion2='" + region2 + "'");
		
		if(rsT.next())
		{
			result=0;
			result= rsT.getInt(1);
			result= rsT.getInt(2);
			result= rsT.getInt(3);
			
			<table border='1'>
			<tr>
			<th>region</th>
			<th>region1</th>
			<th>region2</th>
			</tr>
			<tr>
			<td><%result=rst.getInt(1);%></td>
			<td><%result=rst.getInt(2);%></td>
			<td><%result=rst.getInt(3);%></td>
			</tr>
			</table>
				
		}		
		rsT.close();
		
		System.out.println("result  "+result);
		
		if(result==1)
		{
			str = "<center><h2>You Have Entered Invalid details</h2></center>";
			        
		}
		 else 
			{
				
			%><jsp:forward page="Login.jsp"/>;<%
				
			} 
			
        stmt = null;
        con = null;
        rsT = null;
      }
      catch(SQLException sqle)
      {
         str = "<h2>Error : " + sqle + "</h2>";	
	       errFlag = true;
      }
%>

</body>
</html>

Nmohamed rafi

Greenhorn

Posts: 5

posted 2 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Here i want to display 3rows of mysql table in output. it shows 7errors how to solve this error? please tell how to reactify the error. i am having 7 errors, i want to show mysql table. i need correct mysql query

Nmohamed rafi

Greenhorn

Posts: 5

posted 2 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

These are the 7 code errors

Generated servlet error:
[javac] Since fork is true, ignoring compiler setting.
[javac] Compiling 1 source file
[javac] Since fork is true, ignoring compiler setting.
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:91: illegal start of expression
[javac]
[javac] ^
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:68: sdbName is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
[javac] sdbName = request.getParameter("scaleup");
[javac] ^
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:82: cannot resolve symbol
[javac] symbol : variable region
[javac] location: class org.apache.jsp.report_jsp
[javac] rsT = stmt.executeQuery("select * from scaleupdata where sregion= '" + region + "' and sregion1='" + region1 + "' and sregion2='" + region2 + "'");
[javac] ^
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:82: cannot resolve symbol
[javac] symbol : variable region1
[javac] location: class org.apache.jsp.report_jsp
[javac] rsT = stmt.executeQuery("select * from scaleupdata where sregion= '" + region + "' and sregion1='" + region1 + "' and sregion2='" + region2 + "'");
[javac] ^
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:82: cannot resolve symbol
[javac] symbol : variable region2
[javac] location: class org.apache.jsp.report_jsp
[javac] rsT = stmt.executeQuery("select * from scaleupdata where sregion= '" + region + "' and sregion1='" + region1 + "' and sregion2='" + region2 + "'");
[javac] ^
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:101: cannot resolve symbol
[javac] symbol : variable rst
[javac] location: class org.apache.jsp.report_jsp
[javac] result=rst.getInt(2);
[javac] ^
[javac] C:\Program Files (x86)\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\SCALEUP\report_jsp.java:104: cannot resolve symbol
[javac] symbol : variable rst
[javac] location: class org.apache.jsp.report_jsp
[javac] result=rst.getInt(3);
[javac] ^
[javac] 7 errors

Tim Holloway

Saloon Keeper

Posts: 28822

212

I like...

posted 2 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Your primary error is that you put a lot of Java code in a JSP.

Scriptlets are a very obsolete thing. They are virtually impossible to debug and the mix of 2 very different kinds of languages in the same file drives text editors insane.

You should move your Java code into a servlet, have the servlet store its results into Request-scope javabeans, then forward to the JSP to do the display.

JSPs are very good for templating web pages, but are really awful for processing code.

Experience keeps a dear School, but Fools will learn in no other.
---
Benjamin Franklin - Postal official and Weather observer

Al Hobbs

Bartender

Posts: 669

I like...

posted 2 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Even if you are putting the java code in the JSP it still follows the same rules as any other java. The error messages you posted contain the reason why it doesn't compile.

Are you okay? You look a little big. Maybe this tiny ad will help:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders