JAVA Archives - An artist's personal website

Hi there .Its a sample implementation of mysql connection with java #database

CREATE TABLE IF NOT EXISTS `employees` (
  `Id` int(11) NOT NULL,
  `first_name` text NOT NULL,
  `last_name` text NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`Id`, `first_name`, `last_name`) VALUES
(1, 'aaaa', 'cccc'),
(2, 'ssss', 'cccc');

select * from employees;

CREATE TABLE IF NOT EXISTS `employees` (

`Id` int(11) NOT NULL,

`first_name` text NOT NULL,

`last_name` text NOT NULL,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `employees`

INSERT INTO `employees` (`Id`, `first_name`, `last_name`) VALUES

(1, 'aaaa', 'cccc'),

(2, 'ssss', 'cccc');

select * from employees;

#pom.xml

<dependencies>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
    </dependency>
</dependencies>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

</dependencies>

Details…

Category: JAVA

vertx hello world in intellij idea

Connect to mysql using maven