import java.sql.Connection;
import java.sql.Statement;
/**
* Statement对象的使用
*/
public class StatementTest {
/**
* 添加用户
*/
public void insetUsers(String username,int userage){
Connection connection = null;
Statement statement = null;
try{
//获取Connection对象。
connection = JdbcUtils.getConnection();
//获取Statement对象
statement = connection.createStatement();
//定义需要执行的SQL语句
String sql = "inset into users values(default,'"+username+"',"+userage+")";
//执行SQL,返回boolean值,如果sql有结果集返回,那么返回值为true,如果没有结果集返回,则返回false。
boolean execute=statement.execute(sql);
System.out.println(execute);
}
catch(Exception e){
e.printStackTrace();
}
finally {
JdbcUtils.closeResource(statement,connection);
}
}
}
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
StatementTest st = new StatementTest() ;
st.insetUsers("Oldlu",28);
}
}
运行结果:
java.sql.SQLException: The url cannot be null
at java.sql.DriverManager.getConnection(DriverManager.java:649)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.Han.JdbcUtils.getConnection(JdbcUtils.java:43)
at com.Han.StatementTest.insetUsers(StatementTest.java:18)
at com.Han.Test.main(Test.java:8)
java.lang.NullPointerException
at com.Han.StatementTest.insetUsers(StatementTest.java:20)
at com.Han.Test.main(Test.java:8)
Exception in thread "main" java.lang.NullPointerException
at com.Han.JdbcUtils.closeStatement(JdbcUtils.java:76)
at com.Han.JdbcUtils.closeResource(JdbcUtils.java:92)
at com.Han.StatementTest.insetUsers(StatementTest.java:31)
at com.Han.Test.main(Test.java:8)
Process finished with exit code 1