Advertisement
Guest User

Untitled

a guest
May 25th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. /**
  2. * Created by rysja on 25.05.16.
  3. */
  4.  
  5. import java.io.BufferedReader;
  6. import java.io.IOException;
  7. import java.io.InputStreamReader;
  8. import java.sql.*;
  9.  
  10. public class DemoJDBC {
  11.  
  12. private static Connection con = null;
  13. private static String username = "root";
  14. private static String password = "4511426k";
  15. private static String URL = "jdbc:mysql://127.0.0.1:3306/phone_boock";
  16.  
  17.  
  18. public static void main(String[] args) throws IOException {
  19. BufferedReader reader=new BufferedReader(new InputStreamReader(System.in));
  20. String s=reader.readLine();
  21.  
  22. int g=Integer.parseInt(reader.readLine());
  23. try {
  24. Class.forName("com.mysql.jdbc.Driver");
  25. con = DriverManager.getConnection(URL, username, password);
  26. Statement st = con.createStatement();
  27. String sql="INSERT INTO phon_list(phon_name, phon_number) values (?,?);";
  28.  
  29.  
  30. PreparedStatement prepareStatement = con.prepareStatement(sql);
  31. prepareStatement.setString(1,s);
  32. prepareStatement.setInt(2,g);
  33. prepareStatement.executeUpdate();
  34. prepareStatement.close();
  35. // st.executeUpdate(sql);
  36. // rs.next();
  37. //String sname = rs.getString(2);
  38. //rs.close();
  39. con.close();
  40. } catch (Exception se) {
  41. //Handle errors for JDBC
  42. se.printStackTrace();
  43. }
  44. }
  45.  
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement