mysql空指针_Java Mysql 查询语句 空指针异常！帮忙看看！谢谢。

importcom.mysql.fabric.xmlrpc.base.Data;importjava.time.*;importjava.sql.*;importjava.text.SimpleDateFormat;importjava.util.Calendar;publicclassUser_Logon{//staticfinalSt...

import com.mysql.fabric.xmlrpc.base.Data;

import java.time.*;

import java.sql.*;

import java.text.SimpleDateFormat;

import java.util.Calendar;

public class User_Logon {

//static final String JDBC_DRIVER="com.mysql.jdbc.Driver";

public User_Logon(String name,String pass) throws ClassNotFoundException, SQLException {

Connection conn=null;

Statement stmt=null;

Calendar now=Calendar.getInstance();

System.out.println("111111111");

Class.forName("com.mysql.jdbc.Driver");

System.out.println("22222222");

Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/user_data?characterEncoding=utf8&useSSL=true","root","123456");//

System.out.println("3333333333");

//String sql="select Name from logon";

ResultSet rs=stmt.executeQuery("select Name from logon");

String sql_name=rs.getString("Name");

if (name.equals(sql_name)){

System.out.println("1234567");

String mess="yes";

new Return_android(mess);

}else{

Data d=new Data();

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");

String date=sdf.format(d);

PreparedStatement psql=conn.prepareStatement("insert into logon(Name,Pass,Time,State)"+"values(?,?,?,?) ");

psql.setString(1,name);

psql.setString(2,pass);

psql.setString(3,date);

psql.setString(4,"yse");

psql.executeUpdate();

psql.close();

}

}

}

下面是报错，就四行报错。数据库表是空的

Exception in thread "Thread-0" java.lang.NullPointerException

at Socket_Test.User_Logon.(User_Logon.java:23)

at Socket_Test.Parsing_string.(Parsing_string.java:13)

at Socket_Test.Socket_Server.run(Socket_Server.java:29)

展开