1)第一步:加载驱动
2)第二部:创建数据库连接
3)第三步:定义SQL执行语句
4)第四步:执行SQL语句
5)第五步:处理执行结果
6)第六步:释放资源
图示:
代码:
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class test13 { public static void main(String[] args) throws Exception { Class.forName("com.mysql.cj.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sqltest?serverTimezone=UTC","root","123456"); String user = "小明"; String sql = "select * from user where name = '"+user+"'"; PreparedStatement sta = con.prepareStatement(sql); ResultSet rs = sta.executeQuery(); while (rs.next()){ System.out.println(rs.getString("id")); System.out.println(rs.getString("name")); } rs.close(); sta.close(); con.close(); } }