JDBC
手动编写jdbc代码
流程部分:
1.导入jdbc相关的包;
2.加载jdbc驱动;
3.通过DriverManager获取一个Connection连接;
4.创建Statement / PreparedStatement 接口,执行sql;
5.创建一条sql;
6.执行sql,处理结果;
7.关闭资源;
代码部分:
public class JdbcTest{
private static final String url = "jdbc:mysql://127.0.0.1:3306/jdbc_test?useUnicode=true&characterEncoding=utf8";
private static final String driverClassName = "com.mysql.jdbc.Driver";
private static final String username = "root";
private static final String password = "root";
//测试jdbc连接
@Test
public void test1()
{
Connection conn = null;
Statement statement = null;
try{
//初始化驱动
Class.forName(driverClassName);
//获取一个连接
conn = DriverManager.getConnection(url,username,password);
//创建一个statement
statement = conn.createStatement();
//创建一条sql
String sql = "insert into t_user values (null,"+"'tom')";
//执行sql
statement.execute(sql);
log.info("插入成功");
//关闭资源
conn.close();
statement.close();
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}catch(SQLException ex){
ex.printStackTrace();
}finally{
//出现异常后,关闭资源
if(Optional.ofNullable(conn).isPresent())
{
conn.close();
}
if(Optional.ofNullable(statement).isPresent())
{
statement.close();
}
}
}
}