jdbc笔记

         1.jdbc是什么，它有什么用?

                   javadatabase connection

                   让java程序员可以直接通过java程序操作数据.

    jdbc是标准，它是由类与接口组成，对于程序员只需要知道标准(Connection Statement PreparedStatement,ResultSet)

                   不需要了解具休实现就可以操作数据库。

         2.jdbc入门代码

                   导入jar包

                   1.注册驱动

                            DriverManager.registDriver(Driverdirver);

                            不使用这种方式，使用反射

                            Class.forName("com.mysql.jdbc.Driver");

                   2.获取连接Connection

                            Connectioncon=DriverManager.getConnection(String url,String username,String password);

                   3.获取操作sql对象  Statement

                            Statementst=con.createStatement();

                            如果要得到滚动结果集，可以使用createStatement(int,int);                                       

                   4.操作sql

                            DQL语句

                                     ResultSetrs=st.executeQuery(String sql);

                           

                            DML语句

                                     introw=st.executeUpdate(String sql);

                   5.遍历结果集

                            while(rs.next()){

                                     rs.getInt(intcoulumnIndex);

                                     rs.getString(StringcolumnName);

                            }

                   6.释放资源

                            rs.close();

                            st.close();

                            con.close();

                           

         ----------------------------------------------

         PreparedStatement

                   1.怎样获取?

                            PreparedStatementpst=con.prepareStatement(String sql);

 

                   2.怎样给占位符"?"赋值        

                            pst.setXxx(int,value)

                           

                   3.执行

                            pst.executeQuery();

                            pst.executeUpdate();