//此连接是针对于mysql的连接
public class MybatisJdbcConnection {
public static void main(String[] args){Connection conn = null;
ResultSet res = null;
PreparedStatement prepareStatement=null;
try {
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//获得数据库连接池
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8", "root", "root");
//定义sql语句
String sql = "select * from user where username = ?";
//得到预处理statement
prepareStatement = conn.prepareStatement(sql);
//设置参数,?代表的是需要查询的条件也就是参数从1开始,有几个就设置几个
prepareStatement.setString(1, "王五");
//向数据库发出sql执行查询 ,查询出结果集
res = prepareStatement.executeQuery();
//遍历结果集
while(res.next()){
String userid = res.getString("id");
String username = res.getString("username");
System.out.println("..."+userid+"...."+username+"....");
}
} catch (Exception e) {
e.printStackTrace();
}finally{
//释放资源
if(res!=null){
try {
res.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(prepareStatement!=null){
try {
prepareStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}