Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.util.*;
- import java.sql.*;
- import javax.swing.*;
- public class DB {
- String url = "jdbc:mysql://localhost:3306/eksamen2015";
- String bruker = "root";
- String passord = "12345";
- Connection conn = null;
- Statement setning;
- String navn;
- int ansattnr;
- String avdeling;
- Ansatt ansatt = new Ansatt(navn, ansattnr, avdeling);
- public void startDB(int ansattnr, String navn, String avdeling) {
- Ansatt a = new Ansatt(navn, ansattnr, avdeling);
- try {
- } catch (Exception ex) {
- JOptionPane.showMessageDialog(null, ex.getClass() + "\n" + ex.getMessage());
- }
- try {
- setning = conn.createStatement();
- setning.executeUpdate("INSERT INTO ansatt VALUES (" + ansattnr + ",'" + a.getNavn() + "','" + a.getAvdeling(avdeling) + "')");
- } catch (Exception ex) {
- JOptionPane.showMessageDialog(null, ex.getClass() + "\n" + ex.getMessage());
- }
- }
- public void slettAnsatt(int ansattnr) {
- try {
- setning = conn.createStatement();
- setning.execute("DELETE FROM ansatt WHERE ansattnr="+ ansattnr);
- }catch (Exception ex) {
- JOptionPane.showMessageDialog(null, ex.getClass() + "\n" + ex.getMessage());
- }
- }
- public int hentMax() throws SQLException {
- ResultSet max;
- setning = conn.createStatement();
- max = setning.executeQuery("SELECT max(ansattnr) AS maxi FROM ansatt");
- max.next();
- int nr = max.getInt("maxi");
- nr++;
- return nr;
- }
- public ResultSet visAlle() throws SQLException {
- // Vector<Ansatt> list = new Vector<>();
- ResultSet resultat = null;
- try {
- conn = DriverManager.getConnection(url, bruker, passord);
- } catch (Exception ex) {
- JOptionPane.showMessageDialog(null, ex.getClass() + "\n" + ex.getMessage());
- }
- setning = conn.createStatement();
- resultat = setning.executeQuery("SELECT * FROM ansatt");
- return resultat;
- }
- public void slettAnsatt() {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement