/* * 添加 * 1.insert into tb_ brand(brand_ name, company_ name, ordered, description, status) values(?,?,?,?,?); * 2.参数:需要id之外所有参数信息 * 3.结果:boolean * */ @Test public void testBrand1() throws Exception { //模拟用户输入内容 String brandName="香飘飘"; String companyName="香飘飘有限公司"; int ordered=1; String description="绕地球一圈"; int status=1; //1.导入jar包 //2.定义配置文件 //3.加载配置文件 Properties prop = new Properties(); //获取数据库的位置信息,加载数据库 prop.load(new FileInputStream("F:\\Develop\\code\\Demo2\\src\\druid.txt")); //4.获取连接池对象 DataSource dataSource = DruidDataSourceFactory.createDataSource(prop); //5.获取数据库连接Connection Connection connection = dataSource.getConnection(); //6.定义SQL String sql="insert into tb_brand(brand_name, company_name, ordered, description, status) values(?,?,?,?,?)"; //7.获取pstmt对象 PreparedStatement pstmt = connection.prepareStatement(sql); //8.设置参数 pstmt.setString(1,brandName); pstmt.setString(2,companyName); pstmt.setInt(3,ordered); pstmt.setString(4,description); pstmt.setInt(5,status); //9.执行sql int update = pstmt.executeUpdate();//返回受影响行数 //10.判断返回值 if (update>0){ System.out.println("执行成功"); }else { System.out.println("执行失败"); } //11.释放资源 connection.close(); pstmt.close(); }
标签:status,JDBC,ordered,String,brand,练习,name,添加,pstmt From: https://www.cnblogs.com/Karl-hut/p/17483385.html