Comment
suyoh
sql error , dsn at webapp with name emploee,
September 15, 2007 at 12:06 PM
September 15, 2007 at 12:06 PM
<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 place;
Connection dbconn;
ResultSet results;
PreparedStatement sql;
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
try
{
int latitude,longitude,easting,northing;
boolean doneheading = false;
out.println("Suyog before connection");
dbconn = DriverManager.getConnection("jdbc:mysql::/localhost:8080/LA/employee","","");
out.println("Suyog database");
// place = request.getParameter("place");
sql = dbconn.prepareStatement("SELECT * FROM employee");
results = sql.executeQuery();
while(results.next())
{
if(! doneheading)
{
out.println("<table border=2>");
doneheading = true;
}
latitude = results.getInt("latitude");
longitude = results.getInt("longitude");
easting = results.getInt("easting");
northing = results.getInt("northing");
out.println("<tr><td>" + latitude);
out.println("<td>" + longitude);
out.println("<td>" + easting);
out.println("<td>" + northing);
}
if(doneheading)
{
out.println("</table>");
}
else
{
out.println("No matches for ");
}
}
catch (SQLException s)
{
out.println("SQL Error<br>");
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>
</body>
</html>
View All Comments | View Tutorial
<head>
<%@ page
import = "java.io.*"
import = "java.lang.*"
import = "java.sql.*"
%>
<title>
JSP Example 2
</title>
</head>
<body>
<h1>JSP Example 3</h1>
<%
String place;
Connection dbconn;
ResultSet results;
PreparedStatement sql;
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
try
{
int latitude,longitude,easting,northing;
boolean doneheading = false;
out.println("Suyog before connection");
dbconn = DriverManager.getConnection("jdbc:mysql::/localhost:8080/LA/employee","","");
out.println("Suyog database");
// place = request.getParameter("place");
sql = dbconn.prepareStatement("SELECT * FROM employee");
results = sql.executeQuery();
while(results.next())
{
if(! doneheading)
{
out.println("<table border=2>");
doneheading = true;
}
latitude = results.getInt("latitude");
longitude = results.getInt("longitude");
easting = results.getInt("easting");
northing = results.getInt("northing");
out.println("<tr><td>" + latitude);
out.println("<td>" + longitude);
out.println("<td>" + easting);
out.println("<td>" + northing);
}
if(doneheading)
{
out.println("</table>");
}
else
{
out.println("No matches for ");
}
}
catch (SQLException s)
{
out.println("SQL Error<br>");
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>
</body>
</html>
View All Comments | View Tutorial
Related Tutorial and Articles
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
