JDBC初步

来源：互联网发布：android获取mac地址编辑：程序博客网时间：2024/06/03 20:37

Java Data Base Connectivity

JDBC编程步骤：

1.Load the Driver

Class.forName() | Class.forName().newInstance() | new DriverName()

2.Connect to Database

DriverManager.getConnection()

3.Execute SQL

Connection.createStatement();

Statement.executeQuery(); //查询

Statement.executeUpdate(); //增、删、改

4.Retrieve the result data

循环取得结果 while(ResultSet.next())

5.Show result data

将数据库中的各种类型转换为Java中的类型

6.Close

close ResultSet / close Statement /close Connection

示例：

import java.sql.*;public class example {public void getConnection() throws Exception{Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc","root","root");Statement stmt = conn.createStatement();String sql = "select * from TableName";ResultSet rs = stmt.executeQuery(sql);while(rs.next()){String name = rs.getString(1);}rs.close();stmt.close();conn.close();}}

0 0