Web Front-end
HTML Tutorial
There is a problem with servlet writing to the database_html/css_WEB-ITnose
There is a problem with servlet writing to the database_html/css_WEB-ITnose
public void insert(HttpServletRequest request, HttpServletResponse response) throws SQLException, ClassNotFoundException { Connection conn = connection(); Statement sta = conn.createStatement(); String name = request.getParameter("name"); String id = request.getParameter("id"); String password = request.getParameter("password"); String age = request.getParameter("age"); String company = request.getParameter("company"); System.out.println(name + id + password +age +company); sta.execute ("insert into user.manage (name,id,password,age,company) values("+name+","+id+","+password+","+age+","+company+")"); // 蓝色的都是以文本的形式传递，黑色的则是以值的形式传递 close(sta, conn); }This is the code inserted by the control layer servlet
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><form method="post" action="New2"><input type="hidden" name="methodName" value="0"/> <!--隐藏的按钮，servlet用它来进行判断 --> <h4>姓名： <input type="text" name="name"/> </h4> <h4>编号： <input type="text" name="id"/> </h4> <h4>密码： <input type="text" name="password"/> </h4> <h4>年龄： <input type="text" name="age"/> </h4> <h4>部门： <input type="text" name="company"/> </h4> <input type="submit" value="确定输入" /></form></body></html>
This is the view layer HTML code. I don’t know if there is something wrong with the code or something. The input parameters can reach the servlet. System.out.println(name id password age company); There is output, but no data is added to the database, what is the situation~~
Reply to the discussion (solution)
Try it
String SQL="insert into user.manage (name,id,password,age,company) values('"+name+"','"+id+"','"+password+"','"+age+"','"+company+"')";sta.executeUpdate(SQL); Try
String SQL="insert into user.manage (name,id,password,age,company) values('"+name+"','"+id+"','"+password+"','"+age+"','"+company+"')";sta.executeUpdate(SQL);Corresponding to the column type of user.manage table, change Change the value in values. If it is a number, you don’t need single quotes
Try
String SQL="insert into user.manage (name,id,password,age,company) values('"+name+"','"+id+"','"+password+"','"+age+"','"+company+"')";sta.executeUpdate(SQL);System.out.print SQL,
Put the output sql in SQL IDE and try if there are any errors
Try
String SQL="insert into user.manage (name,id,password,age,company) values('"+name+"','"+id+"','"+password+"','"+age+"','"+company+"')";sta.executeUpdate(SQL);System.out.print SQL,
Put the output sql in SQL IDE and try to see if there are any errors
Error on the controller, the data was deleted after it came in~~~
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update?
Mar 04, 2025 pm 12:32 PM
The official account web page update cache, this thing is simple and simple, and it is complicated enough to drink a pot of it. You worked hard to update the official account article, but the user still opened the old version. Who can bear the taste? In this article, let’s take a look at the twists and turns behind this and how to solve this problem gracefully. After reading it, you can easily deal with various caching problems, allowing your users to always experience the freshest content. Let’s talk about the basics first. To put it bluntly, in order to improve access speed, the browser or server stores some static resources (such as pictures, CSS, JS) or page content. Next time you access it, you can directly retrieve it from the cache without having to download it again, and it is naturally fast. But this thing is also a double-edged sword. The new version is online,
How do I use HTML5 form validation attributes to validate user input?
Mar 17, 2025 pm 12:27 PM
The article discusses using HTML5 form validation attributes like required, pattern, min, max, and length limits to validate user input directly in the browser.
How to efficiently add stroke effects to PNG images on web pages?
Mar 04, 2025 pm 02:39 PM
This article demonstrates efficient PNG border addition to webpages using CSS. It argues that CSS offers superior performance compared to JavaScript or libraries, detailing how to adjust border width, style, and color for subtle or prominent effect
What are the best practices for cross-browser compatibility in HTML5?
Mar 17, 2025 pm 12:20 PM
Article discusses best practices for ensuring HTML5 cross-browser compatibility, focusing on feature detection, progressive enhancement, and testing methods.
What is the purpose of the <datalist> element?
Mar 21, 2025 pm 12:33 PM
The article discusses the HTML <datalist> element, which enhances forms by providing autocomplete suggestions, improving user experience and reducing errors.Character count: 159
What is the purpose of the <meter> element?
Mar 21, 2025 pm 12:35 PM
The article discusses the HTML <meter> element, used for displaying scalar or fractional values within a range, and its common applications in web development. It differentiates <meter> from <progress> and ex
How do I use the HTML5 <time> element to represent dates and times semantically?
Mar 12, 2025 pm 04:05 PM
This article explains the HTML5 <time> element for semantic date/time representation. It emphasizes the importance of the datetime attribute for machine readability (ISO 8601 format) alongside human-readable text, boosting accessibilit
What is the purpose of the <progress> element?
Mar 21, 2025 pm 12:34 PM
The article discusses the HTML <progress> element, its purpose, styling, and differences from the <meter> element. The main focus is on using <progress> for task completion and <meter> for stati
