外卖订单管理系统(Javaweb+Mysql)

package test; import com.alibaba.druid.util.StringUtils; import com.atcs.dao.ManagerDao; import com.atcs.dao.OrderDao; import com.atcs.dao.impl.ManagerDaoImpl; import com.atcs.dao.impl.OrderDaoImpl; import com.atcs.entity.Manager; import com.atcs.entity.Order; import com.atcs.utils.JdbcUtils; import org.junit.Test; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.List; public class JdbcUtilsTest { ManagerDao managerDao = new ManagerDaoImpl(); OrderDao orderDao = new OrderDaoImpl(); @Test public void getConnection() { try { System.out.println(JdbcUtils.getConnection()); } catch (SQLException e) { e.printStackTrace(); } } @Test public void test01() { managerDao.insert(new Manager("admin", "123123")); } @Test public void test02() { orderDao.insert(new Order("张三", 1, "河南科技学院", "在途中", 19.99, "18338992657")); } @Test public void test03(){ List<Order> list = orderDao.list(); for (Order order : list) { System.out.println(order); } } /* */ // @Test // public void test01() throws SQLException { // Connection connection = JdbcUtils.getConnection(); // String sql1 = " insert into `students` set `name`='Alice' , `age`=18,`class1`='A1' "; // Statement statement = connection.prepareStatement(sql1); // int i1 = statement.executeUpdate(sql1); // System.out.println(i1); // // String sql2 = "delete from `students` where age < 15 "; // int i = statement.executeUpdate(sql2); // System.out.println(i); // // String sql3 = " update `students` set `age`=20 where `name`='Bob'"; // int i2 = statement.executeUpdate(sql3); // System.out.println(i2); // // String sql4 = "select * from `students` where `age`>=18"; // ResultSet resultSet1 = statement.executeQuery(sql4); // while (resultSet1.next()) { // System.out.print("ID=" + resultSet1.getInt("ID")); // System.out.print("NAME=" + resultSet1.getString("NAME")); // System.out.print("AGE=" + resultSet1.getString("AGE")); // System.out.println("CLASS1=" + resultSet1.getString("CLASS1")); // } // // String sql5 = "select * from `students` where `class1`='B2'"; // ResultSet resultSet2 = statement.executeQuery(sql5); // while (resultSet2.next()) { // System.out.print("ID=" + resultSet2.getInt("ID")); // System.out.print("NAME=" + resultSet2.getString("NAME")); // System.out.print("AGE=" + resultSet2.getString("AGE")); // System.out.println("CLASS1=" + resultSet2.getString("CLASS1")); // } // // String sql6 = " delete from `students` where `name` = 'Alice'"; // int i3 = statement.executeUpdate(sql6); // System.out.println(i3); // // String sql7 = "update `students` set `class1` = 'c3' where `name`='Bob'; "; // int i5 = statement.executeUpdate(sql7); // System.out.println(i5); // // String sql8 = "select * from `students` where `name` like 'j*'"; // ResultSet resultSet4 = statement.executeQuery(sql8); // while (resultSet4.next()) { // System.out.print("ID=" + resultSet4.getInt("ID")); // System.out.print("NAME=" + resultSet4.getString("NAME")); // System.out.print("AGE=" + resultSet4.getString("AGE")); // System.out.println("CLASS1=" + resultSet4.getString("CLASS1")); // } // // String sql9 = " insert into `students` set `name`='Emily',age=21,class1='D4'"; // int i4 = statement.executeUpdate(sql9); // System.out.println(i4); // String sql10 = "select * from `students` where class1 = 'A1' and age > 16"; // ResultSet resultSet5 = statement.executeQuery(sql10); // while (resultSet5.next()) { // System.out.print("ID=" + resultSet5.getInt("ID")); // System.out.print("NAME=" + resultSet5.getString("NAME")); // System.out.print("AGE=" + resultSet5.getString("AGE")); // System.out.println("CLASS1=" + resultSet5.getString("CLASS1")); // } // } }