JDBC简化6步骤

import java.sql.*;
public class Test01{
public static void main(String[] args){
Connection conn=null;
Statement stmt=null;
try{

1. 注册驱动
   DriverManager.registerDriver=new(com.mysql.jdbc.Driver());
   2.获取链接
   conn=DriverManager(“jdbc:mysql:http://172.0.0.1//ab”);
   3.获取数据库操作对象
   stmt=conn.createment();
   4.执行sql语句
   String dlt=“delete no from “dpn” where no=1”;
   5.释放资源
   }
   catch(SQLException e)
   {
   e.printStackTrace;
   }finally{
   try{
   if(stmt!=null)
   stmt.close();
   }catch(SQLException e){
   e.printStackTrace;
   }
   try{
   if(conn!=null)
   conn.close();
   }catch(SQLException e){
   e.printStackTrace;
   }
   }
   }
   }