Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class DBconnect {
- public static void main(String[] args) {
- import java.sql.*
- //Treiber für jdbc laden
- try
- {
- Class.forName( "com.mysql.jdbc.Driver" );
- }
- catch ( ClassNotFoundException e )
- {
- e.printStackTrace();
- }
- //Verbindung mit der Datenbank
- try {
- String host = "jdbc:mysql://weg-winnweiler.selfhos.eu:1433/pickomat";
- String name = "root";
- String pass= "#15Pic__";
- Connection con = DriverManager.getConnection( host, name, pass );
- }
- catch ( SQLException err ) {
- System.out.println( err.getMessage( ) );
- }
- //Reinschreiben
- for (int i = 0; i < args.length; i++) {
- String firstname = bla;
- String lastname = bla;
- String grade = bla;
- String pin = bla;
- String first = bla;
- String second = bla;
- String third = bla;
- String voted = bla;
- String id = bla;
- try {
- Statement stmt = conn.createStatement();
- // Ergebnistabelle erzeugen und abholen.
- String sql = "INSERT INTO SCHUELER(firstname,lastname,grade,pin,first,second,)"
- + " VALUES (firstname,lastname,grade,pin,first,second,)";
- stmt.executeUpdate(sql);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement