JavaWeb之JDBC连接数据库

JDBC查询数据库

package com.zpark.protogenesis;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.zpark.bean.User;

public class ProtogenesisMybatis {

	public static void main(String[] args) throws Exception {
		loadDriver();
	}

	public static void loadDriver() throws ClassNotFoundException, Exception {

		// 加载驱动
		Class.forName("com.mysql.cj.jdbc.Driver");
		// 创建连接
		String url = "jdbc:mysql://localhost:3306/mydb?useSSl=false&serverTimezone=GMT";
		String username = "root";
		String password = "root";
		Connection connection = DriverManager.getConnection(url, username, password);
		// 编写sql语句
		String sql = "select * from user";

		// 执行
		//Statement statement = connection.createStatement();
		PreparedStatement statement = connection.prepareStatement(sql);
		// 返回结果集
		ResultSet resultSet = statement.executeQuery(sql);
		//new 一个bean类用来存放数据
		User user = new User();
		//遍历结果集，利用实体类中的toString方法将结果打印在控制台上
		while (resultSet.next()) {

			//调用属性的set方法
			user.setId(resultSet.getInt(1));
			user.setUsername(resultSet.getString(2));
			user.setBirthday(resultSet.getDate(3));
			user.setAddress(resultSet.getString(5));
			user.setSex(resultSet.getString(4));
			System.out.println(user);
		}
	}
}

实体类

package com.zpark.bean;

import java.util.Date;

public class User {

	private int id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", birthday=" + birthday + ", sex=" + sex + ", address="
				+ address + "]";
	}
	
	
}

数据库建表语句

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL COMMENT '用户名称',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `sex` char(1) DEFAULT NULL COMMENT '性别',
  `address` varchar(256) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8