I have this problem :
I have installed mm.mysql driver ( jar file )
in :
C:\tomcat4\lib
c:\tomcat4\webapps\Root\WEB-INF\lib\
c:\jdk1.3.1\lib\jre\ext
c:\tomcat4\common\lib
I have run this code , previous I have succeded run this program, but now it
show error :
javax.servlet.ServletException: No suitable driver
The CODES :
<%@ page language="java" import="java.sql.*" %>
<%
ResultSet myResultSet=null;
Class.forName("org.gjt.mm.mysql.Driver");
Connection
myConn=DriverManager.getConnection("jdbc:mysql:3306://localhost/bukujsp?user
=root&password=ganteng");
Statement stmt=myConn.createStatement();
String kueri="INSERT INTO buku(isbn,judul,pengarang,penerbit,tahunterbit)
VALUES('9792023526','Belajar Sendiri Pemrograman PHP', 'M.Farid Aziz', 'Elex
Media Komputindo', '2001')";
int isitabel=stmt.executeUpdate(kueri);
%>
<html>
<head>
<title>Membuat Tabel Buku dengan JSP</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
if (isitabel==1){
out.println("<h2>Penambahan Data pada Tabel Berhasil</h2><br>");
out.println("Kueri yang dilakukan :"+kueri);
}
else
{
out.println("Penambahan Data Gagal");
}
stmt.close();
myConn.close();
%>
</body>
</html>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
