vXRh7dFF

1package Main;
2
3
4import java.sql.Connection;
5import java.sql.DriverManager;
6import java.sql.PreparedStatement;
7import java.sql.SQLException;
8
9public class Tester {
10	private static Connection db;
11	private static PreparedStatement stmt;
12	final static String URL = "jdbc:mysql://127.0.0.1:3306/";
13	final static String DB_NAME = "hackeru";
14	final static String USER_NAME = "root";
15	final static String USER_PASS = "";
16
17	public static void main(String[] args) throws Exception{
18		// creating our connection string
19		
20		// creating a connection to our database
21		db = DriverManager.getConnection(URL + DB_NAME, USER_NAME, USER_PASS);
22		createTable();
23	}
24
25	private static void createTable() {
26		// create a SQL command.
27		String sql = "CREATE TABLE IF NOT EXISTS chocos" + " (id INT PRIMARY KEY AUTO_INCREMENT,"
28				+ " name VARCHAR (16) NOT NULL);";
29		
30		try {
31			// prepare statement for given SQL
32			stmt = db.prepareStatement(sql);
33			// execute the statement
34			stmt.execute();
35
36		} catch (SQLException e) {
37			// TODO Auto-generated catch block
38			e.printStackTrace();
39		}
40
41		System.out.println("Table was created");
42	}
43}