链接数据库

  1.导入jdbc的jar包,并部署

            在工程名下,创建lib文件夹,放入jar包,build path

        2.加载驱动

            static{

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

                 }

        3.创建连接对象

String url = "jdbc:mysql://loclahost:3306/数据库名";

            String user = "root";

            String pwd  = "密码"

            Connection conn = DriverManager.getConnection(url,user,pwd);

        4.创建执行SQL语句的对象

            Statement st  =conn.createStatement();

        5.创建SQL语句

            5.1 增,删,改

                String sql = "" ;

            5.2 查询

                String sql = "select * from **";

        6.执行SQL语句

            6.1 增删改,返回受影响的行数

                int result = st.executeUpdate(sql);

            6.2 查询,返回的是一个结果集

                ResultSet rs = st.executeQuery(sql);

        7.对返回的结果进行处理

            7.1 增删改

                    if(result > 0){

             //操作成功

                    }

            7.2 查询

                    while(rs.next()){

                    int age = rs.getInt("列名");

                    String name = rs.getString("列名");

                        System.out.println(age+"  "+name);

                    //getXXX();

                    }

        8.释放资源,先使用的后关闭

            if(rs!=null){

            rs.close();

            }if(st!=null){

            st.close();

            }if(conn!=null){

            conn.close();

            }