Posted in: MySql
Java mysql basic
Java Mysql is very common and i will show you a very simple java mysql connection and execute a query.
you need the fallowing
1) mysql
2) mysql-connector-java
you can download it if you want or just browse the net.
Install mysql software in your computer then you are ready to create java mysql application
in your java library add mysql-connector-java-5.1.12-bin.jar (if you download from the link)
you need the fallowing
1) mysql
2) mysql-connector-java
you can download it if you want or just browse the net.
Install mysql software in your computer then you are ready to create java mysql application
in your java library add mysql-connector-java-5.1.12-bin.jar (if you download from the link)
to add jar library in your java project right click libraries from java Projects and select Add JAR/Folder then browse mysql-connector-5.1.12-bin.jar
open mysql commandline from start -> allprograms -> Mysql -> MySQL Command Line Client
type the fallowing syntax.
create database databaseName; //press enter
use databaseName; //press enter
create table tbltest(id int(10),name varchar(15)); //press enter