1.创建javaweb项目 JavaWebMySql
2.把mysql-connector-java-5.1.7-bin.jar在lib下
3.在src创建com.xf.Test包,在该包下创建MysqlTest和User类
MysqlTest.java
package com.xf.Test;
import java.sql.*;
import java.util.ArrayList;
public class MysqlTesst {
//驱动名称
private static final String driverName="com.mysql.jdbc.Driver";
//数据库的地址(通过端口和SID找到对应的数据库)
private static final String URL="jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
//数据库登录用户名
private static final String userName="root";
//数据库登录密码
private static final String pwd="123456";
public void getConnection() {
// 创建一个数据库连接
Connection connection = null;
// 创建预编译语句对象
PreparedStatement pstat = null;
// 创建结果集对象
ResultSet rs = null;
ArrayList<User> list = new ArrayList<User>();
try {
//加载oracle驱动
Class.forName(driverName);
//通过驱动获取数据库的连接
connection = DriverManager.getConnection(URL,userName,pwd);
//下面是查询操作
String sql = "select * from user";
pstat = connection.prepareStatement(sql);
rs = pstat.executeQuery();
while (rs.next()) {
User item = new User();
item.setAge(rs.getInt("age"));
item.setName(rs.getString("name"));
item.setId(rs.getInt("id"));
list.add(item);
System.out.println(rs.getInt("age")+rs.getString("name"));
}
System.out.println("连接成功");
} catch (Exception e) {
System.out.println("连接失败");
e.printStackTrace();
}
}
public static void main(String[] args) {
MysqlTesst mysqlTesst=new MysqlTesst();
mysqlTesst.getConnection();
}
}
User.java
package com.xf.Test;
public class User {
private int id;
private String name;
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
4.创建数据库jdbc和User表,如下
6.运行方式:
参考资料:https://blog.csdn.net/williamchew/article/details/51951551
https://blog.csdn.net/wcc27857285/article/details/82287205
https://blog.csdn.net/weixin_42950079/article/details/86706989