this is my
test project so i can open a database connection
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Connection extends HttpServlet
{
Connection con;
public void init()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
String conne = "jdbc:mysql://localhost/e_store";
con = DriverManager.getConnection(conne);
}
catch (ClassNotFoundException e)
{
log("Couldn't find mm.mysql driver");
}
catch (SQLException e)
{
log("Sql Exception while connecting to MySQL",e);
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
response.setContentType("text/html;charset=ISO-8859-7");
PrintWriter out = response.getWriter();
if (con!=null)
{
out.println("Sindethika epituxos");
out.println("<br> Onomata stin Basi Dedomenod:");
try
{
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("show tables;");
while (rs.next())
{
String tableName = rs.getString(1);
out.println("<br> + tableName");
}
}
catch (SQLException e)
{
log("SQL Exception",e);
}
}
else
{
out.println("Den mporesa na syndetho me tin BD");
}
}
public void destroy()
{
if (con!=null)
{
try
{
con.close();
}
catch (SQLException e)
{
log("Couldn't close Connection",e);
}
}
}
}