1.1 jdbc编程步骤
1.加载数据库驱动
2.创建并获取数据库连接对象
3.创建jdbc statement对象
4.设置sql语句
5.设置sql语句中的参数(使用preprementStatement)
6.通过statement执行sql并获取结果
7.对sql执行结果进行解析处理
8.释放资源(resultSet、prepareStatement、connection)
----code------
public static void main(String[] args) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try {
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//通过驱动管理类获取数据库连接
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8","root","root");
//定义sql语句 ?表示占位符
String sql = "select * from user where username = ?";
//获取预处理statement
preparedStatement = connection.preparedStatement(sql);
//设置参数,第一个参数为sql语句中参数的序号(从1开始),第二个参数为设置的参数值
preparedStatement.setString(1,"isaide");
//向数据发出sql执行查询,查询出结果就
resultSet = preparedStatement.executeQuery();
//遍历查询结果集
while(resultSet.next()) {
System.out.println(resultSet.getString("id")+resultSet.getString("username"));
}
} catch (Exception e) {
e.printStackkTrace();
}finally {
//释放资源
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLExection e) {
e.printStackkTrace();
}
}
if (preparedStatement != null) {
try {
preparedStatement.close();
} catch (SQLExection e) {
e.printStackkTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLExection e) {
e.printStackkTrace();
}
}
}
}