导入对应jar包
本文只介绍mysql
mysqljar包下载地址:
下载成功后,将对应jar文件加入至java项目的lib目录并且添加进libraries
注册驱动
在类中,写入如下代码注册驱动
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
java链接Mysql简单文件
更新
@Test
public void update() throws Exception {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//url数据库地址,username数据库用户名,password用户密码
String url = "jdbc:mysql://127.0.0.1:3306/db1";
String username = "root";
String password = "root";
//链接数据库
Connection conn = DriverManager.getConnection(url,username,password);
//定义sql语句
String sql = "update account set money=2000 where id=2;";
//获取执行Sql的对象statement
Statement statement = conn.createStatement();
//执行sql语句后,返回影响的行数
int row = statement.executeUpdate(sql);
System.out.println("影响的行数:"+row+"行");
}
插入
@Test
public void insert() throws Exception {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//url数据库地址,username数据库用户名,password用户密码
String url = "jdbc:mysql://127.0.0.1:3306/db1";
String username = "root";
String password = "root";
//链接数据库
Connection conn = DriverManager.getConnection(url,username,password);
//定义sql语句
String sql = "insert into account VALUES(null,'赵七',5000)";
//获取执行Sql的对象statement
Statement statement = conn.createStatement();
//执行sql语句后,返回影响的行数
int row = statement.executeUpdate(sql);
System.out.println("影响的行数:"+row+"行");
}
删除
@Test
public void delete() throws Exception {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//url数据库地址,username数据库用户名,password用户密码
String url = "jdbc:mysql://127.0.0.1:3306/db1";
String username = "root";
String password = "root";
//链接数据库
Connection conn = DriverManager.getConnection(url,username,password);
//定义sql语句
String sql = "DELETE FROM account where id=5";
//获取执行Sql的对象statement
Statement statement = conn.createStatement();
//执行sql语句后,返回影响的行数
int row = statement.executeUpdate(sql);
System.out.println("影响的行数:"+row+"行");
}
查询
@Test
public void select() throws Exception {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//需要连接的数据库url地址,以及登录数据库的用户名,密码
String url = "jdbc:mysql://127.0.0.1:3306/db1";
String username = "root";
String password = "root";
//创建连接
Connection conn = DriverManager.getConnection(url,username,password);
//sql语句
String sql = "SELECT id,name,money FROM account";
//获取执行Sql的对象statement
Statement statement = conn.createStatement();
//获取sql语句返回的结果集,保存到resultSet中
ResultSet resultSet = statement.executeQuery(sql);
//打印数据
System.out.println("id name money");
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
Double money = resultSet.getDouble("money");
System.out.print(id+" ");
System.out.print(name+" ");
System.out.print(money+" ");
System.out.println();
}
}
案例
用集合保存sql select返回的结果集
jdbcdemo.java
public void select() throws Exception {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//需要连接的数据库url地址,以及登录数据库的用户名,密码
String url = "jdbc:mysql://127.0.0.1:3306/db1";
String username = "root";
String password = "root";
//创建连接
Connection conn = DriverManager.getConnection(url,username,password);
//sql语句
String sql = "SELECT id,name,money FROM account";
//获取操作sql的对象staement
Statement statement = conn.createStatement();
//获取sql语句返回的结果集
ResultSet resultSet = statement.executeQuery(sql);
//创建accountlist集合
List<Account> list = new ArrayList<Account>();
//打印数据
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
Double money = resultSet.getDouble("money");
//实例化account
Account account = new Account();
//保存id至account对象
account.setId(id);
//保存name至account对象
account.setName(name);
//保存money至account对象
account.setMoney(money);
//将当前的account对象保存到集合list
list.add(account);
}
//打印list
System.out.println(list);
}
Account.java
public class Account {
private Integer id;
private String name;
private double money;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getMoney() {
return money;
}
public void setMoney(double money) {
this.money = money;
}
//重写tuString
@Override
public String toString() {
return "Account [id=" + id + ", name=" + name + ", money=" + money + "]";
}
}