Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void readFromFile(String filNamn) throws IOException {
- Connection dbConnection = null;
- PreparedStatement statement = null;
- ResultSet rs = null;
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- System.out.println("MYSQL:s JDBC-drivrutiner hittades.");
- } catch (Exception e) {
- System.err.println("MYSQL:s JDBC-drivrutiner kunde INTE hittas.");
- }
- String url = "jdbc:mysql://atlantis.informatik.umu.se/svph1102_db2_vt2012";
- String user = "svph1102";
- String password = "qygebagaq";
- try {
- dbConnection = DriverManager.getConnection(url, user, password);
- String strSql = "SELECT registerNummer ,artikelNummer, titel, genre, aldersGrans FROM spel ";
- statement = dbConnection.createStatement();
- rs = statement.executeQuery(strSql);
- while (rs.next()) {
- System.out.println(rs.getString("registerNummer") + "\t" + rs.getString("artikelNummer") + "\t" + rs.getString("titel") + "\t" + rs.getString("genre") + "\t" + rs.getString("aldersGrans"));
- Spel s = new Spel();
- s.setRegisterNummer(Integer.parseInt(post[0]));
- s.setArtikelNummer(post[1]);
- s.setTitel(post[2]);
- s.setGenre(post[3]);
- s.setAldersGrans(post[4]);
- this.addSpel(s);
- }
- catch (SQLException ex) {
- System.err.println("Ett fel har uppstått: " + ex.toString());
- }
- }
- in.close();
- }
Add Comment
Please, Sign In to add comment