Hi
Habe keinen Code mehr gefunden, aber gerade mal schnell einen Programmiert. Der hier sollte funktionieren:
import java.sql.*;
public class DBConnection
{
private Connection dbConnection = null;
/**
* DBConnection - Konstruktorkommentar.
*/
public DBConnection() {
super();
}
public boolean connectDatabase(String dbName, String userName, String password)
{
try
{
String url = "jdbc dbc:" + dbName;
dbConnection = DriverManager.getConnection(url, userName, password);
}
catch (SQLException sqle)
{
sqle.printStackTrace();
return false;
}
return true;
}
public void readValues(String table)
{
try
{
ResultSet rs = dbConnection.createStatement().executeQuery("SELECT * FROM " + table);
while (rs.next())
{
System.out.println(rs);
}
}
catch (SQLException sqle)
{
sqle.printStackTrace();
}
}
public boolean writeValues(String table, String[] values)
{
try
{
String sqlText = "Insert into " + table + " values (";
for (int i = 0; i < values.length; i++)
sqlText = sqlText + values;
sqlText = sqlText.substring(0, sqlText.length() - 2) + ")";
dbConnection.createStatement().executeUpdate(sqlText);
}
catch (SQLException sqle)
{
sqle.printStackTrace();
return false;
}
return true;
}
}
Erbeere
P.S. Bei Fragen, tu dies *g*