javabean读写Oracle数据库问题
我用servlet来接受来自JSP页面的用户注册请求,然后在servlet中调用写数据库的javaBean,服务器使用weblogic,数据库使用Oracle。现在我首先开启weblogic服务器,然后开始在JSP页面写入用户的各种信息,提交表单,能正确在数据库中写入用户信息,但当我第二次使用这个注册页面来写入第二个用户的时候,却无法成功,JSP页面的进度条停滞很慢,无法写入数据库。这是什么原因呀?我的写数据库的代码:
public boolean setManagerInformation(String strName, String strSex,
String strPassword,
String strOrganization,
String strAddress, String strPhone,
String MobilePhone, String IdentityCard,
String strEmail, String strPostCode,
String PwdQuestion, String PwdAnswer) {
Driver myDriver = null;
Connection myConnection = null;
Statement statement = null;
try {
String driverName = "weblogic.jdbc.pool.Driver";
myDriver = (Driver) Class.forName(driverName).newInstance();
String driverURL = "jdbc:weblogic:pool:CoDesignPool";
myConnection = myDriver.connect(driverURL, null);
statement = myConnection.createStatement();
boolean flag = false;
/*得到了数据库的Statement*/
String strQueryIsExist = "select * from \"MANAGER\".\"MANAGER\"";
System.out.println(strQueryIsExist);
String ManagerIdentitycard;
ResultSet resultManagerUser = null;
resultManagerUser = statement.executeQuery(strQueryIsExist);
/*
if (resultManagerUser == null) {
System.out.println("OK");
}*/
/*查看项目负责人表是否已经有了该记录*/
while (resultManagerUser.next()) {
ManagerIdentitycard = resultManagerUser.getString("IDENTITYCARD");
System.out.println(ManagerIdentitycard);
if (ManagerIdentitycard == IdentityCard) {
flag = true;
}
}
resultManagerUser.close();
/*如果没有这条记录*/
if (!flag) {
System.out.print(flag);
String ID = new String();
String newID = new String();
int id;
String strQueryMaxManager = "select " + "\"MANAGER\"" + "." +
"\"MAXMANAGER\"" + "." + "\"MAXUSER\" "
+ "from " + "\"MANAGER\"" + "." + "\"MAXMANAGER\"";
System.out.println(strQueryMaxManager + "\n");
ResultSet resultMaxUser = statement.executeQuery(strQueryMaxManager);
while (resultMaxUser.next()) {
ID = resultMaxUser.getString("MAXUSER");
System.out.println(ID + "\n");
}
/*访问最大项目负责人表得到现在的最大ID号*/
id = Integer.valueOf(ID).intValue();
id++;
newID = String.valueOf(id);
System.out.println(newID);
String strInsertUser;
strInsertUser = "INSERT INTO " + "\"MANAGER\"" + "." + "\"MANAGER\"" +
"(" +
"\"ID\"" + "," + "\"NAME\"" + ","
+ "\"PASSWORD\"" + "," + "\"CHARACTER\"" + "," + "\"ORGANIZATION\"" +
"," +
"\"ADDRESS\"" + "," + "\"PHONE\"" + "," + "\"MOBILEPHONE\""
+ "," + "\"EMAIL\"" + "," + "\"IDENTITYCARD\"" + "," +
"\"PWDQUESTION\"" + "," +
"\"PWDANSWER\"" + "," + "\"SEX\"" + "," + "\"POSTCODE\""
+ ")" + " VALUES " + "(" + "'" + newID + "'" + ",'" + strName + "'" +
",'" + strPassword + "'" + ",'" + "Manager" + "'"
+ ",'" + strOrganization + "'" + ",'" + strAddress + "'" + ",'" +
strPhone + "'" + ",'" + MobilePhone + "'" + ",'"
+ strEmail + "'" + ",'" + IdentityCard + "'" + ",'" + PwdQuestion +
"'" + ",'" + PwdAnswer + "'" + ",'" + strSex
+ "'" + ",'" + strPostCode + "'" + ")";
System.out.println(strInsertUser);
statement.execute(strInsertUser);
/*执行了用户的插入工作*/
String strUpdateMaxUser;
strUpdateMaxUser = "UPDATE " + "\"MANAGER\"" + "." + "\"MAXMANAGER\"" +
"SET " + "\"MAXUSER\"" + "=" + "'" + newID + "'";
statement.execute(strUpdateMaxUser);
return true;
}
else {
return false;
}
}
catch (Exception e) {
System.out.print(e.getMessage());
return false;
}
finally {
try {
if (statement != null) {
statement.close();
}
if (myConnection != null) {
myConnection.close();
}
}
catch (SQLException e) {
System.out.println("Error code=" + e.getErrorCode());
System.out.println("Error message =" + e.getMessage());
}
}
}
望各位大侠能给点帮助,急呀!!!