Advertisement
Guest User

MySql

a guest
Feb 28th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.14 KB | None | 0 0
  1. package Main;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.SQLException;
  7.  
  8. public class Tester {
  9.     // field that we need
  10.     private static Connection db;
  11.     private static PreparedStatement stmt;
  12.     // connection
  13.     final static String URL = "jdbc:mysql://localhost:3106/";
  14.     final static String DB_NAME = "evgany";
  15.     final static String USER_NAME = "root";
  16.     final static String USER_PASS = "";
  17.    
  18.     public static void main(String[] args) throws Exception {
  19.         //creating our connectiuon string
  20.         db = DriverManager.getConnection(URL+DB_NAME, USER_NAME, USER_PASS);
  21.        
  22.         //create a table for the first time, and if the table exists do not create it...
  23.         createTable();
  24.     }
  25.    
  26.     public static void createTable()
  27.     {
  28.         String sql="CREATE TABLE IF NOT EXISTS WEED (id INT PRIMARY KEY AUTO_INCReMeNT, name VARCHAR(16) NOT NULL, qty int(2)";
  29.         try{
  30.             //prepare statment for given SQL
  31.             stmt = db.prepareStatement(sql);
  32.             //execure the fucking statment
  33.             stmt.execute();
  34.         }
  35.         catch (SQLException e){
  36.             e.printStackTrace();
  37.         }
  38.         System.out.println("Table was created.......");
  39.     }
  40.  
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement