Imam problem sa konektovanjem na MySQL bazu. Evo koda servleta, nasao sam ga na internetu i samo prepravio potrbne stvari:
Code:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.*;
import java.net.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Admin
*/
public class servlet extends HttpServlet {
public String getServletInfo(){
return "Servlet connects to MySQL database and displays result of a SELECT";
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException{
String loginUser = "root";
String loginPasswd = "";
String loginUrl = "jdbc:mysql://localhost:3306/baza2";
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><head><title>Konekcija</title></head>");
out.println("<body><h1>Citanje iz MySQL baze</h1>");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection dbcon = DriverManager.getConnection(loginUrl, loginUser, loginPasswd);
Statement statement = dbcon.createStatement();
String query = "SELECT * FROM tabela1";
ResultSet rs = statement.executeQuery(query);
out.println("<table>");
while (rs.next()){
String m_id = rs.getString("id");
String m_datum = rs.getString("datum");
String m_naslov = rs.getString("naslov");
String m_text = rs.getString("text");
out.println("<tr>");
out.println("<td>"+ m_id+"</td>");
out.println("<td>"+m_datum+"</td>");
out.println("<td>"+m_naslov+"</td>");
out.println("<td>"+m_text+"</td>"+"</tr>");
}
out.println("</table>");
rs.close();
statement.close();
dbcon.close();
}
catch (SQLException ex){
while(ex != null){
System.out.println("SQL Exeption"+ex.getMessage());
ex = ex.getNextException();
}
}
catch(java.lang.Exception ex){
out.println("<html>");
out.println("<head><title>");
out.println("Baza Greska");
out.println("</title></head><body>");
out.println("<p>SQL Error:");
out.println(ex.getMessage());
out.println("</p></body></html>");
return;
}
out.close();
}
}
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.*;
import java.net.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Admin
*/
public class servlet extends HttpServlet {
public String getServletInfo(){
return "Servlet connects to MySQL database and displays result of a SELECT";
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException{
String loginUser = "root";
String loginPasswd = "";
String loginUrl = "jdbc:mysql://localhost:3306/baza2";
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><head><title>Konekcija</title></head>");
out.println("<body><h1>Citanje iz MySQL baze</h1>");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection dbcon = DriverManager.getConnection(loginUrl, loginUser, loginPasswd);
Statement statement = dbcon.createStatement();
String query = "SELECT * FROM tabela1";
ResultSet rs = statement.executeQuery(query);
out.println("<table>");
while (rs.next()){
String m_id = rs.getString("id");
String m_datum = rs.getString("datum");
String m_naslov = rs.getString("naslov");
String m_text = rs.getString("text");
out.println("<tr>");
out.println("<td>"+ m_id+"</td>");
out.println("<td>"+m_datum+"</td>");
out.println("<td>"+m_naslov+"</td>");
out.println("<td>"+m_text+"</td>"+"</tr>");
}
out.println("</table>");
rs.close();
statement.close();
dbcon.close();
}
catch (SQLException ex){
while(ex != null){
System.out.println("SQL Exeption"+ex.getMessage());
ex = ex.getNextException();
}
}
catch(java.lang.Exception ex){
out.println("<html>");
out.println("<head><title>");
out.println("Baza Greska");
out.println("</title></head><body>");
out.println("<p>SQL Error:");
out.println(ex.getMessage());
out.println("</p></body></html>");
return;
}
out.close();
}
}
Kada startujem,servlet radi,i javi mi sledecu gresku: SQL Error: com.mysql.jdbc.Driver
Pogledao sam u NB, imam driver, uspeo sam iz samog NB da se povezem na bazu i da izvrsim SQL query. Tako da mislim da sam omanuo u kodu negde, a posto sam Java pocetnik, nadam se da mi necete uzeti za zlo...
U svakom slucaju hvala!
bolje je biti malo lud nego malo pametan