使用JDBC连接数据库的步骤

                            //第一步，加载驱动

                            Class.forName("oracle.jdbc.driver.OracleDriver");

                            //第二步，获取连接的对象

                            Stringurl ="jdbc:oracle:thin:@localhost:1521:orcl";

                            Stringuser = "bbs";

                            Stringpwd ="123";

                            Connectioncon = DriverManager.getConnection(url, user, pwd);

                            //第三步，构建命令对象

                            Statement  stm = con.createStatement();

                            Stringsql = "Select * "+

                            "From userinfo "+

                            "Where username='"+strName+"' and userpwd ='"+strPwd+"'";

                            System.out.println(sql);

                            //获取从数据库表得到的查询数据，存放在类似于数据表的内存中

                            ResultSetrowSet = stm.executeQuery(sql);

                            booleanifLogin = false;

                            while(rowSet.next()){//如果有数据，通过循环的方式读取

                                     System.out.println("读取的用户名:"+rowSet.getString("username"));

                                ifLogin = true;//说明是有数据，用户名和密码正确

                            }

                            rowSet.close();

                            con.close();