dreamfly11712 / the-connection-between-java-and-datebase Goto Github PK

Eclipse + Mysql + Navicat

1. Creat a Java project(Creat an folder and copy the jar,build the path)...

2. Load the driver: Class.forName(driver class)
   (1).Load Mysql driver: Class.forName("com.mysql.jdbc.Driver")
   (2).Load Oracle driver: Class.forName("com.oracle.jdbc.OracleDriver")

3.obtain DB connect:
Driver.Manager.getConnection(url,user,password);

4.creat Statement object:
cnn.creatStatement();

`package com.immoc.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import com.mysql.jdbc.Statement;

public class DB {
public static void main(String[] args) throws Exception {
final String URL="jdbc:mysql://127.0.0.1:3306/imooc";
final String USER="root";
final String PASSWORD="1314";
//1.加载驱动程序
Class.forName("com.mysql.jdbc.Driver");
//2.获得数据库的连接
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
//3.通过数据库的连接操作数据库。实现增删改查
java.sql.Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select user_name,birthday from imooc_goddess");

	while(rs.next()){
		System.out.println(rs.getString("user_name")+","+rs.getInt("birthday"));
	}
}

}
`