javascript - 键入时将数据插入数据库

Question

.我想在文本框中输入值时将数据插入数据库...我的ajax编码不起作用...即使我没有收到任何错误...

快来帮帮我

我的ajax编码是:

var userid = '#uid';
var datas = 'uid=' + $(userid).val();
$(document).ready(function() {
    $("#uid").on("keyup", function() {
        $ajax({
            type: "GET",
            contentType: "text/plain; charset=utf-8",
            url: "insert.jsp", //insert.jsp
            dataType: 'text',
            data: datas, //data to be sent as a parameter cname=babu&mobileno=9877&boxno=
            success: function(result) {
                alert(result);

            },
            error: function(XMLHttpRequest, textStatus, errorThrown) {

                alert("Error: " + textStatus + " HttpStatus: " + XMLHttpRequest.status + " " + errorThrown + "\n");
            }
        });
    });
});

我用于插入记录的jsp代码是:

  <%
String uid=request.getParameter("uid");
    Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","testing");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into insert1(usrid) values('"+uid+"')");
if(i>0){
    %>Inserted Successfully.... If you want to insert another value means then click here<a href="index.jsp">Insert</a>
    <p>Other Wise<a href="listuser.jsp">List User</a>
<%}else{%>
    The information you are entered is wrong<a href="index.jsp">Retry</a>
<%}%>

Answer 1

将该语句移至 keyup 事件处理程序内。这将获取 textbox 中键入的值，并通过 ajax 发送到服务器。

$("#uid").on("keyup", function() {
    var datas = 'uid=' + $(userid).val(); // Move inside event handler

您还可以使用$(this)来获取值:

var datas = 'uid=' + $(this).val();