JDBC(二)
代码实现
public class JDBCDemo02{
public class static void main (String[] args){
Connection conn = null;
Statement stmt = null;
try{//1.注册驱动
Class.forName("com.mysql.jdbc.Driver");
//2.定义SQL
String sql="inster into account values(null,'王五',2300)";
//3.获取数据库连接
conn = DriverManager.getConnection(url:'jabc:mysql:///db3',user:'root',password:'root');
//4.执行SQL对象,Statment
stmt = conn.createStatement();
//5.执行SQL,count 表示执行成功的数量
int count = stmt.executeUpdate(sql);
//6.查看获取结果
system.out.println(count)
if (cont > 0){
System.out.println("添加成功!");
}else {
System.out.println("添加失败!");
}
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}finally{
//stmt.close()
//7.释放资源
//避免空指针
if(stmt != null){
try{
stmt.close();
}catch(SQLException e){
e.printStackTrace();
}
}
if(conn != null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}