数据库教程 jdbc

Java 和 数据库 连接技术
odbc:淘汰10年了。只能用在windows系统上
关于jdbc 的相关描述:
关于jdbc的实操七步:
package com.liuguangfa.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Date; public class Test2 { public static void main(String[] args) { Connection conn = null; try { // 1、测试数据库驱动是否存在 Class.forName("com.mysql.cj.jdbc.Driver"); // 2、获取数据库连接。参数1:数据库连接协议子浮窗。参数2:用户名。参数3:数据库密码 String url = "jdbc:mysql://localhost:3306/liuguangfa?charaterEncoding=UTF-8&useSSL=false&autoReconnect=true&serverTimeZone=Asia/Shanghai"; String username = "root"; String password = "123456"; conn = DriverManager.getConnection(url, username, password); // 3、创建传输sql指令载体 Statement statement = conn.createStatement(); // 4、向数据库服务器发送sql指令 String sql = "select id,stu_id,name,sex,birthday,pinyin,phone,email from t_student limit 20"; // 5、执行查询操作,返回结果集 ResultSet rs = statement.executeQuery(sql); // 6、对结果集进行操作 while (rs.next()) { Integer id = rs.getInt("id"); String stuId = rs.getString("stu_id"); String name = rs.getString("name"); Date birthday = rs.getDate("birthday"); String pinyin = rs.getString("pinyin"); String phone = rs.getString("phone"); String email = rs.getString("email"); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); System.out.println(id + ":" + stuId + ":" + name + ":" + sdf.format(birthday) + ":" + pinyin + ":" + phone + ":" + email); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { //7、关闭数据库连接 if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } }
作者为:刘广法,网站地址:https://liuguangfa.com/