1.在项目中导入java.sql包
2.加载数据库驱动程序
Class.forName(“com.mysql.jdbc.Driver”);
3.定义数据库的链接地址
String url=“jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8”;
String databasename=“root”;
String password=“123456”;
4.得到与数据库的连接对象
conn = DriverManager.getConnection(url,databasename,pass);
5.声明sql语句
select * from emp where ename=? and password=?
6.获取PreparedStatement对象
PreparedStatement ps = conn.prepareStatement(“select * from emp where ename=? and password=?”);
7.给占位符赋值
ps.setString(1,name);
ps.setString(2,password);
8.执行sql
ResultSet rs = ps.executeQuery();
9.处理sql语句的返回结果
10.关闭对象
JDBC链接数据库步骤
最新推荐文章于 2024-05-21 22:30:15 发布