public class connectionMysql {
Connection con=null;
ResultSet res=null;
public Connection openMysql(){
try{
Class.forName("com.mysql.cj.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/studenttest?characterEncoding=UTF-8";
String userName="root";
String passWord="qw1234";
con = DriverManager.getConnection(url,userName,passWord);
}catch (Exception e){
e.printStackTrace();
}
return con;
}}
public state checkLogin(int id, String pass,int root) {
connectionMysql cons=new connectionMysql();
cons.openMysql();
ResultSet res=cons.select("SELECT a_pass FROM b_admin WHERE a_id='"+id+"'");
String userPass="123";
int re=0;
try{
while(res.next()){
userPass=res.getString("a_pass");
}
}catch (Exception e){
e.printStackTrace();
}}
ResultSet res=cons.select("SELECT a_pass FROM b_admin WHERE a_id='"+id+"'");从前端运行没有结果,但后端测试正常。
导致结果:前端无法从后端数据库中取得数据,控制台也没报错。