Patrick Bloch

Hello dear community, currently I'm working on a program for me. I have done many things meanwhile in the topic SQLite and many problems myself, found and solved. Now I have a problem where my console tells me no problem and I have to admit that I can not find out what the error could be. If I click on the button "Register customer" the following code will result

JButton btnNewButton = new JButton("Kunden eintragen"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { String vor = vorname.getText(); String nach = nachname.getText(); String str = strasse.getText(); String pos = postleit.getText(); String woh = wohnort.getText(); String geb = geburtsort.getText(); String per = personr.getText(); String han = handynr.getText(); String tel = telefon.getText(); new_customer app = new new_customer();        // insert three new rows app.insert(vor,nach,str,pos,woh,geb,per,han,tel); } });

The "insert" that is called looks like this

/**     * Insert a new row into the kunde table     *     * @param vorname     * @param nachname     * @param strasse     * @param postleit     * @param wohnort     * @param geburtsort     * @param personr     * @param handynr     * @param telefon     *     */    public void insert(String vorname, String nachname, String strasse, String postleit, String wohnort, String geburtsort, String personr, String handynr, String telefon) {        String sql = "INSERT INTO kunde(vorname,nachname,strasse,postleit,wohnort,geburtsort,personr,handynr,telefon) VALUES(?,?,?,?,?,?,?,?,?)";        try (Connection conn = this.connect();                PreparedStatement pstmt = conn.prepareStatement(sql)) {            pstmt.setString(1, vorname);            pstmt.setString(2, nachname);            pstmt.setString(3, strasse);            pstmt.setString(4, postleit);            pstmt.setString(5, wohnort);            pstmt.setString(6, geburtsort);            pstmt.setString(7, personr);            pstmt.setString(8, handynr);            pstmt.setString(9, telefon);            pstmt.executeUpdate();        } catch (SQLException e) {            System.out.println(e.getMessage());        }    }

After I clicked, nothing happens. There are no error messages, but the data is not entered in the table! Where did I make a mistake?
It would be nice to find help for that.

Maybe you can help me again. Or one. Then I do not have to open a new area for the topic.
I am currently building the area where the tables are created, the first table is created. At the second he tells me then but that:

SQL error or missing database (near ")": syntax error)

does anyone have any idea what could be wrong? Here is my Code again:

package smartrepshop.net.sqlite; import java.io.File; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class connect { /**     * Connect to a sample database     */    public static void connect() {         Connection conn = null;     try {                // db parameters                String url = "jdbc:sqlite:RepShopData/repshopdata.db";                // create a connection to the database                conn = DriverManager.getConnection(url);                                System.out.println("Connection to SQLite has been established.");                            } catch (SQLException e) {                System.out.println(e.getMessage());            } finally {                try {                    if (conn != null) {                        conn.close();                    }                } catch (SQLException ex) {                    System.out.println(ex.getMessage());                }            }    }        public static void createNewDatabase() {            String url = "jdbc:sqlite:RepShopData/repshopdata.db";        try (Connection conn = DriverManager.getConnection(url)) {            if (conn != null) {                DatabaseMetaData meta = conn.getMetaData();                System.out.println("The driver name is " + meta.getDriverName());                System.out.println("A new database has been created.");            }        } catch (SQLException e) {            System.out.println(e.getMessage());        }    }        public static void createNewKundeTable() {        // SQLite connection string        String url = "jdbc:sqlite:RepShopData/repshopdata.db";                // SQL statement for creating a new table        String sql = "CREATE TABLE IF NOT EXISTS kunde (\n"                + "    id integer PRIMARY KEY,\n"                + "    vorname text NOT NULL,\n"                + "    nachname text NOT NULL,\n"                + "   strasse text NOT NULL,\n"                + "   wohnort text NOT NULL,\n"                + "   plz text NOT NULL,\n"                + "   geburtsort text NOT NULL,\n"                + "   personr text,\n"                + "   handy text,\n"                + "   telefon text,\n"                + ");";        String sql2 = "CREATE TABLE IF NOT EXISTS auftrag (\n"                + "    id integer PRIMARY KEY,\n"                + "    schaden text NOT NULL,\n"                + "    marke text NOT NULL,\n"                + "   model text NOT NULL,\n"                + "   farbe text NOT NULL,\n"                + "   imei text NOT NULL,\n"                + "   fertig text NOT NULL,\n"                + ");";                try (Connection conn = DriverManager.getConnection(url);                Statement stmt = conn.createStatement()) {            // create a new table            stmt.execute(sql);            stmt.execute(sql2);        } catch (SQLException e) {            System.out.println(e.getMessage());        }    }        /**     * @param args the command line arguments     */    public static void main(String[] args) {             File file = new File ("RepShopData/repshopdata.db");         if (file.exists())        {         connect();                }else {                 System.out.print("Datenbank wird initialisiert.");         createNewDatabase();         createNewKundeTable();                }    } }

Hey, thanks for your answer. I have try and itś work ^^ So much thanks to you!
Well my English is not the yellow from the egg, but i will do my best to learn and write english better.
Thanks for the Solution. With the Relative System I will read more. The whole thing is to learn a little while ^ ^

Hello Community,

i programming to time a Program, that are for my Buisness. In this Program i will do the follow things:

Connect to SQlite

Create Database when not on System

Create Table when not already there

Read/Write things in Database

now i have write a connection.java . The Connection was established. After this i have do a if&else to find out, is the database as data there and when is not there then create. After this Point i do anything false! Here my Code:
package smartrepshop.net.sqlite; import java.io.File; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.SQLException; public class connect { /**     * Connect to a sample database     */    public static void connect() {         Connection conn = null;     try {                // db parameters                String url = "jdbc:sqlite:RepShopData/repshopdata.db";                // create a connection to the database                conn = DriverManager.getConnection(url);                                System.out.println("Connection to SQLite has been established.");                            } catch (SQLException e) {                System.out.println(e.getMessage());            } finally {                try {                    if (conn != null) {                        conn.close();                    }                } catch (SQLException ex) {                    System.out.println(ex.getMessage());                }            }    }        public static void createNewDatabase() {            String url = "jdbc:sqlite:RepShopData/repshopdata.db";        try (Connection conn = DriverManager.getConnection(url)) {            if (conn != null) {                DatabaseMetaData meta = conn.getMetaData();                System.out.println("The driver name is " + meta.getDriverName());                System.out.println("A new database has been created.");            }        } catch (SQLException e) {            System.out.println(e.getMessage());        }    }        /**     * @param args the command line arguments     */    public static void main(String[] args) {             File file = new File ("jdbc:sqlite:RepShopData/repshopdata.db");         if (file.exists())        {         connect();                }else {                 System.out.print("Datenbank wird initialisiert.");         createNewDatabase();                }    } }

Every Time when i start my programm he goes in the "createNewDatabase();" Function and dont find out, that the database is already there. Anybody has help for me ?
Best Regards