java报错列名无效_java web添加记录时候说列名无效是怎么回事，但可以数字没有问题，就是不能添加其他字符？...

代码如下：packagecom.mrs.servlet;importjava.io.IOException;importjava.io.PrintWriter;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStateme...

代码如下：

package com.mrs.servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class Add extends HttpServlet

{

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException

{

String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String username1 = request.getParameter("username");

String password1 = request.getParameter("password");

PrintWriter out = response.getWriter();

try

{

Class.forName(driver);

String url = "jdbc:sqlserver://localhost:1433;DatabaseName=jdbcTest";

String user = "test";

String pwd = "123456";

Connection conn = DriverManager.getConnection(url, user, pwd);

String sql = "insert into UserInfo (userName,passWord) values (" + username1 + "," + password1 +")";

PreparedStatement pre1 = conn.prepareStatement(sql);

int rs = pre1.executeUpdate();

if(0 != rs)

{

out.print("

添加成功");

out.println("

数据添加成功
");

out.print("");

}

else

{

out.print("

添加失败");

out.println("

数据添加失败
");

out.print("");

}

out.flush();

out.close();

pre1.close();

conn.close();

} catch (Exception ex)

{

// TODO Auto-generated catch block

ex.printStackTrace();

}

}

}

展开