Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Connection con = DriverManager.getConnection("jdbc:mysql://172.18.2.70:3306/mysql?verifyServerCertificate=false&useSSL=true",
- "userek" , "$ala_ma!kota%");
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("Select * from userek.tabelka");
- show (rs);
- st.close();
- st = con.createStatement();
- int update_count = st.executeUpdate("INSERT INTO USEREK.TABELKA Values (0,'xD','xDDDDDD', 0)");
- System.out.println(update_count + "wypisane wiersze z USEREK.TABELKA");
- st.close();
- con.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- public static void show(ResultSet rs) throws SQLException{
- Vector<Vector<String>> wiersze = new Vector<Vector<String>>();
- while (rs.next()){
- Vector<String> wiersz = new Vector<>();
- wiersz.addElement(rs.getString("id"));
- wiersz.addElement(rs.getString("imie"));
- wiersz.addElement(rs.getString("nazwisko"));
- wiersz.addElement(rs.getString("pensja"));
- wiersz.addElement(rs.getString("imie") + " " + rs.getString("nazwisko"));
- wiersze.add(wiersz);
- }
- System.out.println("Begin--------");
- for (Vector<String>wiersz : wiersze){
- System.out.println("Wiersz: " + wiersz);
- }
- System.out.println("End--------");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement