Tweet
Hallo
Ich habe eine String[] listeStationen, die ich gerne in eine Datenbank Tabelle speichern möchte.
Es scheitert allerdings an diesem Ausdruck. Wie kann ich das lösen?
CODE]
preparedStatement.setString(18, listeStationen);
[/CODE]
Ganzer Code:
Ich habe eine String[] listeStationen, die ich gerne in eine Datenbank Tabelle speichern möchte.
Es scheitert allerdings an diesem Ausdruck. Wie kann ich das lösen?
CODE]
preparedStatement.setString(18, listeStationen);
[/CODE]
Ganzer Code:
Code:
package Database;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Time;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.text.ParseException;
public class DBWriter extends Editor {
private static final String DB_DRIVER = "***********";
private static final String DB_CONNECTION = "**********";
private static final String DB_USER = "*********";
private static final String DB_PASSWORD = "*********";
public static void writeDB() throws ParseException {
try {
insertRecordIntoTable();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
private static void insertRecordIntoTable() throws SQLException, ParseException {
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
String insertTableSQL = "INSERT INTO leistungen"
+ "(Leistung, Datum, DatumEnde, Montag, Dienstag, Mittwoch, Donnerstag, Freitag, Samstag, Sonntag, Feiertage, Zug, Linie, Abfahrt, Ankunft, Von, Nach, Stationen) VALUES"
+ "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
try {
String text1 = Mo.getText();
int mo = Integer.parseInt(text1);
String text2 = Di.getText();
int di = Integer.parseInt(text2);
String text3 = Mi.getText();
int mi = Integer.parseInt(text3);
String text4 = Do.getText();
int DO = Integer.parseInt(text4);
String text5 = Fr.getText();
int fr = Integer.parseInt(text5);
String text6 = Sa.getText();
int sa = Integer.parseInt(text6);
String text7 = So.getText();
int so = Integer.parseInt(text7);
String text8 = Ft.getText();
int ft = Integer.parseInt(text8);
SimpleDateFormat sdf1 = new SimpleDateFormat("dd.MM.yyyy");
String startDate = txtnDatumBeginn.getText();
String endDate = txtnDatumEnde.getText();
java.util.Date date1 = sdf1.parse(startDate);
java.sql.Date sqlStartDate = new java.sql.Date(date1.getTime());
java.util.Date date2 = sdf1.parse(endDate);
java.sql.Date sqlEndDate = new java.sql.Date(date2.getTime());
DateFormat dateFormat = new SimpleDateFormat("hh:mm");
Time time1 = new Time(dateFormat.parse(txtnAbfahrt.getText()).getTi me());
Time time2 = new Time(dateFormat.parse(txtnAnkunft.getText()).getTi me());
String text9 = txtnLeistung.getText();
int Leistung = Integer.parseInt(text9);
dbConnection = getDBConnection();
preparedStatement = dbConnection.prepareStatement(insertTableSQL);
preparedStatement.setInt(1, Leistung);
preparedStatement.setDate(2, (java.sql.Date) sqlStartDate);
preparedStatement.setDate(3, (java.sql.Date) sqlEndDate);
preparedStatement.setInt(4, mo);
preparedStatement.setInt(5, di);
preparedStatement.setInt(6, mi);
preparedStatement.setInt(7, DO);
preparedStatement.setInt(8, fr);
preparedStatement.setInt(9, sa);
preparedStatement.setInt(10, so);
preparedStatement.setInt(11, ft);
preparedStatement.setString(12, txtnZug.getText());
preparedStatement.setString(13, txtnLinie.getText());
preparedStatement.setTime(14, time1);
preparedStatement.setTime(15, time2);
preparedStatement.setString(16, txtnStart.getText());
preparedStatement.setString(17, txtnEnde.getText());
preparedStatement.setString(18, listeStationen);
preparedStatement.executeUpdate();
// preparedStatement.close();
// execute insert SQL stetement
preparedStatement.executeUpdate();
System.out.println("Record is inserted into DBUSER table!");
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
if (preparedStatement != null) {
preparedStatement.close();
}
if (dbConnection != null) {
dbConnection.close();
}
}
}
private static Connection getDBConnection() {
Connection dbConnection = null;
try {
Class.forName(DB_DRIVER);
} catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
}
try {
dbConnection = DriverManager.getConnection(
DB_CONNECTION, DB_USER,DB_PASSWORD);
return dbConnection;
} catch (SQLException e) {
System.out.println(e.getMessage());
}
return dbConnection;
}
private static java.sql.Timestamp getCurrentTimeStamp() {
java.util.Date today = new java.util.Date();
return new java.sql.Timestamp(today.getTime());
}
}
Comment