JDBC编程六步

public class JDBCTest01{
    public static void main(String[] args){
Statement stmt =null;
Connection conn = null;
ResultSet rs = null;
        try{
                //第一步 注册驱动
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        /*
            Driver driver = new com.mysql.jdbc.Driver();
            DriverManager.registDriver(driver);
        */
                //第二步 获取连接 
String url = "jdbc:mysql://localhost:3306/bjpowernode";
String user = "root";
String password = "1333";
 conn = DriverManager.getConnection(url,user,password);

                //第三步 获取数据库操作对象(Statement专门执行sql语句的)
stmt = conn.createStatement();

                //第四步 执行sql  （insert delete update）
 
String sql = "insert into dept(deptno,dname,loc) value(50,'人事部','北京')";
int count = stmt.executeUpdate(sql);
system.out.println(count==1?"成功","失败")

    /*
//(show/selet)
rs = stmt.executeQuery(sql);
                //第五步 处理查询结果
boolean falg1 = rs.next();
if(falg1){
String empon  = rs.getString(1);
String ename = rs.getString(2);
String sal = rs.getString(3);
System.out.println(empon+","+ename+","+sal);
}
//循环：
while(rs.next){
String empon  = rs.getString(1);
String ename = rs.getString(2);
String sal = rs.getString(3);
System.out.println(empon+","+ename+","+sal);
}
        */

catch(SQLException e){
    e.printStackTtace();//声明异常
}
finally{
                //第六步 释放资源
//在finally语句块中关闭资源
//遵循从小到大依次关闭
//分别对其try......catch
try{
if(stmt != null)
    stmt.close();
}catch(SQLException e){
    e.printStackTtace();//声明异常
}
try{ 
if(conn != null)
    conn.close();
}catch(SQLException e){
    e.printStackTtace();//声明异常
}

}        
            
  }
}