Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.text.* ;
- public class TestDB1 {
- public static void main(String[] args) {
- // Driver und URL für die MySQL Datenbank
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://vm-mysql.mni.fh-giessen.de:3306/pis_db";
- String user = null;
- String password = null;
- Connection con = null;
- Statement state= null;
- ResultSet rs = null;
- // Treiber laden, Verbindung aufbauen
- // Programm hier ergänzen ....
- try {
- Class.forName(driver);
- con = DriverManager.getConnection(url, user, password);
- state = con.createStatement();
- System.out.println("Datenbankverbingung korrekt aufgebaut!");
- ResultSet rsa = state.executeQuery("SELECT COUNT(*) FROM artikel2");
- rsa.next();
- System.out.println(rsa.getString(1));
- rsa.close();
- String[][] daten = new String[3][3];
- rs = state.executeQuery("select * from artikel2");
- System.out.println();
- System.out.println(" ID Bezeichnung Gültigkeitsdatum Preis");
- System.out.println();
- while (rs.next()==true)
- {
- System.out.printf("%5d ",rs.getInt("ID"));
- System.out.printf("%-30s",rs.getString("Bezeichnung"));
- DateFormat myformat = new SimpleDateFormat("dd. MMMMM yyyy");
- System.out.printf("%-25s",myformat.format(rs.getDate("gueltig_bis")));
- System.out.printf("%6s",rs.getString("preis"));
- System.out.println();
- for(int i=0; i<3; i++){
- daten[i][0]=rs.getString(1);
- }
- }
- rs.close();
- }
- catch (ClassNotFoundException e) {
- System.out.println("Treiber nicht gefunden!");
- System.err.println(e.getMessage());
- System.exit(1);
- }
- catch (SQLException e) {
- System.out.println("Datenbankverbingung nicht korrekt aufgebaut!");
- System.err.println(e.getMessage());
- System.exit(1);
- }
- if (con != null) {
- try {
- state.close();
- con.close();
- System.out.println();
- System.out.println("Datenbankverbiung abgebaut!");
- }
- catch (SQLException ex) { }
- }
- }
- }
Add Comment
Please, Sign In to add comment