请帮我看看报错是什么意思,怎么改
代码如下:
package web;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class AddEmpServlet extends HttpServlet {
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 设置中文的输入和输出
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
// 获取输出流对象,并输出信息
PrintWriter out = response.getWriter();
// 获取表单提交的数据
String name = request.getParameter("name");
double salary = Double.valueOf(request.getParameter("salary"));
int age = Integer.valueOf(request.getParameter("age"));
//将数据插入到数据库t_emp表中
Connection conn = null;
PreparedStatement stat = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(
"jdbc:sqlserver://192.168.2.196:1433;databaseName=library", "hz", "hz.98");
stat = conn.prepareStatement("insert into t_emp values" +
"(emp_id_seq.nextval,?,?,?)");
stat.setString(1, name);
stat.setDouble(2, salary);
stat.setInt(3, age);
stat.executeUpdate();
out.println("添加成功");
} catch (Exception e) {
e.printStackTrace();
out.print("系统繁忙,稍后重试");
} finally{
if(stat!=null){
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
这是一个servlet类。请帮我看看怎么改错
这是报错。由于本人新手。看不懂 。麻烦各位了
com.microsoft.sqlserver.jdbc.SQLServerException: 无法绑定由多个部分组成的标识符 "emp_id_seq.nextval"。