<%@page import="com.tedu.util.DBBean"%>
<%@page import="com.tedu.pojo.User"%>
<%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="db" class="com.tedu.util.DBBean" scope="page"/>
<%
request.setCharacterEncoding("utf-8");
String username=(String)request.getParameter("username");
String password=(String)request.getParameter("password");
String sqlf="select * from tb_user where username ="+"'"+username+"'";
String sqlc="insert into user(username,password) values('"+username+"','"+password+"')";
ResultSet rs = db.stmt.executeQuery(sqlf);
if(rs.next()){
out.print("<script language='javascript'> alert('账号已经存在');</script>");
response.setHeader("refresh", "0;url=zhuce.jsp");
}
else{
db.stmt.executeUpdate(sqlc);
response.sendRedirect("zhucesu.jsp");
}
%>
</body>
</html>
代码是这样的, db.stmt.executeUpdate(sqlc);这句报错,
有没有大佬知道什么原因