Mybatis
JDBC
jdbc实现步骤
使用jdbc实现数据库的连接
public class JDBCDemoTest {
private Connection conn;
private PreparedStatement statement;
private ResultSet resultSet;
@Test
public void jdbcTest(){
try{
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获取连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/abc?characterEncoding=utf-8","root","root");
//定义SQL语句
String sql = "select * from student";
//获取预处理
statement = conn.prepareStatement(sql);
//执行语句,将SQL放松给数据库
resultSet = statement.executeQuery();
//处理结果
while (resultSet.next()){
System.out.println(resultSet);
}
}catch (Exception e){
e.printStackTrace();
}finally {
try {
resultSet.close();
statement.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
}