Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class NavneVindu extends JFrame {
- public void metode()
- {
- String dbdriver = "com.mysql.jdbc.Driver";
- String server = "**********";
- String database = "*******";
- String bruker = "****";
- String passord = "*****";
- Connection kobling = null;
- try {
- Class.forName(dbdriver).newInstance();
- kobling = DriverManager.getConnection("jdbc:mysql://" server "/" database, bruker, passord);
- } catch (Exception ex) {
- System.out.println("Feil! FÃ¥r ikke opprettet kontakt med databasen. ");
- System.out.println(ex);
- }
- String sql = "select * from vare";
- Statement stmt = null;
- ResultSet res = null;
- try {
- stmt = kobling.createStatement();
- res = stmt.executeQuery(sql);
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- try {
- while (res.next()) {
- String navn = res.getString("navn");
- System.out.println("" navn);
- }
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement