关于数据库连接的小问题_setresult(string result) { this.result=result;-CSDN博客

本文链接：https://blog.csdn.net/qq_32286125/article/details/53002410

错误代码：

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;
}

蓝色部分为修改部分

}