Kangaroo, спасибо за ответ! жаль, что код ManagementSystem.java там не полный :(
я пытаюсь сделать свой код, но всеравно не получается.. Когда я нажимаю на кнопку, чтобы сохранить данные, страница зависает и eclipse открывает debug :(
Я хотела бы что бы данные после сохранения отображались пользователю, кроме пароля.. Когда запускаю код без authBean.java, то пользователю показываются введенные данные, а с authBean.java никак не получается сохранить :(
помогите, пожалуйста, заставить код сохранять введенные данные в mysql, а то я уже с ним замучалась :(
Ниже коды..
| Код |
package foo;
import foo.FormBean;
import java.sql.*;
import java.util.Vector;
import javax.servlet.jsp.JspWriter;
public class authBean {
Connection connection = null;
public authBean() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost/regisster?user=root&password=pass");
}
catch (Exception e) { System.out.println(e.getMessage()); }
}
public FormBean addUser(String firstName, String lastName, String email, String userName, String password1, JspWriter out) {
PreparedStatement st = null;
PreparedStatement pt = null;
boolean result;
try {
st = connection.prepareStatement(" SELECT userName FROM login WHERE userName = ? ;" );
pt = connection.prepareStatement("INSERT INTO login (firstName, lastName, email, userName, password1) VALUES (?,?,?,?,?);");
} catch (Exception e) {
try {
connection.close();
}
catch(SQLException s) {}
}
try {
st.clearParameters();
st.setString(1,firstName);
st.setString(2,lastName);
st.setString(3,email);
st.setString(4,userName);
st.setString(5,password1);
ResultSet rs = st.executeQuery();
FormBean form = new FormBean();
while (rs.next()) {
form.setUserName(rs.getString(4));
}
}
catch (Exception e) {
try {
connection.close();
}
catch(SQLException s) {}
}
try {
pt.clearParameters();
pt.setString(1,firstName);
pt.setString(2,lastName);
pt.setString(3,email);
pt.setString(4,userName);
pt.setString(5,password1);
pt.executeUpdate();
result = true;
}
catch (Exception e) {
result=false;
}
return null;
}
}
|
| Код |
package foo;
import java.util.*;
public class FormBean {
private String firstName;
private String lastName;
private String email;
private String email2;
private String userName;
private String password1;
private String password2;
private Hashtable errors;
public boolean validate() {
boolean allOk=true;
if (firstName.equals("")) {
errors.put("firstName","VVedite imja! ");
firstName="";
allOk=false;
}
if (lastName.equals("")) {
errors.put("lastName","VVedite familiju! ");
lastName="";
allOk=false;
}
if (email.equals("") || (email.indexOf('@') == -1)) {
errors.put("email","vvedite e-mail!");
email="";
allOk=false;
}
if (email2.equals("") || (email2.indexOf('@') == -1)) {
errors.put("email2","vvedite e-mail!");
email2="";
allOk=false;
}
if (!email.equals("") && (email2.equals("") ||
!email.equals(email2))) {
errors.put("email","vvedennye e-maily ne sovpadajut");
email2="";
allOk=false;
}
if (userName.equals("")) {
errors.put("userName","vvedite imja pol'zovatelja!");
userName="";
allOk=false;
}
if (password1.equals("") ) {
errors.put("password1","vvedite parol'!");
password1="";
allOk=false;
}
if (!password1.equals("") && (password2.equals("") ||
!password1.equals(password2))) {
errors.put("password2","vvedennye paroli ne sovpadajut!");
password2="";
allOk=false;
}
return allOk;
}
public String getErrorMsg(String s) {
String errorMsg =(String)errors.get(s.trim());
return (errorMsg == null) ? "":errorMsg;
}
public FormBean() {
firstName="";
lastName="";
email="";
email2="";
userName="";
password1="";
password2="";
errors = new Hashtable();
}
public String getFirstName() {
return firstName;
}
public String getLastName() {
return lastName;
}
public String getEmail() {
return email;
}
public String getEmail2() {
return email2;
}
public String getUserName() {
return userName;
}
public String getPassword1() {
return password1;
}
public String getPassword2() {
return password2;
}
public void setFirstName(String fname) {
firstName =fname;
}
public void setLastName(String lname) {
lastName =lname;
}
public void setEmail(String eml) {
email=eml;
}
public void setEmail2(String eml2) {
email2=eml2;
}
public void setUserName(String u) {
userName=u;
}
public void setPassword1(String p1) {
password1=p1;
}
public void setPassword2(String p2) {
password2=p2;
}
public void setErrors(String key, String msg) {
errors.put(key,msg);
}
}
|
| Код |
process.success=success.jsp
process.retry=retry.jsp
|
process.jsp
| Код |
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="foo.authBean"%>
<%@ page import="java.util.*" %>
<jsp:useBean id="Authentication" class="foo.authBean" scope="session">
<jsp:setProperty name="Authentication" property="*"/>
</jsp:useBean>
<%!
ResourceBundle bundle =null;
public void jspInit() {
bundle = ResourceBundle.getBundle("forms");
}
%>
<jsp:useBean id="formHandler" class="foo.FormBean" scope="request">
<jsp:setProperty name="formHandler" property="*"/>
</jsp:useBean>
<%
if (formHandler.validate()) {
%>
<jsp:forward page="<%=bundle.getString(\"process.success\")%>"/>
<%
} else {
%>
<jsp:forward page="<%=bundle.getString(\"process.retry\")%>"/>
<%
}
%>
|
register.htm
| Код |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta charset=windows-1257" />
<body>
<form action="/APPL/process.jsp" method=post>
<center>
<table cellpadding=4 cellspacing=2 border=0>
<th colspan=2>
Registracija novyeh pol'zovatelej<br>
<font size=1><sup>*</sup> Objazatel'nye polja</font>
</th>
<tr>
<td valign=top>
<b>Imja<sup>*</sup></b>
<br>
<input type="text" name="firstName" value="" size=15 maxlength=20></td>
<td valign=top>
<b>Familija<sup>*</sup></b>
<br>
<input type="text" name="lastName" value="" size=15 maxlength=20></td>
</tr>
<tr>
<td valign=top>
<b>E-mail<sup>*</sup></b>
<br>
<input type="text" name="email" value="" size=25 maxlength=125>
<br></td>
<td valign=top>
<b>E-mail ewe raz<sup>*</sup></b>
<br/>
<input type="text" name="email2" value="" size=25 maxlength=125>
<br></td>
</tr>
<tr>
<td valign=top colspan=2>
<b>Imja polzovatelja<sup>*</sup></b>
<br>
<input type="text" name="userName" size=10 value="" maxlength=10>
</td>
</tr>
<tr>
<td valign=top>
<b>Parol'<sup>*</sup></b>
<br>
<input type="password" name="password1" size=10 value="" maxlength=10></td>
<td valign=top>
<b>Parol' ewe raz<sup>*</sup></b>
<br>
<input type="password" name="password2" size=10 value="" maxlength=10></td>
<br>
</tr>
<tr>
<td align=center colspan=2>
<input type="submit" value="Sohranit' "> <input type="reset" value="Otmenit' ">
</td>
</tr>
</table>
</center>
</form>
</body>
</html>
|
success.jsp
| Код |
<%@ page contentType="text/html; charset=windows-1257" %>
<jsp:useBean id="formHandler" class="foo.FormBean" scope="request"/>
<html>
<meta charset=windows-1257" />
<body>
<center>
<table cellpadding=4 cellspacing=2 border=0>
<th colspan=2>
<font size=5>Registracija proshla uspeshno!</font>
</th>
<font size=4>
<tr>
<td valign=top>
<b>Imja</b>
<br>
<jsp:getProperty name="formHandler" property="firstName"/>
</td>
<td valign=top>
<b>Familija</b>
<br>
<jsp:getProperty name="formHandler" property="lastName"/>
</td>
</tr>
<tr>
<td valign=top>
<b>E-mail</b>
<br>
<jsp:getProperty name="formHandler" property="email"/>
<br></td>
<td> </td>
</tr>
<tr>
<td valign=top colspan=2>
<b>Imja pol'zovatelja</b>
<br>
<jsp:getProperty name="formHandler" property="userName"/>
</td>
</tr>
</font>
</table>
</center>
</body>
</html>
|
|
)