【Java EE_java连接、操作数据库（简易版）】

导入对应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 + "]";
	}
	
}