JDBC(Java Data Base Connectivity,java数据库连接)是一种用于执行SQL语句的Java API,可以为多种关系数据库提供统一访问,它由一组用Java语言编写的类和接口组成。JDBC提供了一种基准,据此可以构建更高级的工具和接口,使数据库开发人员能够编写数据库应用程序。JDBC是用于java操作数据库,如完成数据库的连接,添加,修改,删除,查询等操作。
package com.ft.suanfa.demo0106; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class JDBCTest { //1.加载mysql驱动包 static { try { //1.加载mysql驱动包 Class.forName("com.mysql.jdbc.Driver"); //2.获取连接 } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { String url ="jdbc:mysql://localhost:3306/ssmdemo"; String username="root"; String password="root"; //2.获取链接 Connection conn = null; //3.预编译sql语句 PreparedStatement pst = null; //4.执行查询并返回ResultSet结果集 ResultSet rs = null; try { conn = DriverManager.getConnection(url, username, password); pst = conn.prepareStatement("select * from person"); rs = pst.executeQuery(); while(rs.next()) { System.out.print("id="+rs.getInt("id")+" "); System.out.print("name="+rs.getString("name")+" "); System.out.print("sex="+rs.getString("sex")+" "); System.out.print("age="+rs.getInt("age")+" "); System.out.print("rank="+rs.getString("rank")+" "); System.out.print("department="+rs.getString("department")+" "); System.out.println(); } rs.close(); System.out.println("结果集关闭成功"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { conn.close(); System.out.println("关闭成功"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } 打印输出: id=1 name=张三 sex=男 age=25 rank=1级 department=开发部 id=2 name=王五 sex=男 age=12 rank=2级 department=工程质量部 id=3 name=李四 sex=女 age=30 rank=5级 department=支持部 id=5 name=?? sex=? age=47 rank=???? department=?? id=6 name=?? sex=? age=47 rank=???? department=?? id=7 name=?? sex=? age=67 rank=???? department=?? 结果集关闭成功 关闭成功