jeg bruger beans med jsp
og min connection klasse ser saden ud
import java.io.*;
import java.sql.*;
public class MakeConnection{
private Statement st;
private Connection con;
private ResultSet result;
public MakeConnection(){}
//Method to make connection to mysql RaceRunner database
public void GetConnection(){
/* connect (commented out strings use classic MySQL driver) */
try
{
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection("jdbc:
mysql://localhost/cottage", "1234", "1234");
}
catch (java.sql.SQLException e){
System.out.println("ERROR" + e);
}
catch (Exception e) {
System.out.println("ERROR" + e);
}
}
public void Close(){
if (con!=null){
try
{
con.close();
con=null;
}//try
catch (SQLException e)
{
e.printStackTrace(System.out);
}//catch
}//if
}//close()
public int Add(String AddStatement){
int numberOfRowsAffected = 0;
if(con!=null){
try {
st = con.createStatement();
numberOfRowsAffected = st.executeUpdate(AddStatement);
}//Try
catch (SQLException e) {
System.out.println("ERROR" + e);
}
}//if
return numberOfRowsAffected;
}// Add
public ResultSet MakeQuery(String NewQueryStatement){
if(con!=null){
try
{
st = con.createStatement();
result = st.executeQuery(NewQueryStatement);
}
catch (SQLException e)
{
System.out.println("ERROR" + e);
}
}//if
return null;
} // Make Query
public ResultSet Result(){
return result;
}// Result
}//Class
