数据库连接池相关文章标题

JDBC入门

---

        import java.sql.Connection;
        import java.sql.DriverManager;
        import java.sql.ResultSet;
        import java.sql.Statement;
        import org.junit.Test;

        /*
         * JDBC入门程序 JDBC数据库的驱动
         */
        public class JDBCDemo1 {
            @Test
            public void demo1() throws Exception{
                //1.加载驱动
                Class.forName("com.mysql.jdbc.Driver");
                //2.获得链接
                Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/web_test","root","root");
                //3.执行操作
                //3.1 获得执行sql语句的对象
                Statement statement = conn.createStatement();
                //3.2 编写sql语句
                String sql = "select * from user";
                //3.3 执行sql语句
                ResultSet rs = statement.executeQuery(sql);
                //3.4 遍历结果集
                while(rs.next()){

                }
                //4.释放资源
                rs.close();
                statement.close();
                conn.close();
            }


        }