Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void saveDB() {
- String sURL="jdbc:mysql://localhost:3306/lista";
- String user="listador";
- String pass="admin";
- String sDriver="com.mysql.jdbc.Driver";
- Connection con=null;
- try {
- Class.forName(sDriver).newInstance();
- } catch (InstantiationException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (IllegalAccessException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- try {
- con = DriverManager.getConnection(sURL,user,pass);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- try {
- DefaultListModel<String> model = (DefaultListModel<String>) list.getModel();
- int size = model.getSize();
- for (int i = 0; i < size; i++) {
- String query="INSERT INTO lista (nombre) VALUES (?)";
- PreparedStatement ps =con.prepareStatement(query);
- ps.setString(1,"xxx");
- ps.executeUpdate();
- }
- }catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- try {
- con.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement