Database connection problem

hi,

i have a database connection to MySQL with jsp. The error massage i get is :

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver [org.gjt.mm.mysql.Driver]
Click to expand...

what must i do to fix this problem?

the code is :

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>veritabani baglantisi</title>
</head>

<body>
<h2>JSP ile veritabani baglantisi</h2>
<h3>Uye bilgileri</h3>
<%
Connection connection = null;
Statement statement = null;
ResultSet SonucVeriler = null;

try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
}catch(ClassNotFoundException ce){out.println(ce);}

try{
connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1/uyelik","root","******");
statement = connection.createStatement();
SonucVeriler = statement.executeQuery("SELECT * FROM UYELER");

%>

<table cellpadding="4">
<tr bgcolor="#bbbbbb">
<td width="60"><b>kullanici adi</b></td>
<td width="60"><b>Sifre</b></td>
<td width="60"><b>Ad</b></td>
<td width="60"><b>Soyad</b></td>
<td width="60"><b>Telefon</b></td>
<td width="60"><b>Cep Telefonu</b></td>
<td width="60"><b>Adres</b></td>
<td width="60"><b>Ulasim Adresi</b></td>
<td width="60"><b>Adres Tarifi</b></td>
</tr>

<%
int modul = 1;
String fonRengi;
while(SonucVeriler.next())
{
if((modul%2)==1) fonRengi="#dddddd";
else fonRengi="#eeeeee";
%>

<tr bgcolor="<%=fonRengi %>">
<td><%= SonucVeriler.getString("ka") %></td>
<td><%= SonucVeriler.getString("Sifre") %></td>
<td><%= SonucVeriler.getString("Ad") %></td>
<td><%= SonucVeriler.getString("Soyad") %></td>
<td><%= SonucVeriler.getString("Telefon") %></td>
<td><%= SonucVeriler.getString("Cep") %></td>
<td><%= SonucVeriler.getString("Adres") %></td>
<td><%= SonucVeriler.getString("Ul_adresi") %></td>
<td><%= SonucVeriler.getString("Adres_tar") %></td>
</tr>

<% modul++;
}
SonucVeriler.close();
statement.close();
}catch(SQLException exception){
out.println("<!--");}
%>
</table>
</body>
</html>
Click to expand...

thanks

Log in or Sign up

Database connection problem

asoyletir Peon

mad4 Peon

Log in or Sign up

Database connection problem

asoyletir Peon

mad4 Peon

Useful Searches