空指针异常如何解决

code_search 2017-06-28 02:32:42

package jdbcDemo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.log4j.Logger;

public class Test2 {
private static Logger logger=Logger.getLogger(Test2.class.getName());
public static void main(String[] args) {
Connection connection=null;
Statement stms=null;
String name="欧欧";
int health=100;
int love=60;
String strain="酷酷的雪纳瑞";
//1.加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//2.建立连接
try {
DriverManager.getConnection("jdbc:mysql://localhost:3306/epet","epetadmin","0000");
stms=connection.createStatement();
StringBuffer sql=new StringBuffer("insert into dog(name,health,love,strain ) values ('");
sql.append(name+"',");
sql.append(health+",");
sql.append(love+",'");
sql.append(strain+"');");
stms.execute(sql.toString());
logger.info("信息录入成功");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
logger.error(e);
}finally{
try {
if (stms!=null) {
stms.close();
}
if (connection!=null) {
connection.close();
}

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
logger.equals(e);
}
}
}
}

...全文