JDBC的实现步骤:
1、导入访问mysql数据库需要依赖的jar包(mysql-connector-java-5.1.7-bin.jar);
2、创建java程序:com.phome.jdbc.JdbcDemo1.java;
3、注册驱动:Class.forName("com.mysql.jdbc.Driver");
4、打开连接:DriverManager.getConnection("jdbc:mysql://localhost:3306/model", "root", "ROOT");//(连接串,账号,密码)
5、获取操作sql的对象:Statement
6、执行sql语句;
7、关闭连接。
创建数据库:
运行代码:
package com.phome.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
* @author FengLi
*
*/
public class JdbcDemo1 {
public static void main(String[] args) throws ClassNotFoundException,
SQLException {
// 注册数据库驱动
Class.forName("com.mysql.jdbc.Driver");
// 打开数据库连接
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/model", "root", "ROOT");
// 获取操作数据库数据的对象
Statement state = conn.createStatement();
// 定义要操作数据库的sql语句
String sql = "insert into student(name,gender,age,phone) values('haha','boy',20,'18215168028')";
// String sql = "delete from student where id=2";
// 执行sql语句
state.execute(sql);
// 定义要执行的查询语句
sql = "select * from student";
// 执行查询语句,查询时要返回查询结果的,查询结果存放在java.sql.ResultSet中
ResultSet rs = state.executeQuery(sql);
// 遍历查询结果
while (rs.next()) {
int id = rs.getInt(1);
String name = rs.getString("name");
String gender = rs.getString("gender");
int age = rs.getInt("age");
String phone = rs.getString("phone");
System.out.println("用户编号:【" + id + "】\n" + "姓名:【" + name + "】\n"
+ "性别:【" + gender + "】\n" + "年龄:【" + age + "】\n" + "电话:【"
+ phone + "】");
}
// 关闭连接
state.close();
conn.close();
}
}
插入数据结果: