JDBC的增删改查

JDBC关于数据库的添加操作

public class BrandTest {
   
        @Test
        public void testAdd() throws Exception{
   
//          1。  接受页面提交的参数
            String brandName = "香飘飘";
            String companyName = "香飘飘";
            int ordered = 1;
            String description ="地球一圈";
            int status =1;

//            1，获取conneiton
//     3.加载配置文件
            Properties prop =new Properties();
            prop.load(new FileInputStream("C:\\Users\\lengxin\\IdeaProjects\\jdbc-demo\\lib\\druid.properties"));
//     4.获取连接池数据对象
            DataSource dataSource= DruidDataSourceFactory.createDataSource(prop);
//            5.获取数据库链接
            Connection conn=dataSource.getConnection();
//            2.定义sql语句
//            String sql ="select * from tb_brand";
            String sql ="insert into tb_brand(brand_name, company_name, ordered, description, status) values(?,?,?,?,?);";
//            3.获取pstmt对象
            PreparedStatement pstmt = conn.prepareStatement(sql);
//            4。设置参数
            pstmt.setString(1,brandName);
            pstmt.setString(2,companyName);
            pstmt.setInt(3,ordered);
            pstmt.setString(4,description);
            pstmt.setInt(5,status);

//            5.执行sql
            int count