Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //dbjava
- import java.sql.*;
- public class MyJDBC {
- private static final String MYURL = "jdbc:mysql://localhost/army";
- private static final String USERNAME = "root";
- private static final String PASSWORD = "";
- public static void main(String[] args) {
- Connection con = null;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection(MYURL, USERNAME, PASSWORD);
- if (con != null) {
- System.out.println("Successfully connect");
- } else {
- System.out.println("Connection fail!");
- }
- Statement stmt = con.createStatement();
- String army = "INSERT INTO mytable_5730213093 VALUES (6,'David')";
- stmt.executeUpdate( army);
- army = "INSERT INTO mytable_5730213093 VALUES (7,'Jacob')";
- stmt.executeUpdate( army);
- army = "INSERT INTO mytable_5730213093 VALUES (8,'Nick')";
- stmt.executeUpdate( army);
- army= "INSERT INTO mytable_5730213093 VALUES (9,'Ronald')";
- stmt.executeUpdate( army);
- PreparedStatement Statement = con.prepareStatement("UPDATE mytable_5730213093 SET NAME = 'Donna' WHERE ID = 1");
- PreparedStatement Statement2 = con.prepareStatement("UPDATE mytable_5730213093 SET NAME = 'Xio' WHERE ID = 2");
- Statement.executeUpdate();
- Statement2.executeUpdate();
- ResultSet rs = stmt.executeQuery("SELECT * FROM mytable_5730213093 ");
- while (rs.next()) {
- int num = rs.getInt("ID");
- String name = (String) rs.getString("NAME");
- System.out.println(num + ":" + name);
- }
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement