Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Main;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- public class Tester {
- private static Connection db;
- private static PreparedStatement stmt;
- final static String URL = "jdbc:mysql://127.0.0.1:3306/";
- final static String DB_NAME = "hackeru";
- final static String USER_NAME = "root";
- final static String USER_PASS = "";
- public static void main(String[] args) throws Exception {
- // creating our connection string
- // creating a connection to our database
- db = DriverManager.getConnection(URL + DB_NAME, USER_NAME, USER_PASS);
- //create table for the first time, and if the table exists do not create it....
- //createTable();
- //insert first data to our mySQL with JDBC
- insertFirstDemo();
- }
- private static void insertFirstDemo() {
- // create a SQL command.
- String sql = "INSERT INTO chocos (name) "
- + "values ('Para'),('Milka'),('Oreo'),('Bueno'),"
- + "('Ferror Roche');";
- try {
- // prepare statement for given SQL
- stmt = db.prepareStatement(sql);
- // execute the statement
- stmt.execute();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- System.out.println("Data was inserted");
- }
- private static void createTable() {
- // create a SQL command.
- String sql = "CREATE TABLE IF NOT EXISTS chocos" + " (id INT PRIMARY KEY AUTO_INCREMENT,"
- + " name VARCHAR (16) NOT NULL);";
- try {
- // prepare statement for given SQL
- stmt = db.prepareStatement(sql);
- // execute the statement
- stmt.execute();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- System.out.println("Table was created");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement