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();
	}
}

}