Web应用系统开发技术 西南石油大学 实验1 作业答案 完整工程文件 (仅供学习)

//import com.sun.xml.internal.ws.encoding.xml.XMLMessage; import com.alibaba.druid.pool.DruidDataSourceFactory; import javax.sql.DataSource; import java.io.FileInputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import java.util.Properties; // Press Shift twice to open the Search Everywhere dialog and type `show whitespaces`, // then press Enter. You can now see whitespace characters in your code. public class Main { public static void main(String[] args) throws Exception { String url = "jdbc:mysql://127.0.0.1:3306/test_schema?useSSL=false&serverTimezone=UTC"; String username = "root"; String password = "8868384asdf"; Connection conn = DriverManager.getConnection(url, username, password); //testUpdate(); //testSelectAll(); testDeleteById(); } static public void testDeleteById() throws Exception { int id = 4; Properties prop = new Properties(); prop.load(new FileInputStream("..\\untitled\\src\\druid.properties")); DataSource dataSource = DruidDataSourceFactory.createDataSource(prop); Connection conn = dataSource.getConnection(); String sql = " delete from tb_brand where id = ? "; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); int count = pstmt.executeUpdate(); // 影响的行数 System.out.println(count > 0); pstmt.close(); conn.close(); } static public void testUpdate() throws Exception { String brandName = "香飘飘"; String companyName = "香飘飘"; int ordered = 1000; String description = "绕地球三圈"; int status = 1; int id = 4; Properties prop = new Properties(); prop.load(new FileInputStream("..\\untitled\\src\\druid.properties")); DataSource dataSource = DruidDataSourceFactory.createDataSource(prop); Connection conn = dataSource.getConnection(); String sql = " update tb_brand\n" + " set brand_name = ?,\n" + " company_name= ?,\n" + " ordered = ?,\n" + " description = ?,\n" + " status = ?\n" + " where id = ?"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, brandName); pstmt.setString(2, companyName); pstmt.setInt(3, ordered); pstmt.setString(4, description); pstmt.setInt(5, status); pstmt.setInt(6, id); int count = pstmt.executeUpdate(); // 影响的行数 System.out.println(count > 0); pstmt.close(); conn.close(); } static public void testAdd() throws Exception { String brandName = "香飘飘"; String companyName = "香飘飘"; int ordered = 1; String description = "绕地球一圈"; int status = 1; Properties prop = new Properties(); prop.load(new FileInputStream("..\\untitled\\src\\druid.properties")); DataSource dataSource = DruidDataSourceFactory.createDataSource(prop); Connection conn = dataSource.getConnection(); String sql = "insert into tb_brand(brand_name,\n" + "company_name, ordered, description, status)\n" + "values(?,?,?,?,?); "; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, brandName); pstmt.setString(2, companyName); pstmt.setInt(3, ordered); pstmt.setString(4, description); pstmt.setInt(5, status); int count = pstmt.executeUpdate(); System.out.println(count > 0); pstmt.close(); conn.close(); } static public void testSelectAll() throws Exception { Properties prop = new Properties(); prop.load(new FileInputStream("..\\untitled\\src\\druid.properties")); DataSource dataSource = DruidDataSourceFactory.createDataSource(prop); Connection conn = dataSource.getConnection(); String sql = "select * from tb_brand;"; PreparedStatement pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); Brand brand = null; List<Brand> brands = new ArrayList<>(); while (rs.next()) { int id = rs.getInt("id"); String brandName = rs.getString("brand_name"); String companyName = rs.getString("company_name"); int ordered = rs.getInt("ordered"); String description = rs.getString("description"); int status = rs.getInt("status"); brand = new Brand(); brand.setId(id); brand.setBrandName(brandName); brand.setCompanyName(companyName); brand.setOrdered(ordered); brand.setDescription(description); brand.setStatus(status); brands.add(brand); } System.out.println(brands); rs.close(); pstmt.close(); conn.close(); } }