Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package datenbanken;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSet;
- public class Datenbanken {
- public static void main(String[] args) {
- String host = "jdbc:derby://localhost:1527/Produkte";
- String username = "mitarbeiter1";
- String password = "xyz";
- try {
- Connection verbindung = DriverManager.getConnection(host, username, password);
- Statement befehl = verbindung.createStatement( );
- String SQL = "SELECT Produkttyp FROM Produkte WHERE Artikelnummer = 1002";
- ResultSet rs = befehl.executeQuery(SQL);
- rs.next( );
- String Produkttyp1 = rs.getString("Produkttyp");
- System.out.println(Produkttyp1);
- }
- catch ( SQLException err ) {
- System.out.println( err.getMessage( ) );
- }
- }
- }
Add Comment
Please, Sign In to add comment