c mysql insert id_MySQL C ++连接器:获取insert_id

bd96500e110b49cbb3cd949968f18be7.png

I am using mysql connector C++. There is an auto_increament column in my table, I want to get the insert id when I perform an insert action. Does someone know how to get it? Thanks.

My code is something like:

conn->setAutoCommit(0);

pstmt.reset(conn->prepareStatement(insertStr.c_str()));

int updateCount = pstmt->executeUpdate();

conn->commit();

解决方案

If the API of the library you are using does not provide a method to retrieve the last_insert_id (which seems to be the case for the C++ Connector) you can always do a query

SELECT LAST_INSERT_ID();

which gives you the "value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most recently executed INSERT statement." See here for the explanation of MySQL's documentation

UPDATE:

I found this post from a user who is saying the if you do not use auto_increment on your field you can use

SELECT @@identity AS id;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,我会尽力回答你的问题。下面是一个简单的 MVC 登录实例,可以帮助你完成用户登录验证。 首先,我们需要创建一个名为 "User" 的 JavaBean 类,用于存储用户信息。该类应该包含以下属性: - username:用户名 - password:密码 接下来,我们需要创建一个名为 "UserDao" 的数据访问对象类,用于连接数据库并执行 CRUD 操作。该类应该包含以下方法: - login:根据用户名和密码进行登录验证 - register:注册新用户 然后,我们需要创建一个名为 "LoginServlet" 的控制器 Servlet 类,用于处理用户请求并返回响应。该类应该包含以下方法: - doGet:显示登录页面 - doPost:处理用户登录请求并返回响应 最后,我们需要创建一个名为 "login.jsp" 的视图页面,用于显示登录表单和处理用户输入。 下面是示例代码,仅供参考: User.java: ```java public class User { private String username; private String password; public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } } ``` UserDao.java: ```java public class UserDao { private Connection conn; public UserDao() { try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/test"; String username = "root"; String password = "root"; conn = DriverManager.getConnection(url, username, password); } catch (Exception e) { e.printStackTrace(); } } public boolean login(User user) { try { String sql = "SELECT * FROM user WHERE username=? AND password=?"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, user.getUsername()); pstmt.setString(2, user.getPassword()); ResultSet rs = pstmt.executeQuery(); return rs.next(); } catch (Exception e) { e.printStackTrace(); return false; } } public boolean register(User user) { try { String sql = "INSERT INTO user(username, password) VALUES (?, ?)"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, user.getUsername()); pstmt.setString(2, user.getPassword()); return pstmt.executeUpdate() > 0; } catch (Exception e) { e.printStackTrace(); return false; } } } ``` LoginServlet.java: ```java public class LoginServlet extends HttpServlet { private UserDao userDao; public void init() throws ServletException { userDao = new UserDao(); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String username = request.getParameter("username"); String password = request.getParameter("password"); User user = new User(); user.setUsername(username); user.setPassword(password); if (userDao.login(user)) { request.setAttribute("message", "登录成功"); } else { request.setAttribute("message", "登录失败"); } request.getRequestDispatcher("/WEB-INF/jsp/message.jsp").forward(request, response); } } ``` login.jsp: ```html <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Login</title> </head> <body> <h1>Login</h1> <form action="login" method="post"> <p> <label>Username:</label> <input type="text" name="username" required> </p> <p> <label>Password:</label> <input type="password" name="password" required> </p> <p> <button type="submit">Login</button> </p> </form> </body> </html> ``` message.jsp: ```html <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Message</title> </head> <body> <h1>${message}</h1> </body> </html> ``` 以上就是一个简单的 MVC 登录实例,希望能对你有所帮助。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值