YouTip

-- Learning not just technology, but dreams! Home HTML JAVASCRIPT CSS VUE REACT PYTHON3 JAVA C C++ C# AI GO SQL LINUX VS CODE BOOTSTRAP GIT Local Bookmarks JSP Tutorial JSP Tutorial JSP Introduction JSP Development Environment Setup Eclipse JSP/Servlet JSP Structure JSP Life Cycle JSP Syntax JSP Directives JSP Action Elements JSP Implicit Objects JSP Client Request JSP Server Response JSP HTTP Status Codes JSP Form Processing JSP Filters JSP Cookie Handling JSP Session JSP File Upload JSP Date Processing JSP Page Redirection JSP Hit Counter JSP Auto Refresh JSP Send Email JSP Advanced Tutorial JSP Standard Tag Library (JSTL) JSP Database Connection JSP XML Data Processing JSP JavaBean JSP Custom Tags JSP Expression Language JSP Exception Handling JSP Debugging JSP Internationalization JSP Send Email JSP Database Connection Deep Dive Web Design & Development Development Tools Programming Languages Programming Web Service Software Web Services Scripts Scripting Languages Computer Science Tag JSP Standard Tag Library The tag is used to run SQL SELECT statements and to store the results in a scope variable. Syntax <sql:query var="" scope="" sql="" dataSource="" startRow="" maxRows=""/> Attributes The tag has the following attributes: Attribute Description Required Default sql The SQL command to execute (returns a ResultSet object) No Body dataSource The database connection to use (overrides the default) No Default database maxRows Maximum number of results to store in the variable No Unlimited startRow The row number to start retrieving results from No 0 var The variable representing the database results No Default setting scope The scope of the var attribute No Page Program Example First, you need to create an Employees table in the TEST database and then add a few records to it. The specific steps are as follows: Step 1: Open CMD and change the directory to the installation directory: C:> C:>cd "Program FilesMySQLbin" C:Program FilesMySQLbin> Step 2: Log in to the database: C:Program FilesMySQLbin>mysql -u root -p Enter password: ******** mysql> Step 3: Create the Employees table in the TEST database: mysql> use TEST; mysql> create table Employees ( id int not null, age int not null, first varchar (255), last varchar (255) ); Query OK, 0 rows affected (0.08 sec) mysql> Create Data Records: Finally, create a few records in the Employees table: mysql> INSERT INTO Employees VALUES (100, 18, 'Zara', 'Ali'); Query OK, 1 row affected (0.05 sec) mysql> INSERT INTO Employees VALUES (101, 25, 'Mahnaz', 'Fatma'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employees VALUES (102, 30, 'Zaid', 'Khan'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employees VALUES (103, 28, 'Sumit', 'Mittal'); Query OK, 1 row affected (0.00 sec) mysql> Now, write a JSP file that uses the tag to execute an SQL SELECT statement: SELECT * from Employees;

Emp ID	First Name	Last Name	Age

The result is as follows: JSP Standard Tag Library JSP Send Email JSP Database Connection ByteArk Coding Plan Supports mainstream large models like Doubao, GLM, DeepSeek, Kimi, MiniMax, officially supplied, stable and reliable. Configuration Guide ¥9.9 / month Activate Now iFlytek Stardust Coding Plan Includes free model call quota, DeepSeek, GLM, Kimi, MiniMax, one-stop experience and deployment platform. Configuration Guide ¥3.9 / month Activate Now Click here to share notes Category Navigation Python / Data Science AI / Intelligent Development Front-end Development Back-end Development Database Mobile Development DevOps / Engineering Programming Languages Computer Fundamentals XML / Web Service .NET Website Building Advertisement JSP Tutorial JSP Tutorial JSP Introduction JSP Development Environment Setup Eclipse JSP/Servlet JSP Structure JSP Life Cycle JSP Syntax JSP Directives JSP Action Elements JSP Implicit Objects JSP Client Request JSP Server Response JSP HTTP Status Codes JSP Form Processing JSP Filters JSP Cookie Handling JSP Session JSP File Upload JSP Date Processing JSP Page Redirection JSP Hit Counter JSP Auto Refresh JSP Send Email JSP Advanced Tutorial JSP Standard Tag Library (JSTL) JSP Database Connection JSP XML Data Processing JSP JavaBean JSP Custom Tags JSP Expression Language JSP Exception Handling JSP Debugging JSP Internationalization Online Examples ·HTML Examples ·CSS Examples ·JavaScript Examples ·Ajax Examples ·jQuery Examples ·XML Examples ·Java Examples Character Sets & Tools · HTML Character Set Settings · HTML ASCII Character Set · JS Obfuscation/Encryption · PNG/JPEG Image Compression · HTML Color Picker · JSON Formatting Tool · Random Number Generator Latest Updates · AI Ethics and Safety · How AI Works · AI Tool Landscape · Prompt Engineering · Introduction to AI · AI Beginner's Tutorial · Large Model Multimodal (M... Site Information · Feedback · Disclaimer · About Us · Article Archive Follow WeChat My Favorites Bookmark Article Browsing History Clear All No records yet