输入数据存不进MYsql数据库。

img


连接代码，JavaBean工具


package ch74;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class UserManager {
    public void insert(UserBean user) {
        try {
             String userName="root"; 
               //密码 
               String userPasswd="020301"; 
               //数据库名 
               String dbName="db1"; 
               //表名 
               String tableName="user"; 
               //联结字符串 
               String url="jdbc:mysql://localhost/"+dbName+"?serverTimezone=UTC&user="+userName+"&password="+userPasswd; 
               Class.forName("com.mysql.cj.jdbc.Driver"); 
               Connection conn=DriverManager.getConnection(url); 
                  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
               stmt.executeUpdate("INSERT into user(name,sex)"+"values('"+user.getName()+"','" +user.getSex() + ",'"+ user.getAddress()+"')");
               stmt.close();
               conn.close();
        }catch(ClassNotFoundException e){
            System.out.println("驱动程序类异常，加载出错！<br>");
            System.out.println(e.getMessage());
        } catch(SQLException e){
            System.out.println("数据库连接或SQL查询异常！<br>");
            System.out.println(e.getMessage());
        } catch(Exception e){
            System.out.println("出现其他异常！<br>");
            System.out.println(e.getMessage());
        }
}
public List<UserBean> getList(){
        try {
             String userName="root"; 
               //密码 
               String userPasswd="020301"; 
               //数据库名 
               String dbName="db1"; 
               //表名 
               String tableName="user"; 
               //联结字符串 
               String url="jdbc:mysql://localhost/"+dbName+"?serverTimezone=UTC&user="+userName+"&password="+userPasswd; 
               Class.forName("com.mysql.cj.jdbc.Driver"); 
               Connection conn=DriverManager.getConnection(url); 
                  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
               ResultSet rs = stmt.executeQuery("select * from user");
               List<UserBean> list = new ArrayList<UserBean>();
               while(rs.next())
               {
                   UserBean ubean = new UserBean();
                   ubean.setName(rs.getString(1));
                   ubean.setSex(rs.getString(2));
                   ubean.setAddress(rs.getString(3));
                   list.add(ubean);
               }
               rs.close();
               stmt.close();
               conn.close();
               return list;
        }catch(ClassNotFoundException e){
            System.out.println("驱动程序类异常，加载出错！<br>");
            System.out.println(e.getMessage());
        } catch(SQLException e){
            System.out.println("数据库连接或SQL查询异常！<br>");
            System.out.println(e.getMessage());
        } catch(Exception e){
            System.out.println("出现其他异常！<br>");
            System.out.println(e.getMessage());
    }
        return null;
}
}
    



Servlet使用
```java
package ch74;

import java.io.IOException;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * Servlet implementation class AddressServlet
 */
@WebServlet("/AddressServlet")
public class AddressServlet extends HttpServlet {
    

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        String name = request.getParameter("name");
        String sex = request.getParameter("sex");
        String address = request.getParameter("address");
        UserBean user = new UserBean();
        user.setName(name);
        user.setSex(sex);
        user.setAddress(address);
        UserManager UM=new UserManager();
        UM.insert(user);
        List<UserBean> list = UM.getList();
        HttpSession session=request.getSession();
        session.setAttribute("user", list);
        RequestDispatcher dispatcher = request.getRequestDispatcher("display.jsp");
        dispatcher.forward(request, response);
    }
}

```

UserManager的27行sql拼接，values前面是不是少个空格

img