jdbc connectivity through jsp
my code:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>hi to all</title>
</head>
<body>
Hi this is my page
<%
Connection conn = null;
String userName = "root";
String password = "";
String url = "jdbc:mysql://localhost/interviewer";
System.out.println(url);
System.out.println("username="+userName+", password=" +""+password);
Class.forName ("com.mysql.jdbc.Driver").newInstance ();//it shows error this line
conn = DriverManager.getConnection (url, userName, password);
Statement select = conn.createStatement();
ResultSet result = select.executeQuery ("SELECT username,password FROM login where login_id=212");
System.out.println("Got results:");
while(result.next()) { // process results one row at a time
String username = result.getString(1);
String pwd = result.getString(2);
System.out.println("userid = " +username );
System.out.println("password= " + pwd);
}
%>
</body>
</html>
______________________end of the code-----------------------------------------------
i got this error
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /mypage.jsp at line 20
17: String url = "jdbc:mysql://localhost/interviewer";
18: System.out.println(url);
19: System.out.println("username="+userName+", password=" +""+password);
20: Class.forName ("com.mysql.jdbc.Driver").newInstance ();
21: conn = DriverManager.getConnection (url, userName, password);
22: Statement select = conn.createStatement();
23: ResultSet result = select.executeQuery ("SELECT username,password FROM login where login_id=212");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840)
org.apache.jsp.mypage_jsp._jspService(mypage_jsp.java:105)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1701)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1546)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:169)
org.apache.jsp.mypage_jsp._jspService(mypage_jsp.java:83)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.25 logs.
Apache Tomcat/7.0.25
View Answers
February 24, 2012 at 5:23 PM
Ads
Related Tutorials/Questions & Answers:
jdbc connectivity through jsp
jdbc connectivity through jsp my code:
<%@ page language="java... = "";
String url = "
jdbc:mysql://localhost/interviewer...
org.apache.jasper.JasperException: An exception occurred processing
JSP page /mypage.jsp
Advertisements
JDBC CONNECTIVITY
file in environment variable.
Java Mysql
connectivity
Other
JDBC...
JDBC CONNECTIVITY How do i connect my database to java. I have the connector file and i place it in lib of jdk folder and installed the
jdbc driver
JDBC CONNECTIVITY
connectivity
Other
JDBC Tutorials...
JDBC CONNECTIVITY import java.sql.Connection;
import...");
con = DriverManager.getConnection("
jdbc:mysql://localhost:3306/abhi
jdbc connectivity
jdbc connectivity import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
public class NewJFramefin extends...=e.getActionCommand();
String check;
String str="
jdbc:odbc:dsn1
jdbc connectivity to mysql tutorial
jdbc connectivity to mysql tutorial here is complete
jdbc connectivity to mysql tutorial for newbies. Person who don't even know how to install mysql and don't know about which driver to use can do with ease
JDBC CONNECTIVITY - JDBC
JDBC CONNECTIVITY String jclass="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(jclass);
String dsn= "
Jdbc:Odbc:Employee";
Connection con... = con.prepareStatement("insert into detail values(?,?,?,?)");
I am a bigner in
Jdbc so please tell
jdbc oracle connectivity problem
jdbc oracle
connectivity problem Hi All,
I am trying to connect my swing application to oracle DB . but class.forname is giving error. Please suggest me if there is some different way to connect swing application to oracle
Java JSP - JDBC
Java JSP
JDBC connectivity in
JSP? Hi Friend,
Please visit the following link:
http://www.roseindia.net/
jsp/Accessingdatabase-fromJSP.shtml
Hope that it will be helpful for you.
Thanks
database through jsp
database
through jsp sir actually i want to retrieve the data from... are there in the database?
thanks
Here is an example of
jsp which retrieves data from...;%
Connection con = null;
String url = "
jdbc:mysql://localhost:3306/";
String db
JSP-Oracle connectivity
JSP-Oracle connectivity I have created a "dynamic web project" mainly with
jsp files in eclipse and now, want to connect with oracle 10g, so how can I proceed for the database connection
JDBC with JSP
JDBC with JSP how to get a combo box value and pass it to the java method in a
jsp program dynamically, without moving to servlet or next page
online database connectivity issue from JSP page .
online database
connectivity issue from
JSP page . Hi;
Everything working fine in localhost , but facing a simple problem in
connectivity... = DriverManager.getConnection("
jdbc:sqlserver://localhost:1433;"+"databaseName
online database connectivity issue from JSP page .
online database
connectivity issue from
JSP page . Hi;
Everything working fine in localhost , but facing a simple problem in
connectivity... = DriverManager.getConnection("
jdbc:sqlserver://localhost:1433;"+"databaseName=dorakoina
online database connectivity issue from JSP page .
online database
connectivity issue from
JSP page . Hi;
Everything working fine in localhost , but facing a simple problem in
connectivity... = DriverManager.getConnection("
jdbc:sqlserver://localhost:1433;"+"databaseName=dorakoina
database connectivity using jsp code
database
connectivity using
jsp code i have two tables employee...),'bbbb','bbbb'); so this syntax is possible to use in
jsp code
based on employee id ename and designation are displayed how it is possible in
jsp
employee
Jdbc connectivity by type 4 driver
Jdbc connectivity by type 4 driver I have done a code with database
connectivity with driver 4,it copiles,but while running it is showing...=DriverManager.getConnection("
jdbc:oracle:thin:@localhost:1521","system","123
JDBC-Odbc Connectivity
JDBC-ODBC
Connectivity
The code illustrates an example from
JDBC-ODBC
Connectivity. The code
helps you in retrieve the name and size of the column
jsp sql server 2005 connectivity
jsp sql server 2005 connectivity your
jsp mysql tutorial is very help full.Please tell me how to connect
jsp with SQL server 2005
jsp - JDBC
jsp i am doing project in java
using
jsp as font end and microsoft access as back end
my project airline ticketing reservations
how can i give hyperlink to database rows in
jsp code. First
Video Tutorial: How to access MySQL through JDBC?
How to access MySQL
through JDBC?
The interface that is used to access the Relational databases is called
JDBC or Java Database
connectivity. It can be used... of "How to Access MySQL
through JDBC?":
In the JAR selection window
jdbc-jsp
jdbc-jsp <html>
<head>
<title>your info mail</title>
</head>
<body bgcolor=#FAEBD7>
<center><u>... = DriverManager.getConnection("
jdbc:mysql://localhost:3306/test", "root", "root
accessing ms access through jsp
accessing ms access
through jsp i have 3 tables in my database employee,project,task
if i put employee id the search field .i should get details from other table
what all queries should i use in servlet file and i am using
How to sent mails through jsp application
How to sent mails
through jsp application when i fill the form, and submit it, then a mail should be sent to persons mentioned in the form and i want to conect the
jsp page to database
How to sent mails through jsp application
How to sent mails
through jsp application when i fill the form, and submit it, then a mail should be sent to persons mentioned in the form and i want to conect the
jsp page to database
How to sent mails through jsp application
How to sent mails
through jsp application when i fill the form, and submit it, then a mail should be sent to persons mentioned in the form and i want to conect the
jsp page to database