错误代码:
package mybean.flow;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import pub.conn.*;
public class Register {
String email;
String passw1;
String passw2;
String result = "aaa";
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPassw1() {
return passw1;
}
public void setPassw1(String passw1) {
this.passw1 = passw1;
}
public String getPassw2() {
return passw2;
}
public void setPassw2(String passw2) {
this.passw2 = passw2;
}
public void setResult(String result){
this.result = result;
}
public String getResult() {
if(email==null||passw1==null||passw2==null){
result = "请输入对应信息!";
}
else if(!(passw1.equals(passw2))){
result = "两次密码输入不一致!";
}else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){
System.out.println(e);
}
try{
Connection con;
Statement sql;
ResultSet rs;
con = DriverManager.getConnection("jdbc:odbc:flower","flower","654321");
sql = con.createStatement();
rs = sql.executeQuery("select * from member where email='"+email+"'");
if(rs.next()){
result = "已存在此用户名!";
}else{
String str="insert into member(email,password,jifen,ye) values('"+email+"','"+passw1+"',0,0.0)";
sql.executeUpdate(str);
result = "注册成功!";
}
}catch(Exception e){}
}
return result;
}
修改后:
package mybean.flow;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import pub.conn.*;
public class Register {
String email;
String passw1;
String passw2;
String result = "aaa";
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPassw1() {
return passw1;
}
public void setPassw1(String passw1) {
this.passw1 = passw1;
}
public String getPassw2() {
return passw2;
}
public void setPassw2(String passw2) {
this.passw2 = passw2;
}
public void setResult(String result){
this.result = result;
}
public String getResult() {
Connection con;
Statement sql;
ResultSet rs;
if(email==null||passw1==null||passw2==null){
result = "请输入对应信息!";
}
else if(!(passw1.equals(passw2))){
result = "两次密码输入不一致!";
}else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){
System.out.println(e);
}
try{
con = DriverManager.getConnection("jdbc:odbc:flower","flower","654321");
sql = con.createStatement();
rs = sql.executeQuery("select * from member where email='"+email+"'");
if(rs.next()){
result = "已存在此用户名!";
}else{
String str="insert into member(email,password,jifen,ye) values('"+email+"','"+passw1+"',0,0.0)";
sql.executeUpdate(str);
result = "注册成功!";
}
}catch(Exception e){}
}
return result;
}
蓝色部分为修改部分
}