Java og MySql
HJÆLP!!! Jeg forstår ikke hvad som går galt. Jeg har en klasse som ser således udimport java.sql.*;
public class Databaseforbindelsemysql
{
private Connection conn ;
private Statement stmt;
public Databaseforbindelsemysql(String data, String driver)
{
try
{
Class.forName(driver);
conn = DriverManager.getConnection(data, \"\", \"\");
stmt = conn.createStatement();
}
catch(Exception s)
{
System.out.println(\"SQL dataforbindelse fejlede\");
}
}
public ResultSet select(String sql)
{
ResultSet r = null;
try
{
r = stmt.executeQuery(sql);
}
catch(SQLException s)
{
System.out.println(\"Select fejlede: \"+s);
}
return r;
}
public void insertUpdate(String sql)
{
try
{
stmt.executeUpdate(sql);
}
catch(SQLException s)
{
System.out.println(\"update/insert fejlede\");
}
}
public void close()
{
try
{
stmt.close();
}
catch(SQLException s)
{
System.out.println(\"Close fejlede\");
}
}
}
som jeg kalder fra en anden klasse som ser således ud
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Opslagstavle extends HttpServlet
{
public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
String baggrund;
String tabelfarve;
baggrund = request.getParameter (\"tbfarve\");
tabelfarve = request.getParameter (\"tfarve\");
if(baggrund==null)
{
baggrund=\"ff0000\";
}
if(tabelfarve==null)
{
tabelfarve=\"ffffff\";
}
response.setContentType(\"text/html\");
out = response.getWriter();
Databaseforbindelsemysql d = new Databaseforbindelsemysql(\"jdbc:mysql:mikmak.dyndns.dk/web?user=mik&password=mik\",
\"org.gjt.mm.mysql.Driver\");
try {
out.println(\"<HTML><HEAD><TITLE>\");
out.println(\"</TITLE></HEAD><BODY \"+baggrund+\">\");
out.println(\"<table width=\'860\'>\");
out.println(\"<tr><td valign=\'top\'>\");
out.println(\"<table border=\'1\' width=\'780\' cellspacing=\'0\' cellpadding=\'0\' \"+tabelfarve+\">\");
out.println(\"<THEAD><TR><TH>Besked fra</TH><TH>Beskeden</TH></TR></THEAD>\");
ResultSet rs = d.select(\"SELECT * FROM besked order by Id desc\");
while(rs.next()) {
String navn = rs.getString(2);
String besked = rs.getString(3);
out.println(\"<TR><TD>\"+navn+\"</TD><TD>\"+besked+\"</TD></TR>\");
}
d.close();
out.println(\"</table>\");
out.println(\"</td><td valign=\'top\'>\");
out.println(\"<table width=\'65\'>\");
out.println(\"<FORM ACTION=\'Opslagstavle\' METHOD=\'GET\'\");
out.println(\"<tr><td>\");
out.println(\"<p align=\'center\'>\");
out.println(\"Vælg\");
out.println(\"<br>\");
out.println(\"Baggrund\");
out.println(\"<br>\");
out.println(\"<SELECT NAME=\'tbfarve\' MULTIPLE SIZE=\'4\'>\");
out.println(\"<OPTION VALUE= bgcolor=\'#ff0000\'>Rød\");
out.println(\"<OPTION VALUE= bgcolor=\'#00ff00\'>Grøn\");
out.println(\"<OPTION VALUE= bgcolor=\'#0000ff\'>Blå\");
out.println(\"<OPTION VALUE= bgcolor=\'#ffffff\' selected>Hvid\");
out.println(\"<OPTION VALUE= background=\'http://mikmak.dyndns.dk:8080/mik/jpg-filer/earth01.gif\'>Ani\");
out.println(\"</SELECT>\");
out.println(\"<br>\");
out.println(\"Vælg\");
out.println(\"<br>\");
out.println(\"Tabelfarve\");
out.println(\"<br>\");
out.println(\"<SELECT NAME=\'tfarve\' MULTIPLE SIZE=\'4\'>\");
out.println(\"<OPTION VALUE= bgcolor=\'#ff0000\'>Rød\");
out.println(\"<OPTION VALUE= bgcolor=\'#00ff00\'>Grøn\");
out.println(\"<OPTION VALUE= bgcolor=\'#0000ff\'>Blå\");
out.println(\"<OPTION VALUE= bgcolor=\'#ffffff\' selected>Hvid\");
out.println(\"</SELECT>\");
out.println(\"</p>\");
out.println(\"<br>\");
out.println(\"<INPUT TYPE=\'submit\' VALUE=\'Opdater\'>\");
out.println(\"</td></tr>\");
out.println(\"</FORM></table>\");
out.println(\"</td></tr>\");
out.println(\"</td></tr>\");
out.println(\"</table></BODY></HTML>\");
} catch (SQLException s) {
out.println(\"<h3>SQL fejl: \" + s.toString() + \" \"
+ s.getErrorCode() + \" \" + s.getSQLState() + \"</h3>\");
}
out.close();
}
// public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
// {
// }
}
men forbindelsen bliver ikke oprettet. Er der noget galt med min kode, eller er det MySql som ikke er sat korrekt op
