Hvad går galt her.......................når ikke længere end til System.out.println("Test 1");
package opg;
import java.sql.*;
import javax.sql.*;
import java.util.*;
import javax.ejb.*;
import javax.naming.*;
public class Databasebroker
{
public Databasebroker()
{
}
public String insertToDb(String sql)throws SQLException
{
try{
svar = makeConnection();
}
catch(Exception e)
{svar = "Exception i insertToDB: "+e.toString();
}
try { PreparedStatement prepStmt = con.prepareStatement(sql);
prepStmt.executeUpdate();
prepStmt.close();
svar = svar + "...og det gik godt!";
return svar;
}
catch(Exception e)
{ svar =svar+ (" Sql sætning : " +sql+ " Opdateringen er ikke gennemført, da der er en fejl i statment: "+e.toString());
return svar;
}
}
public Vector getData(String SQL)throws SQLException
{ String ve = SQL;
ResultSet rs;
PreparedStatement prepStmt;
String status = " Alt data er hentet i databasen";
System.out.println("Test 1");
Vector data = new Vector();
try { prepStmt = con.prepareStatement(ve);
System.out.println("Test 2");
rs = prepStmt.executeQuery();
System.out.println("Test 3");
System.out.println("Test 4");
int x = 0;
if (rs.next())
{ x++;
data.add(rs.getString(1));
data.add(rs.getString(2));
data.add(rs.getString(3));
data.add(rs.getString(4));
data.add(rs.getString(5));
prepStmt.close();
}
else
{ prepStmt.close();
}
}
catch(Exception e)
{ System.out.println("TEST");
}
return data;
}
public String makeConnection()
{String forbindelse = "";
try
{ Class.forName(dbDriverName).newInstance();
forbindelse= "Driver er ok ";
forbindelse = forbindelse + getConnection();
return forbindelse;
}
catch(Exception e)
{ forbindelse =("Makeconnection erro 1: "+e.toString());
System.out.println(""+e.toString());
return forbindelse;
}
}
public String getConnection() throws NamingException, SQLException
{ String forbindelse = "";
try
{
con =DriverManager.getConnection(dbClassName, user, pass);
forbindelse = "***Forbindelse til databasen er iorden***";
return forbindelse;
}
catch (SQLException e)
{
forbindelse = forbindelse +("SQLException: " + e.getMessage()+ " ");
forbindelse = forbindelse +("SQLState: " + e.getSQLState()+" ");
forbindelse = forbindelse +("VendorError: " + e.getErrorCode()+" ");
}
return forbindelse;
}
public Connection getCon()
{
return con;
}
private String dbDriverName="org.gjt.mm.mysql.Driver";
private String dbClassName="jdbc:mysql://hopg.vejlehs.dk/netschool";
private String user="root";
private String pass="";
private Connection con;
public String svar="";
}
