jdbc测试类代码mysql_Java:使用jdbc连接MySQL数据库(一)

一、一般开发过程

Step1 : 建立数据库连接

以下是语法

代码片段

Step2: 建立Statement对象

Statement基于数据库连接,稍后用来执行SQL查询

Step3:执行SQL查询

Step4: 处理结果集

方法ResultSet.next()的作用是向下移动一行,如果还有记录则返回true

读取数据

二、安装开发环境

Step1&＃xff1a; 系统需求

create database if not exists demo;

use demo;

drop table if exists employees;

CREATE TABLE employees ( id int(11) NOT NULL AUTO_INCREMENT, last_name varchar(64) DEFAULT NULL, first_name varchar(64) DEFAULT NULL, email varchar(64) DEFAULT NULL, department varchar(64) DEFAULT NULL, salary DECIMAL(10,2) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE&＃61;InnoDB AUTO_INCREMENT&＃61;1 DEFAULT CHARSET&＃61;latin1;

INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (1,&＃39;Doe&＃39;,&＃39;John&＃39;,&＃39;john.doe&＃64;foo.com&＃39;, &＃39;HR&＃39;, 55000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (2,&＃39;Public&＃39;,&＃39;Mary&＃39;,&＃39;mary.public&＃64;foo.com&＃39;, &＃39;Engineering&＃39;, 75000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (3,&＃39;Queue&＃39;,&＃39;Susan&＃39;,&＃39;susan.queue&＃64;foo.com&＃39;, &＃39;Legal&＃39;, 130000.00);

INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (4,&＃39;Williams&＃39;,&＃39;David&＃39;,&＃39;david.williams&＃64;foo.com&＃39;, &＃39;HR&＃39;, 120000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (5,&＃39;Johnson&＃39;,&＃39;Lisa&＃39;,&＃39;lisa.johnson&＃64;foo.com&＃39;, &＃39;Engineering&＃39;, 50000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (6,&＃39;Smith&＃39;,&＃39;Paul&＃39;,&＃39;paul.smith&＃64;foo.com&＃39;, &＃39;Legal&＃39;, 100000.00);

INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (7,&＃39;Adams&＃39;,&＃39;Carl&＃39;,&＃39;carl.adams&＃64;foo.com&＃39;, &＃39;HR&＃39;, 50000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (8,&＃39;Brown&＃39;,&＃39;Bill&＃39;,&＃39;bill.brown&＃64;foo.com&＃39;, &＃39;Engineering&＃39;, 50000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (9,&＃39;Thomas&＃39;,&＃39;Susan&＃39;,&＃39;susan.thomas&＃64;foo.com&＃39;, &＃39;Legal&＃39;, 80000.00);

INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (10,&＃39;Davis&＃39;,&＃39;John&＃39;,&＃39;john.davis&＃64;foo.com&＃39;, &＃39;HR&＃39;, 45000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (11,&＃39;Fowler&＃39;,&＃39;Mary&＃39;,&＃39;mary.fowler&＃64;foo.com&＃39;, &＃39;Engineering&＃39;, 65000.00); INSERT INTO employees (id,last_name,first_name,email, department, salary) VALUES (12,&＃39;Waters&＃39;,&＃39;David&＃39;,&＃39;david.waters&＃64;foo.com&＃39;, &＃39;Legal&＃39;, 90000.00);

Step2: 安装JDBC驱动

然后复制jdbc驱动到项目目录中

配置到类路径

Step3 : 测试代码

import java.sql.*;

/**

*

* &＃64;author www.luv2code.com

*

*/

public class JdbcTest {

public static void main(String[] args) throws SQLException {

Connection myConn &＃61; null;

Statement myStmt &＃61; null;

ResultSet myRs &＃61; null;

try {

// 1\. Get a connection to database

myConn &＃61; DriverManager.getConnection("jdbc:mysql://192.168.1.8:3306/demo", "root" , "bihell.com");

System.out.println("Database connection successful!\n");

// 2\. Create a statement

myStmt &＃61; myConn.createStatement();

// 3\. Execute SQL query

myRs &＃61; myStmt.executeQuery("select * from employees");

// 4\. Process the result set

while (myRs.next()) {

System.out.println(myRs.getString("last_name") &＃43; ", " &＃43; myRs.getString("first_name"));

}

}

catch (Exception exc) {

exc.printStackTrace();

}

finally {

if (myRs !&＃61; null) {

myRs.close();

}

if (myStmt !&＃61; null) {

myStmt.close();

}

if (myConn !&＃61; null) {

myConn.close();

}

}

}

}