在resin2.1.9+mysql中向数据库中添加记录时同时出现两条相同的记录???
Johwu 2003-08-29 11:16:56 我的部分代码:
user_addok.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="info.Infodb" />
<jsp:useBean id="util" scope="page" class="info.UtilBean" />
<%
String admin=(String)session.getValue("admin");
String username=request.getParameter("username");
String password=util.makeHacker(request.getParameter("password"));
String about=request.getParameter("about");
if(username==null||password==null||admin==null)
{ response.sendRedirect("index.jsp");}
else
{
//String sql="insert into tbuser(userName,password,about) values('"+username+"','"+password+"','"+about+"')";
db.addUser(username,password,about);
response.sendRedirect("user_list.jsp");
}
%>
我的数据库bean:
package info;
import java.sql.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import info.UtilBean;
import info.DBConnectionManager;
public class Infodb {
private DBConnectionManager connMgr;
private String CONNECTION_NAME="infodb";
private UtilBean util=new UtilBean();
public Infodb() throws Exception {
connMgr=DBConnectionManager.getInstance();
}
public void addUser(String username,String password,String about) throws SQLException {
password=util.makeHacker(password);
String strSQL="insert into tbuser(userName,password,about) values('"+username+"','"+password+"','"+about+"')";
Connection conn = connMgr.getConnection(CONNECTION_NAME);
Statement stmt = conn.createStatement();
stmt.executeUpdate(strSQL);
connMgr.freeConnection(CONNECTION_NAME,conn);
}
}