JDBC简单入门
java连接数据库 进行sql查询
Java DataBase Connectivity
1.设置mysql
create database JDBC;
use JDBC;
create table users(
id INT PRIMARY KEY ,
`name` VARCHAR(40),
`password` VARCHAR(40),
emile VARCHAR(60),
birthday DATE
);
insert into users(id, `name`, `password`, `emile`, `birthday`)
values (1,'安徽','123456','dfg9554858@qq.com','2000-01-01' );
insert into users(id, `name`, `password`, `emile`, `birthday`)
values (2,'王多多','123456','3979554858@qq.com','2000-01-01' );
select * from users;
2.导入mysql驱动 maven进行
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
</dependencies>
3.连接数据库 连接数据库编码问题
- 创建一个资源类配置连接数据库的内容
//中文乱码问题
String url="jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncording=utf-8";
String username="root";
String password="root";
//必须要驱动
Class.forName("com.mysql.jdbc.Driver");
//连接数据库
Connection connection = DriverManager.getConnection(url, username, password);
System.out.printf("成功连接数据库");
4.执行sql操作
//向数据库发送sql的对象 Statement CRUD
Statement statement = connection.createStatement();
//编写SQl
String sql="select * from users";
//执行Sql 返回一个ResulteQuery 结果集
ResultSet resultSet = statement.executeQuery(sql);//执行查询
while (resultSet.next()){
System.out.printf("id:"+resultSet.getObject("id"));
System.out.printf("name:"+resultSet.getObject("name"));
System.out.printf("password:"+resultSet.getObject("password"));
System.out.printf("emile:"+resultSet.getObject("emile"));
System.out.printf("birthday:"+resultSet.getObject("birthday"));
}
//关闭连接 释放一定要做 先开后释放
resultSet.close();
statement.close();
connection.close();
6.预编译sql 插入操作
1.insert into 插入
String sql="insert into users(id,`name`,`password`,`emile`,`birthday`) values(?,?,?,?,?);";
2.预编译操作
//预编译
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1,4);
preparedStatement.setString(2,"王哈哈");
preparedStatement.setString(3,"123456");
preparedStatement.setString(4,"347955458@qq.com");
preparedStatement.setDate(5,new Date(new java.util.Date().getTime()));
3.执行Sql
//执行sql
int i = preparedStatement.executeUpdate();
if(i>0){
System.out.printf("sql插入成功");
}
4.在数据库里面进行查询成功
7.来源
1.狂神视频学习
2.如果错误请指出改正
3.本人刚刚入门有些知识不是很专业望理解