JDBC的初步使用

首先是往项目中导入JDBC的jar包
右键选择Add as Library

基本步骤：
1.导入jar包
2.加载驱动
3.获取数据库连接对象
4.定义sql语句
5.获取执行sql对象
6.执行sql语句
7.处理结果
8.施放资源

下列写法是抛出异常的写法

		 private static void demo() throws ClassNotFoundException, SQLException 
        //1.导入jar包
        //2.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //3.获取数据库连接对象
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb2", "root", "aqswdefr");
        //4.定义sql语句
        String sql = "insert into student value(3,'ppl',33)";
        String sql2 = "delete from student where id =3";
        //5.获取执行sql对象
        Statement stat = conn.createStatement();
            //6.执行sql语句
        //execute();可以执行所有sql语句；
        //exeuteUpdate():可以执行DML（insert，update,delete）,DDL(create,drop,alter);
        //executeQuery:DML(select)
        int i = stat.executeUpdate(sql2);
        //7.处理结果
        System.out.println(i);
        //8.施放资源
        stat.close();
        conn.close();
    }

sql的调优：select * 尽量不要使用。
这种方法是使用try catch来完成，自己处理异常，和对上面代码的优化。

 public static void main(String[] args)  {
        //demo();
        Connection conn = null;
        Statement stat = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
             conn = DriverManager.getConnection("jdbc:mysql:///mydb2", "root", "aqswdefr");
             String sql = "update student set age =15 where id = 1";
             stat = conn.createStatement();
             rs = stat.executeQuery(sql);
            while (rs.next()) {
                int id = rs.getInt("id");
                String user = rs.getString("name");
                int age = rs.getInt("age");
                System.out.println(id+"============"+user+"==========="+"age");
            }
            int count = stat.executeUpdate(sql);
            if (count > 0) {
                System.out.println("修改成功");
            }
            else {
            System.out.println("修改失败");
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }catch (SQLException e){
            e.printStackTrace();
        }finally {
            try {
                if(stat!=null){
                stat.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }