JDBC链接数据库+添加数据/删除数据

JDBC链接数据库“添加数据“具体代码

 //JDBC链接数据库“添加数据”
 import java.sql.Driver;
 import java.sql.DriverManager;
 import java.sql.SQLException;
 import java.sql.Connection;
 import java.sql.Statement;


public class JDBCTest01{
	public static void main(String[] args){
		Statement stmt = null;
		Connection conn = null;
		try{
			//1.注册驱动
			//DriverManager.registerDriver(new com.mysql.jdbc.Driver);
			Driver driver = new com.mysql.jdbc.Driver(); //多态，父类型引用指向子类型对象
			DriverManager.registerDriver(driver); 
			//2.获取连接
			String url = "jdbc:mysql://localhost:3306/project";
			String user = "root";
			String password = "333";
		    conn = DriverManager.getConnection(url,user,password);
			System.out.println("数据库连接对象 = " + conn);

			//3.获取数据库操作对象
			 stmt = conn.createStatement();

			//4.执行sql
			String sql = "insert into product(number,id,name,ic,role,sector,situation) values(14,0000,'xiaoming',1111,'普通员工','生产部','异常')";
			
			//专门执行DML语句的（inset delete update）
			//返回值是影响数据库中的记录条数
			int count = stmt.executeUpdate(sql);
			System.out.println(count == 1 ? "保存成功" : "保存失败");

			//5.处理查询结果集
			
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			//6.释放资源
			//为了保证资源一定释放，在finally 语句块中关闭资源
			//并且要遵循从小到大一次关闭
			//分别对其try ...catch
			try{
				if(stmt != null){
					stmt.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}
			try{
				if(conn != null){
					conn.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}

		}
	}
}

JDBC链接数据库“删除数据”具体代码

 //JDBC链接数据库“删除数据”
 import java.sql.Driver;
 import java.sql.DriverManager;
 import java.sql.SQLException;
 import java.sql.Connection;
 import java.sql.Statement;


public class JDBCTest02{
	public static void main(String[] args){
		Statement stmt = null;
		Connection conn = null;
		try{
			//1.注册驱动
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			//2.获取连接
//			String url = "jdbc:mysql://localhost:3306/project";
//			String user = "root";
//			String password = "333";
//		    conn = DriverManager.getConnection(url,user,password);
//			System.out.println("数据库连接对象 = " + conn);
			 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/project","root","333");

			//3.获取数据库操作对象
			 stmt = conn.createStatement();

			//4.执行sql
			String sql = "delete from product where number = 14";
			
			//专门执行DML语句的（inset delete update）
			//返回值是影响数据库中的记录条数
			int count = stmt.executeUpdate(sql);
			System.out.println(count == 1 ? "删除成功" : "删除失败");

			//5.处理查询结果集
			
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			//6.释放资源
			//为了保证资源一定释放，在finally 语句块中关闭资源
			//并且要遵循从小到大一次关闭
			//分别对其try ...catch
			try{
				if(stmt != null){
					stmt.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}
			try{
				if(conn != null){
					conn.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}

		}
	}
}