YouTip

Tutorial -- 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 Scripting Languages Computer Science Web Design & Development Scripting Web Service Software Programming Programming Languages Development Tools Web Services <sql:param> Tag JSP Standard Tag Library The <sql:param> tag is used in conjunction with <sql:query> and <sql:update> tags to provide a value placeholder. If the value is null, the placeholder is set to SQL NULL. Syntax Format <sql:param value="<string>"/> Attributes The <sql:param> tag has the following attributes: Attribute Description Required Default value The parameter value to set. No Body Example Demonstration First, we 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 to use the <sql:update> tag to execute an SQL DELETE statement to delete the record with id=103: DELETE FROM Employees WHERE Id = ? SELECT * from Employees;

Emp ID	First Name	Last Name	Age

The result is as follows: Using the <sql:param> tag in SQL UPDATE and SELECT statements is similar to its usage in DELETE. JSP Standard Tag Library JSP Send Email JSP Database Connection ByteArk Coding Plan Supports mainstream large models like Doubao, GLM, DeepSeek, Kimi, MiniMax. Official supply, stable and reliable. Configuration Guide ¥9.9 / Month Activate Now iFlytek Spark 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 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 Formatter · Random Number Generator Latest Updates · AI Ethics and Safety · How AI Works · AI Tools Panorama · Prompt Engineering · Introduction to AI · AI Getting Started 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