mybatis架构分析图

Mybatis框架的架构图

  

JDBC实现代码

Connection connection=null;
PreparedStatement preparedStatement=null;
ResultSet resultSet=null;
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/hotel?characterEncoding=utf-8", "root", "123456");
preparedStatement = connection.prepareStatement("select * from tb_dinner_table");
resultSet = preparedStatement.executeQuery();
while (resultSet.next()){
  int id = resultSet.getInt("id");
  String table_name = resultSet.getString("table_Name");
  int table_status = resultSet.getInt("table_status");
  Timestamp begin_use_date = resultSet.getTimestamp("begin_use_date");
  Timestamp create_date = resultSet.getTimestamp("create_date");
  Timestamp update_date = resultSet.getTimestamp("update_date");
  int disabled = resultSet.getInt("disabled");
                  
System.out.println(id+":"+table_name+":"+table_status+":"+begin_use_date+":"+create_date+":"+update_date+":"+disabled);
        }

MyBatis执行流程图