最近太忙，一直没顾上更新，这两天难得清静，于是在原来的基础上增加了多表查询的功能，修复了以前的一些bug，让我们进入正题吧。
多表查询界面
首先是多表查询的ui界面，同样采用swing设计，先上图看一下：
界面比较简陋，相比于其他的生成工具，这个ui界面倾向于自己去配置多表查询的sql，更加的灵活，第一部分配制关联表语句，第二部分配置查询语句，也就是select的字段，第三部分配置条件信息，也就是where后面的内容，相信大家一看就会明白。源码挺长的，没有做什么优化，如下：
package codeMaker;
import java.awt.Color;
import java.awt.Component;
import java.awt.EventQueue;
import java.awt.GridLayout;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import javax.swing.DefaultComboBoxModel;
import javax.swing.GroupLayout;
import javax.swing.GroupLayout.Alignment;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextField;
import javax.swing.LayoutStyle.ComponentPlacement;
import constant.ChildWindowConstant;
import constant.CodeConstant;
import constant.CompareComboBox;
import constant.FiledComment;
import constant.Filed_cn;
import constant.Filed_eng;
import constant.OrderComboBox;
import constant.RelationJcombox;
import constant.ServiceTypeComboBox;
import constant.Table1;
import constant.Table1Fileds;
import constant.Table2;
import constant.Table2Fileds;
import entity.Parameters;
import entity.TableConditionModel;
import entity.TableFiledModel;
import entity.TableRelationModel;
import entity.TablesQueryModel;
public class TablesQuery {
private static String currentDataBaseName;
private static String currentDataBaseUrl;
private JFrame frame;
private JTextField currentModelName;
private JTextField currentModelName_cn;
public JFrame getFrame() {
return frame;
}
public void setFrame(JFrame frame) {
this.frame = frame;
}
/**
* Launch the application.
*/
public static void main(final Parameters parameters) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
if (currentDataBaseName == null || currentDataBaseUrl == null) {
// 记录当前数据库的名称和url
currentDataBaseName = parameters.getDataBaseNameVal();
currentDataBaseUrl = parameters.getDataBaseUrl();
} else {
// 如果数据库不一致，清空map
if (!currentDataBaseName.equals(parameters.getDataBaseNameVal())
|| !currentDataBaseUrl.equals(parameters.getDataBaseUrl())) {
ChildWindowConstant.tablesQueryMap.clear();
ChildWindowConstant.tablesQueryEndAndCnMap.clear();
}
}
TablesQuery window = new TablesQuery();
ChildWindowConstant.tablesQuery = window;
window.frame.setVisible(true);
JOptionPane.showMessageDialog(window.frame,
"表1字段、表2字段：多个字段使用 & 隔开，字段个数保持一致" + CodeConstant.NEW_LINE + "类型描述：" + CodeConstant.NEW_LINE
+ " 布尔示例：是#否 其中是和否填写数据库中用来表示是和否的值" + CodeConstant.NEW_LINE
+ " 状态码示例：状态名称&状态值#状态名称&状态值（填写状态名称和状态值便于前台生成样式）" + CodeConstant.NEW_LINE
+ " 其他类型将根据类型生成对应的样式，无需描述" + CodeConstant.NEW_LINE + "注意：关联表信息配置完点击确定才会生效！！！",
"提示", JOptionPane.INFORMATION_MESSAGE);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* test
*
* @param parameters
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
TablesQuery window = new TablesQuery();
ChildWindowConstant.tablesQuery = window;
window.frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the application.
*/
public TablesQuery() {
initialize();
}
/**
* Initialize the contents of the frame.
*/
private void initialize() {
frame = new JFrame();
frame.setResizable(false);
frame.setIconImage(Toolkit.getDefaultToolkit().getImage(TablesQuery.class
.getResource("/org/pushingpixels/substance/internal/contrib/randelshofer/quaqua/images/palette.png")));
frame.setTitle("多表查询配置");
frame.setBounds(100, 100, 1281, 759);
frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
JScrollPane addTableScrollPane = new JScrollPane();
JScrollPane queryScrollPane = new JScrollPane();
JButton addTable = new JButton("添加关联表信息");
JButton addQuery = new JButton("添加查询字段");
JLabel label = new JLabel("当前模块英文名称");
currentModelName = new JTextField();
currentModelName.setColumns(10);
JButton confirm = new JButton("确定");
JLabel label_1 = new JLabel("查看已配置模块");
JButton addCondition = new JButton("添加条件字段");
addQuery.setEnabled(false);
addCondition.setEnabled(false);
JScrollPane conditionScrollPane = new JScrollPane();
JLabel label_2 = new JLabel("*");
label_2.setForeground(Color.RED);
JButton restart = new JButton("清空重配");
JComboBox<String> tableConfigExit = new JComboBox<String>();
String[] modelArr = ChildWindowConstant.tablesQueryMap.keySet().toArray(new String[] {});
tableConfigExit.setModel(new DefaultComboBoxModel<>(new String[] { "--请选择--" }));
for (String model : modelArr) {
tableConfigExit.addItem(model);
}
JButton confirmRelTable = new JButton("确定");
JLabel label_3 = new JLabel("——————》");
JLabel cnLable = new JLabel("中文名称");
currentModelName_cn = new JTextField();
currentModelName_cn.setColumns(10);
JLabel label_4 = new JLabel("*");
label_4.setForeground(Color.RED);
JButton button = new JButton("配置说明");
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
JOptionPane.showMessageDialog(frame,
"表1字段、表2字段：多个字段使用 & 隔开，字段个数保持一致" + CodeConstant.NEW_LINE + "类型描述：" + CodeConstant.NEW_LINE
+ " 布尔示例：是#否 其中是和否填写数据库中用来表示是和否的值" + CodeConstant.NEW_LINE
+ " 状态码示例：状态名称&状态值#状态名称&状态值（填写状态名称和状态值便于前台生成样式）" + CodeConstant.NEW_LINE
+ " 其他类型将根据类型生成对应的样式，无需描述" + CodeConstant.NEW_LINE + "注意：关联表信息配置完点击确定才会生效！！！",
"提示", JOptionPane.INFORMATION_MESSAGE);
}
});
GroupLayout groupLayout = new GroupLayout(frame.getContentPane());
groupLayout.setHorizontalGroup(groupLayout.createParallelGroup(Alignment.LEADING).addGroup(groupLayout
.createSequentialGroup().addGap(25).addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(
groupLayout.createSequentialGroup()
.addComponent(conditionScrollPane, GroupLayout.DEFAULT_SIZE, 1240,
Short.MAX_VALUE)
.addContainerGap())
.addGroup(groupLayout.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING).addComponent(addCondition)
.addComponent(addQuery).addComponent(addTable)
.addGroup(groupLayout.createSequentialGroup().addComponent(label)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(currentModelName, GroupLayout.PREFERRED_SIZE, 91,
GroupLayout.PREFERRED_SIZE)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(label_2, GroupLayout.PREFERRED_SIZE, 6,
GroupLayout.PREFERRED_SIZE)
.addGap(18).addComponent(cnLable)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(currentModelName_cn, GroupLayout.PREFERRED_SIZE, 98,
GroupLayout.PREFERRED_SIZE)
.addPreferredGap(ComponentPlacement.RELATED).addComponent(label_4)
.addGap(26).addComponent(label_1)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(
tableConfigExit, GroupLayout.PREFERRED_SIZE, 102,
GroupLayout.PREFERRED_SIZE))
.addGroup(groupLayout.createSequentialGroup().addGroup(groupLayout
.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup().addComponent(button)
.addGap(18).addComponent(restart).addGap(18)
.addComponent(confirm))
.addGroup(groupLayout.createSequentialGroup()
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(addTableScrollPane, GroupLayout.DEFAULT_SIZE,
1026, Short.MAX_VALUE))
.addComponent(queryScrollPane, GroupLayout.DEFAULT_SIZE, 1026,
Short.MAX_VALUE))
.addPreferredGap(ComponentPlacement.UNRELATED).addComponent(label_3)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(confirmRelTable)))
.addContainerGap(30, GroupLayout.PREFERRED_SIZE)))));
groupLayout.setVerticalGroup(groupLayout.createParallelGroup(Alignment.LEADING).addGroup(groupLayout
.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup().addContainerGap(210, Short.MAX_VALUE)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(label_3)
.addComponent(confirmRelTable))
.addGap(266))
.addGroup(groupLayout.createSequentialGroup().addGap(30)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(label)
.addComponent(currentModelName, GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_2).addComponent(cnLable)
.addComponent(currentModelName_cn, GroupLayout.PREFERRED_SIZE,
GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_4).addComponent(label_1).addComponent(tableConfigExit,
GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
GroupLayout.PREFERRED_SIZE))
.addGap(18).addComponent(addTable).addPreferredGap(ComponentPlacement.RELATED)
.addComponent(addTableScrollPane, GroupLayout.PREFERRED_SIZE, 138,
GroupLayout.PREFERRED_SIZE)
.addGap(22).addComponent(addQuery).addPreferredGap(ComponentPlacement.RELATED)
.addComponent(queryScrollPane, GroupLayout.DEFAULT_SIZE, 212, Short.MAX_VALUE)))
.addGap(18).addComponent(addCondition).addPreferredGap(ComponentPlacement.RELATED)
.addComponent(conditionScrollPane, GroupLayout.DEFAULT_SIZE, 126, Short.MAX_VALUE)
.addPreferredGap(ComponentPlacement.RELATED)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE).addComponent(confirm)
.addComponent(restart).addComponent(button))
.addGap(30)));
JPanel conditionPanel = new JPanel();
conditionScrollPane.setViewportView(conditionPanel);
JPanel querysPanel = new JPanel();
queryScrollPane.setViewportView(querysPanel);
JPanel tablesPanel = new JPanel();
addTableScrollPane.setViewportView(tablesPanel);
tablesPanel.setLayout(new GridLayout(0, 5, 5, 5));
querysPanel.setLayout(new GridLayout(0, 6, 5, 5));
conditionPanel.setLayout(new GridLayout(0, 8, 5, 5));
String[] tablesArr = new String[] { "关联关系", "表1", "表2", "表1字段", "表2字段" };
String[] querysArr = new String[] { "表名", "字段", "中文名称", "字段类型", "类型描述", "是否可排序" };
String[] conditionsArr = new String[] { "关联关系", "表名", "字段", "中文名称", "字段类型", "类型描述", "比较关系", "固定值" };
List<TableRelationModel> tableRelationModelLists = new ArrayList<TableRelationModel>();
Map<String, String> tableMap = new HashMap<>();
addTable.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
addQuery.setEnabled(false);
addCondition.setEnabled(false);
if (tablesPanel.getComponentCount() == 0) {
for (String tableStr : tablesArr) {
JLabel label = new JLabel(tableStr);
tablesPanel.add(label);
}
addTableMethod(tablesPanel);
((Table2) tablesPanel.getComponent(7)).setEnabled(false);
((Table1Fileds) tablesPanel.getComponent(8)).setEnabled(false);
((Table1Fileds) tablesPanel.getComponent(8)).setText("/");
((Table2Fileds) tablesPanel.getComponent(9)).setEnabled(false);
((Table2Fileds) tablesPanel.getComponent(9)).setText("/");
} else {
addTableMethod(tablesPanel);
}
frame.validate();
frame.repaint();
}
private void addTableMethod(JPanel tablesPanel) {
List<String> table2List = new ArrayList<>();
if (tablesPanel.getComponentCount() >= 5) {
Component[] components = tablesPanel.getComponents();
for (int i = 5; i < components.length; i++) {
if ("Table1".equals(components[i].getClass().getSimpleName())) {
Table1 table1 = (Table1) components[i];
if ("".equals(table1.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加关联表信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
table2List.add(table1.getText());
}
else if ("Table1Fileds".equals(components[i].getClass().getSimpleName())) {
Table1Fileds table1Fileds = (Table1Fileds) components[i];
if ("".equals(table1Fileds.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加关联表信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
}
else if ("Table2Fileds".equals(components[i].getClass().getSimpleName())) {
Table2Fileds table2Fileds = (Table2Fileds) components[i];
if ("".equals(table2Fileds.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加关联表信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
}
}
}
JComboBox<String> relationComBox = null;
// 如果是第一次添加
if (tablesPanel.getComponentCount() == 5) {
// 关联关系
relationComBox = new JComboBox<>(new String[] { "from" });
} else {
// 关联关系
relationComBox = new JComboBox<>(new String[] { "left join", "join", "right join" });
}
// 关联表
Table1 table1 = new Table1();
// 关联字段
Table2 table2 = new Table2();
if (tablesPanel.getComponentCount() >= 10) {
table2.setModel(new DefaultComboBoxModel<>(table2List.toArray(new String[] {})));
}
Table1Fileds table1Fileds = new Table1Fileds();
Table2Fileds table2Fileds = new Table2Fileds();
tablesPanel.add(relationComBox);
tablesPanel.add(table1);
tablesPanel.add(table2);
tablesPanel.add(table1Fileds);
tablesPanel.add(table2Fileds);
}
});
addQuery.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (!canAddQuery(querysPanel)) {
return;
}
if (querysPanel.getComponentCount() == 0) {
for (String queryStr : querysArr) {
JLabel label = new JLabel(queryStr);
querysPanel.add(label);
}
addQueryMethod(querysPanel);
} else {
addQueryMethod(querysPanel);
}
frame.validate();
frame.repaint();
}
private boolean canAddQuery(JPanel querysPanel) {
if (querysPanel.getComponentCount() >= 10) {
Component[] components = querysPanel.getComponents();
for (int i = 6; i < components.length; i++) {
if ("Filed_eng".equals(components[i].getClass().getSimpleName())) {
Filed_eng filed_eng = (Filed_eng) components[i];
if ("".equals(filed_eng.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加查询字段信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
else if ("Filed_cn".equals(components[i].getClass().getSimpleName())) {
Filed_cn filed_cn = (Filed_cn) components[i];
if ("".equals(filed_cn.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加查询字段信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
else if ("ServiceTypeComboBox".equals(components[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
ServiceTypeComboBox<String> serviceTypeComboBox = (ServiceTypeComboBox<String>) components[i];
if ("布尔".equals(serviceTypeComboBox.getSelectedItem())
|| "状态码".equals(serviceTypeComboBox.getSelectedItem())) {
FiledComment filedComment = (FiledComment) components[i + 1];
if ("".equals(filedComment.getText())) {
JOptionPane.showMessageDialog(frame, "布尔或状态码的类型描述不能为空！！详细请见配置说明！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
}
}
}
return true;
}
private void addQueryMethod(JPanel querysPanel) {
Set<String> tables = tableMap.keySet();
String[] tableArr = tables.toArray(new String[] {});
// 表名
JComboBox<String> tableName = new JComboBox<>(tableArr);
// 字段
JTextField tableFiled = new Filed_eng();
// 中文名称
JTextField tableFiled_cn = new Filed_cn();
// 字段类型
JComboBox<String> filedType = new ServiceTypeComboBox<>();
String[] typeList = new String[] { "字符串", "数字", "布尔", "状态码", "日期", "文字域" };
filedType.setModel(new DefaultComboBoxModel<String>(typeList));
// 类型描述
JTextField filedComment = new FiledComment();
// 是否可排序
JComboBox<String> comboBox = new OrderComboBox<String>();
comboBox.setModel(new DefaultComboBoxModel<String>(new String[] { "否", "是" }));
querysPanel.add(tableName);
querysPanel.add(tableFiled);
querysPanel.add(tableFiled_cn);
querysPanel.add(filedType);
querysPanel.add(filedComment);
querysPanel.add(comboBox);
}
});
addCondition.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (!canAddCondition(conditionPanel)) {
return;
}
if (conditionPanel.getComponentCount() == 0) {
for (String conditionArr : conditionsArr) {
JLabel label = new JLabel(conditionArr);
conditionPanel.add(label);
}
addConditionMethod(conditionPanel);
conditionPanel.getComponent(8).setVisible(false);
} else {
addConditionMethod(conditionPanel);
}
frame.validate();
frame.repaint();
}
private boolean canAddCondition(JPanel conditionPanel) {
if (conditionPanel.getComponentCount() >= 16) {
Component[] components = conditionPanel.getComponents();
for (int i = 8; i < components.length; i++) {
if ("Filed_eng".equals(components[i].getClass().getSimpleName())) {
Filed_eng filed_eng = (Filed_eng) components[i];
if ("".equals(filed_eng.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加查询字段信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
else if ("Filed_cn".equals(components[i].getClass().getSimpleName())) {
Filed_cn filed_cn = (Filed_cn) components[i];
if ("".equals(filed_cn.getText())) {
JOptionPane.showMessageDialog(frame, "请先把当前内容填写完毕再增加查询字段信息！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
else if ("ServiceTypeComboBox".equals(components[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
ServiceTypeComboBox<String> serviceTypeComboBox = (ServiceTypeComboBox<String>) components[i];
if ("布尔".equals(serviceTypeComboBox.getSelectedItem())
|| "状态码".equals(serviceTypeComboBox.getSelectedItem())) {
FiledComment filedComment = (FiledComment) components[i + 1];
if ("".equals(filedComment.getText())) {
JOptionPane.showMessageDialog(frame, "布尔或状态码的类型描述不能为空！！详细请见配置说明！", "提示",
JOptionPane.INFORMATION_MESSAGE);
return false;
}
}
}
}
}
return true;
}
private void addConditionMethod(JPanel conditionsPanel) {
// 关联关系
JComboBox<String> relationComBox = new RelationJcombox<>();
relationComBox.setModel(new DefaultComboBoxModel<>(new String[] { "and", "or" }));
// 表名
Set<String> tables = tableMap.keySet();
String[] tableArr = tables.toArray(new String[] {});
JComboBox<String> tableName = new JComboBox<>(tableArr);
// 字段
JTextField tableFiled = new Filed_eng();
// 中文名称
JTextField tableFiled_cn = new Filed_cn();
// 字段类型
JComboBox<String> filedType = new ServiceTypeComboBox<>();
String[] typeList = new String[] { "字符串", "数字", "布尔", "状态码", "日期", "文字域" };
filedType.setModel(new DefaultComboBoxModel<String>(typeList));
FiledComment filedComment = new FiledComment();
// 比较关系
JComboBox<String> compareRelation = new CompareComboBox<>();
compareRelation.setModel(
new DefaultComboBoxModel<>(new String[] { "=", "like", ">=", "<=", "!=", ">= && <=" }));
// 固定值
JTextField unchangeValue = new JTextField();
conditionsPanel.add(relationComBox);
conditionsPanel.add(tableName);
conditionsPanel.add(tableFiled);
conditionsPanel.add(tableFiled_cn);
conditionsPanel.add(filedType);
conditionsPanel.add(filedComment);
conditionsPanel.add(compareRelation);
conditionsPanel.add(unchangeValue);
}
});
restart.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
tablesPanel.removeAll();
querysPanel.removeAll();
conditionPanel.removeAll();
frame.validate();
frame.repaint();
}
});
confirm.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String modelName = currentModelName.getText();
String modelNameCn = currentModelName_cn.getText();
if ("".equals(modelName) || "".equals(modelNameCn)) {
JOptionPane.showMessageDialog(frame, "中文和英文模块名称不可以为空！请填写！", "错误", JOptionPane.ERROR_MESSAGE);
return;
}
if (!checkRelTable(tablesPanel, tableRelationModelLists, tableMap)) {
return;
}
String selectTableSql = "";
for (int i = 0; i < tableRelationModelLists.size(); i++) {
TableRelationModel tableRelationModel = tableRelationModelLists.get(i);
// 如果是第一个
String anotherTableName = tableRelationModel.getAnotherTableName();
String table2Text = tableRelationModel.getTable2_text();
if (i == 0) {
selectTableSql += " " + tableRelationModel.getRelation() + " "
+ tableRelationModel.getTable1_text() + " " + anotherTableName + " ";
continue;
}
selectTableSql += " " + tableRelationModel.getRelation() + " " + tableRelationModel.getTable1_text()
+ " " + anotherTableName + " ON ";
String table1Fileds = tableRelationModel.getTable1Fileds_text();
String table2Fileds = tableRelationModel.getTable2Fileds_text();
String[] table1FiledsArr = table1Fileds.split("&");
String[] table2FiledsArr = table2Fileds.split("&");
if (table1FiledsArr.length != table2FiledsArr.length) {
JOptionPane.showMessageDialog(frame, "关联表配置中第 " + (i + 1) + " 行表1和表2的关联字段的个数不相等，请检查后重新配置！",
"错误", JOptionPane.ERROR_MESSAGE);
return;
}
for (int j = 0; j < table1FiledsArr.length; j++) {
if (j == table1FiledsArr.length - 1) {
selectTableSql += anotherTableName + "." + table1FiledsArr[j] + " = "
+ tableMap.get(table2Text) + "." + table2FiledsArr[j];
break;
}
selectTableSql += anotherTableName + "." + table1FiledsArr[j] + " = " + tableMap.get(table2Text)
+ "." + table2FiledsArr[j] + " and ";
}
}
System.out.println(selectTableSql);
Component[] queryComponents = querysPanel.getComponents();
List<TableFiledModel> tableFiledModels = new ArrayList<>();
// 查询panel的信息
for (int i = 6; i < queryComponents.length; i++) {
if ("JComboBox".equals(queryComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
JComboBox<String> comboBox = (JComboBox<String>) queryComponents[i];
TableFiledModel filedModel = new TableFiledModel();
filedModel.setComboBox(comboBox);
filedModel.setTableName((String) comboBox.getSelectedItem());
filedModel.setAnotherTableName(tableMap.get((String) comboBox.getSelectedItem()));
tableFiledModels.add(filedModel);
}
else if ("Filed_eng".equals(queryComponents[i].getClass().getSimpleName())) {
Filed_eng filed_eng = (Filed_eng) queryComponents[i];
String engFiled = filed_eng.getText();
if ("".equals(engFiled)) {
JOptionPane.showMessageDialog(frame, "添加查询字段中的字段列不能为空！请填写！！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
TableFiledModel tableFiledModel = tableFiledModels.get(tableFiledModels.size() - 1);
tableFiledModel.setFiled_eng(filed_eng);
tableFiledModel.setFiledText_eng(engFiled);
tableFiledModel.setAnotherFiledName(tableFiledModel.getAnotherTableName() + "_" + engFiled);
}
else if ("Filed_cn".equals(queryComponents[i].getClass().getSimpleName())) {
Filed_cn filed_cn = (Filed_cn) queryComponents[i];
String cnFiled = filed_cn.getText();
if ("".equals(cnFiled)) {
JOptionPane.showMessageDialog(frame, "添加查询字段中的中文名称列不能为空！请填写！！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
tableFiledModels.get(tableFiledModels.size() - 1).setFiled_cn(filed_cn);
tableFiledModels.get(tableFiledModels.size() - 1).setFiledText_cn(cnFiled);
}
else if ("ServiceTypeComboBox".equals(queryComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
ServiceTypeComboBox<String> serviceTypeComboBox = (ServiceTypeComboBox<String>) queryComponents[i];
String filedType = (String) serviceTypeComboBox.getSelectedItem();
tableFiledModels.get(tableFiledModels.size() - 1).setServiceTypeComboBox(serviceTypeComboBox);
tableFiledModels.get(tableFiledModels.size() - 1).setFiledType(filedType);
}
else if ("FiledComment".equals(queryComponents[i].getClass().getSimpleName())) {
FiledComment filedComment = (FiledComment) queryComponents[i];
String comment = filedComment.getText();
String[] serviceArr = comment.split("#");
TableFiledModel tableFiledModel = tableFiledModels.get(tableFiledModels.size() - 1);
tableFiledModel.setTextFiled(filedComment);
tableFiledModel.setFiledCommentStr(comment);
String filedType = tableFiledModel.getFiledType();
Map<String, Object> map = new HashMap<>();
if ("布尔".equals(filedType)) {
try {
map.put("是", serviceArr[0]);
map.put("否", serviceArr[1]);
tableFiledModel.setFiledComment(map);
} catch (Exception e1) {
JOptionPane.showMessageDialog(frame, "布尔值的类型描述填写有误，请检查重写！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
}
if ("状态码".equals(filedType)) {
try {
for (String serviece : serviceArr) {
String[] arr = serviece.split("&");
map.put(arr[0], arr[1]);
}
tableFiledModel.setFiledComment(map);
} catch (Exception e1) {
JOptionPane.showMessageDialog(frame, "状态码的类型描述填写有误，请检查重写！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
}
}
else if ("OrderComboBox".equals(queryComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
OrderComboBox<String> orderComboBox = (OrderComboBox<String>) queryComponents[i];
String canSort = (String) orderComboBox.getSelectedItem();
tableFiledModels.get(tableFiledModels.size() - 1).setOrderComboBox(orderComboBox);
tableFiledModels.get(tableFiledModels.size() - 1).setCanSort(canSort);
}
}
if (tableFiledModels.size() == 0) {
JOptionPane.showMessageDialog(frame, "请配置查询字段信息！", "错误", JOptionPane.ERROR_MESSAGE);
return;
}
Component[] conditionComponents = conditionPanel.getComponents();
List<TableConditionModel> tableConditionModels = new ArrayList<>();
// 查询panel的信息
for (int i = 6; i < conditionComponents.length; i++) {
if ("RelationJcombox".equals(conditionComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
RelationJcombox<String> comboBox = (RelationJcombox<String>) conditionComponents[i];
TableConditionModel conditionModel = new TableConditionModel();
conditionModel.setRelationJcombox(comboBox);
conditionModel.setRelation((String) comboBox.getSelectedItem());
tableConditionModels.add(conditionModel);
}
else if ("JComboBox".equals(conditionComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
JComboBox<String> comboBox = (JComboBox<String>) conditionComponents[i];
tableConditionModels.get(tableConditionModels.size() - 1).setComboBox(comboBox);
// 设置表名
tableConditionModels.get(tableConditionModels.size() - 1)
.setTableName((String) comboBox.getSelectedItem());
// 设置表别名
tableConditionModels.get(tableConditionModels.size() - 1)
.setAnotherTableName(tableMap.get((String) comboBox.getSelectedItem()));
}
else if ("Filed_eng".equals(conditionComponents[i].getClass().getSimpleName())) {
Filed_eng filed_eng = (Filed_eng) conditionComponents[i];
String engFiled = filed_eng.getText();
if ("".equals(engFiled)) {
JOptionPane.showMessageDialog(frame, "添加条件字段中的字段列不能为空！请填写！！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
tableConditionModels.get(tableConditionModels.size() - 1).setFiled_eng_textFiled(filed_eng);
tableConditionModels.get(tableConditionModels.size() - 1).setFiled_eng(engFiled);
}
else if ("Filed_cn".equals(conditionComponents[i].getClass().getSimpleName())) {
Filed_cn filed_cn = (Filed_cn) conditionComponents[i];
String cnFiled = filed_cn.getText();
if ("".equals(cnFiled)) {
JOptionPane.showMessageDialog(frame, "添加条件字段中的中文名称列不能为空！请填写！！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
tableConditionModels.get(tableConditionModels.size() - 1).setFiled_cn_textFiled(filed_cn);
tableConditionModels.get(tableConditionModels.size() - 1).setFiled_cn(cnFiled);
}
else if ("ServiceTypeComboBox".equals(conditionComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
ServiceTypeComboBox<String> serviceTypeComboBox = (ServiceTypeComboBox<String>) conditionComponents[i];
String filedType = (String) serviceTypeComboBox.getSelectedItem();
tableConditionModels.get(tableConditionModels.size() - 1)
.setServiceTypeComboBox(serviceTypeComboBox);
tableConditionModels.get(tableConditionModels.size() - 1).setServiceType(filedType);
}
else if ("FiledComment".equals(conditionComponents[i].getClass().getSimpleName())) {
FiledComment filedComment = (FiledComment) conditionComponents[i];
String comment = filedComment.getText();
String[] serviceArr = comment.split("#");
TableConditionModel tableConditionModel = tableConditionModels
.get(tableConditionModels.size() - 1);
tableConditionModel.setFiledComment(filedComment);
String filedType = tableConditionModel.getServiceType();
Map<String, Object> map = new HashMap<>();
if ("布尔".equals(filedType)) {
try {
map.put("是", serviceArr[0]);
map.put("否", serviceArr[1]);
tableConditionModel.setServiceText(map);
} catch (Exception e1) {
JOptionPane.showMessageDialog(frame, "布尔值的类型描述填写有误，请检查重写！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
}
if ("状态码".equals(filedType)) {
try {
for (String serviece : serviceArr) {
String[] arr = serviece.split("&");
map.put(arr[0], arr[1]);
}
tableConditionModel.setServiceText(map);
} catch (Exception e1) {
JOptionPane.showMessageDialog(frame, "状态码的类型描述填写有误，请检查重写！", "错误",
JOptionPane.ERROR_MESSAGE);
return;
}
}
}
else if ("CompareComboBox".equals(conditionComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
CompareComboBox<String> compareComboBox = (CompareComboBox<String>) conditionComponents[i];
String compareText = (String) compareComboBox.getSelectedItem();
tableConditionModels.get(tableConditionModels.size() - 1).setCompareComboBox(compareComboBox);
tableConditionModels.get(tableConditionModels.size() - 1).setCompareText(compareText);
}
else if ("JTextField".equals(conditionComponents[i].getClass().getSimpleName())) {
JTextField textField = (JTextField) conditionComponents[i];
String unchangeValue = textField.getText();
tableConditionModels.get(tableConditionModels.size() - 1).setTextFiled(textField);
tableConditionModels.get(tableConditionModels.size() - 1).setUnchangeValue(unchangeValue);
}
}
if (tableConditionModels.size() == 0) {
JOptionPane.showMessageDialog(frame, "请配置条件字段信息！", "错误", JOptionPane.ERROR_MESSAGE);
return;
}
TablesQueryModel tablesQueryModel = new TablesQueryModel();
// 储存多表查询的信息配置
tablesQueryModel.setFormSql(selectTableSql);
List<TableRelationModel> realTableRelationModelLists = new ArrayList<>();
realTableRelationModelLists.addAll(tableRelationModelLists);
tablesQueryModel.setTableRelationModelLists(realTableRelationModelLists);
tablesQueryModel.setTableFiledModels(tableFiledModels);
tablesQueryModel.setTableConditionModels(tableConditionModels);
if (ChildWindowConstant.tablesQueryMap.containsKey(modelName)) {
int getCodeConfirmDialog = JOptionPane.showConfirmDialog(frame,
"当前模块名称‘" + modelName + "’已存在，确认覆盖？", "提示", JOptionPane.YES_NO_OPTION);
if (getCodeConfirmDialog != 0) {
return;
}
}
ChildWindowConstant.tablesQueryMap.put(modelName, tablesQueryModel);
ChildWindowConstant.tablesQueryEndAndCnMap.put(modelName, modelNameCn);
JOptionPane.showMessageDialog(frame, "当前模块配置成功！", "提示", JOptionPane.INFORMATION_MESSAGE);
String[] modelArr = ChildWindowConstant.tablesQueryMap.keySet().toArray(new String[] {});
tableConfigExit.setModel(new DefaultComboBoxModel<>(new String[] { "--请选择--" }));
for (String model : modelArr) {
tableConfigExit.addItem(model);
}
tablesPanel.removeAll();
querysPanel.removeAll();
conditionPanel.removeAll();
frame.validate();
frame.repaint();
}
});
confirmRelTable.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (!checkRelTable(tablesPanel, tableRelationModelLists, tableMap)) {
return;
}
addQuery.setEnabled(true);
addCondition.setEnabled(true);
Component[] queryComponents = querysPanel.getComponents();
for (int i = 6; i < queryComponents.length; i++) {
if ("JComboBox".equals(queryComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
JComboBox<String> comboBox = (JComboBox<String>) queryComponents[i];
Set<String> tables = tableMap.keySet();
comboBox.removeAllItems();
for (String table : tables) {
comboBox.addItem(table);
}
}
}
Component[] conditionComponents = conditionPanel.getComponents();
for (int i = 8; i < conditionComponents.length; i++) {
if ("JComboBox".equals(conditionComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
JComboBox<String> comboBox = (JComboBox<String>) conditionComponents[i];
Set<String> tables = tableMap.keySet();
comboBox.removeAllItems();
for (String table : tables) {
comboBox.addItem(table);
}
}
}
frame.validate();
frame.repaint();
}
});
tableConfigExit.addItemListener(new ItemListener() {
public void itemStateChanged(ItemEvent e) {
if (e.getStateChange() != 1) {
return;
}
// 选取的当前模块
String currentModel = tableConfigExit.getSelectedItem().toString();
if ("--请选择--".equals(currentModel)) {
tablesPanel.removeAll();
querysPanel.removeAll();
conditionPanel.removeAll();
currentModelName.setText("");
currentModelName_cn.setText("");
frame.validate();
frame.repaint();
return;
}
currentModelName.setText(currentModel);
String currentCnModelName = ChildWindowConstant.tablesQueryEndAndCnMap.get(currentModel);
currentModelName_cn.setText(currentCnModelName);
TablesQueryModel tablesQueryModel = ChildWindowConstant.tablesQueryMap.get(currentModel);
List<TableRelationModel> tableRelations = tablesQueryModel.getTableRelationModelLists();
List<TableFiledModel> tableFileds = tablesQueryModel.getTableFiledModels();
List<TableConditionModel> tableConditions = tablesQueryModel.getTableConditionModels();
// 移除三个panel所有的组件
tablesPanel.removeAll();
querysPanel.removeAll();
conditionPanel.removeAll();
// 加入表头和内容
for (String tableStr : tablesArr) {
JLabel label = new JLabel(tableStr);
tablesPanel.add(label);
}
for (TableRelationModel tableRelation : tableRelations) {
tablesPanel.add(tableRelation.getComboBox());
tablesPanel.add(tableRelation.getTable1());
tablesPanel.add(tableRelation.getTable2());
tablesPanel.add(tableRelation.getTable1Fileds());
tablesPanel.add(tableRelation.getTable2Fileds());
}
for (String queryStr : querysArr) {
JLabel label = new JLabel(queryStr);
querysPanel.add(label);
}
for (TableFiledModel tableFiled : tableFileds) {
querysPanel.add(tableFiled.getComboBox());
querysPanel.add(tableFiled.getFiled_eng());
querysPanel.add(tableFiled.getFiled_cn());
querysPanel.add(tableFiled.getServiceTypeComboBox());
querysPanel.add(tableFiled.getTextFiled());
querysPanel.add(tableFiled.getOrderComboBox());
}
for (String conditionStr : conditionsArr) {
JLabel label = new JLabel(conditionStr);
conditionPanel.add(label);
}
for (TableConditionModel tableCondition : tableConditions) {
conditionPanel.add(tableCondition.getRelationJcombox());
conditionPanel.add(tableCondition.getComboBox());
conditionPanel.add(tableCondition.getFiled_eng_textFiled());
conditionPanel.add(tableCondition.getFiled_cn_textFiled());
conditionPanel.add(tableCondition.getServiceTypeComboBox());
conditionPanel.add(tableCondition.getFiledComment());
conditionPanel.add(tableCondition.getCompareComboBox());
conditionPanel.add(tableCondition.getTextFiled());
}
frame.validate();
frame.repaint();
}
});
frame.getContentPane().setLayout(groupLayout);
}
private boolean checkRelTable(JPanel tablesPanel, List<TableRelationModel> tableRelationModelLists,
Map<String, String> tableMap) {
// 清空集合
tableRelationModelLists.clear();
tableMap.clear();
Component[] tableComponents = tablesPanel.getComponents();
// 读取关联表的配置信息
for (int i = 4; i < tableComponents.length; i++) {
if ("JComboBox".equals(tableComponents[i].getClass().getSimpleName())) {
@SuppressWarnings("unchecked")
JComboBox<String> comboBox = (JComboBox<String>) tableComponents[i];
TableRelationModel tableRelationModel = new TableRelationModel();
tableRelationModel.setComboBox(comboBox);
tableRelationModel.setRelation((String) comboBox.getSelectedItem());
tableRelationModelLists.add(tableRelationModel);
}
else if ("Table1".equals(tableComponents[i].getClass().getSimpleName())) {
Table1 table1 = (Table1) tableComponents[i];
tableRelationModelLists.get(tableRelationModelLists.size() - 1).setTable1(table1);
tableRelationModelLists.get(tableRelationModelLists.size() - 1).setTable1_text(table1.getText());
// 表别名
tableRelationModelLists.get(tableRelationModelLists.size() - 1)
.setAnotherTableName("T" + (tableRelationModelLists.size() - 1));
}
else if ("Table2".equals(tableComponents[i].getClass().getSimpleName())) {
Table2 table2 = (Table2) tableComponents[i];
tableRelationModelLists.get(tableRelationModelLists.size() - 1).setTable2(table2);
tableRelationModelLists.get(tableRelationModelLists.size() - 1)
.setTable2_text((String) table2.getSelectedItem());
}
else if ("Table1Fileds".equals(tableComponents[i].getClass().getSimpleName())) {
Table1Fileds table1Fileds = (Table1Fileds) tableComponents[i];
tableRelationModelLists.get(tableRelationModelLists.size() - 1).setTable1Fileds(table1Fileds);
tableRelationModelLists.get(tableRelationModelLists.size() - 1)
.setTable1Fileds_text(table1Fileds.getText());
}
else if ("Table2Fileds".equals(tableComponents[i].getClass().getSimpleName())) {
Table2Fileds table2Fileds = (Table2Fileds) tableComponents[i];
tableRelationModelLists.get(tableRelationModelLists.size() - 1).setTable2Fileds(table2Fileds);
tableRelationModelLists.get(tableRelationModelLists.size() - 1)
.setTable2Fileds_text(table2Fileds.getText());
}
}
// 如果集合大小为0，说明没配
if (tableRelationModelLists.size() == 0) {
JOptionPane.showMessageDialog(frame, "请先配置关联表信息！！！", "提示", JOptionPane.INFORMATION_MESSAGE);
return false;
}
// 检查关联表配置有没有字段为空
for (int i = 0; i < tableRelationModelLists.size(); i++) {
TableRelationModel tableRelationModel = tableRelationModelLists.get(i);
if ("".equals(tableRelationModel.getTable1_text()) || "".equals(tableRelationModel.getTable1Fileds_text())
|| "".equals(tableRelationModel.getTable2Fileds_text())) {
JOptionPane.showMessageDialog(frame, "表1，表1字段，表2字段不能为空！！请填写！！", "错误", JOptionPane.ERROR_MESSAGE);
return false;
}
// 动态表名称使用
tableMap.put(tableRelationModel.getTable1_text(), tableRelationModel.getAnotherTableName());
}
return true;
}
}
处理一下没有的依赖，稍微一鼓捣应该就可以直接运行起来。接下来我们来看一下添加的几个主要的freemarker模板
添加的主要模板
此次更新主要添加了IMutiTableDao.ftl，IMutiTableService.ftl，MutiTableService.ftl，mutiTableHtml.ftl，MutiTableSqlMapper.ftl，mybatis-config.ftl这几个freemarker模板，同时对现存的某些模板做了微小的改动，在这里我把有关多表查询的方法全部放在了MutiTableService这个类里，看一下源码：
package ${packageName}.service.impl;
import java.lang.reflect.Method;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import ${packageName}.dao.IMutiTableDao;
import ${packageName}.service.IMutiTableService;
import ${packageName}.utils.CastUtil;
import ${packageName}.utils.ExcelUtil;
@Service
public class MutiTableService implements IMutiTableService {
@Autowired
private IMutiTableDao dao;
private Map<String, Object> commonSelect(Map<String, Object> map, String modelName) throws Exception {
List<String> orderData = CastUtil.cast(map.get("orderData"));
String orderStr = "";
for (int i = 0; i < orderData.size(); i++) {
if (i == orderData.size() - 1) {
orderStr += orderData.get(i);
break;
}
orderStr += orderData.get(i) + ",";
}
Integer currentPage = (Integer) map.get("currentPage");
Integer start = (currentPage - 1) * 10;
Long totalPage = 1L;
// sql中的start
map.put("start", start);
// 每页显示10条
map.put("pageSize", 10);
// 排序条件
map.put("orderStr", orderStr);
// 获取总个数
Method getCountMethod = dao.getClass().getMethod(modelName + "SelectCount", Map.class);
Long totalCount = (Long) getCountMethod.invoke(dao, map);
Method getResultListMethod = dao.getClass().getMethod(modelName + "Select", Map.class);
List<Map<String, Object>> resultList = CastUtil.cast(getResultListMethod.invoke(dao, map));
if (totalCount != 0) {
if (totalCount % 10 == 0) {
totalPage = totalCount / 10;
} else {
totalPage = totalCount / 10 + 1;
}
}
map.clear();
// 当前页
map.put("currentPage", currentPage);
map.put("count", totalCount);
map.put("totalPage", totalPage);
map.put("result", resultList);
return map;
}
<#list tablesQueryMap?keys as key>
<#assign tableFiledModels = tablesQueryMap["${key}"].tableFiledModels/>
/**
* ${key}查询
*
*/
@Override
public Map<String, Object> ${key}Select(Map<String, Object> map) {
try {
return commonSelect(map, "${key}");
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
* ${key}导出excel
*
*/
@Override
public void ${key}ExportExcel(HttpServletResponse response) {
// 获取头部信息
String[] headList = new String[] {<#list tableFiledModels as data> "${data.filedText_cn}"<#if data_has_next>,</#if></#list>};
String[] describeList = new String[] {<#list tableFiledModels as data> "${data.filedCommentStr}"<#if data_has_next>,</#if></#list>};
try {
ExcelUtil.mutiTablexportExcel(response, dao, "${key}", headList, describeList);
} catch (Exception e) {
e.printStackTrace();
}
}
</#list>
}
这里把查询的方法抽取成了一个commonSelect的公共方法，避免代码冗余。另外发现了mybatis的一个坑，如果mybatis查询的某个字段为null，默认查出来的结果会不包含这个字段的key，为了避免这种现象的发生，特地加了一个全局配置：mybatis-config.ftl，源码如下：
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<setting name="callSettersOnNulls" value="true"/>
</settings>
</configuration>
最终运行效果
软件的主界面做了一项更改，原来数据表必须要配置才行，现在可以选择不配置，其实所有的信息都可以不配置，直接生成代码就是最原始的框架，但是写的代码有些耦合，以后再修改吧，如图：
数据项配置就不看了，直接去高级配置下的多表联查配置，配置好信息，如图：
在这里我是用一个中间表关联了两个主表，看一下数据库结构：
patientrelmedicine（中间表）表的patientNo对应patient（病人）表的caseNO，medicineId对应medicinemsg（药物信息）表的id，这三个字段使用left join相关联，获取的就是所有病人对应的开药信息了。
配置多表查询的时候有一点需要注意，每次配置完第一个关联表模块需要点击一下后面的确定，不然不会生效。也就是这么个顺序：关联表配置——》点击后面的确定——》查询字段配制 or 条件字段配置——》点击下方确定。
确定后回到主界面，这里以springboot为例，生成代码：
看一下生成的项目：
让我们看一下生成的mapper文件，代码如下：
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="freeout.dao.IMutiTableDao">
<select id="patientrelmedicineSelect" parameterType="java.util.HashMap"
resultType="java.util.LinkedHashMap">
select
T1.caseNo T1_caseNo,
T1.name T1_name,
T1.sex T1_sex,
T2.name T2_name,
T2.price T2_price,
T2.addTime T2_addTime
from patientrelmedicine T0 left join patient T1 ON T1.caseNo = T0.patientNo left join medicinemsg T2 ON T2.id = T0.medicineId
<where>
<if test="T1_name != null and T1_name != '' ">
and T1.name <![CDATA[=]]> #{T1_name}
</if>
<if test="T1_sex != null and T1_sex != '' ">
and T1.sex <![CDATA[=]]> #{T1_sex}
</if>
and T2.status <![CDATA[=]]> '0'
</where>
<if test="orderStr != '' and orderStr != null">
order by ${orderStr}
</if>
<if test="start != null and pageSize != null">
limit #{start},#{pageSize}
</if>
</select>
<select id="patientrelmedicineSelectCount" parameterType="java.util.HashMap"
resultType="java.lang.Long">
SELECT
count(1)
from patientrelmedicine T0 left join patient T1 ON T1.caseNo = T0.patientNo left join medicinemsg T2 ON T2.id = T0.medicineId
<where>
<if test="T1_name != null and T1_name != '' ">
and T1.name <![CDATA[=]]> #{T1_name}
</if>
<if test="T1_sex != null and T1_sex != '' ">
and T1.sex <![CDATA[=]]> #{T1_sex}
</if>
and T2.status <![CDATA[=]]> '0'
</where>
</select>
</mapper>
这里生成的sql还是比较规范的，同时也生成了表和字段的别名，主要是为了避免名称重复，出现错误。
把生成的项目跑起来，界面如下：
多表查询的界面已经生成，还是比较不错的
测试一下导出excel，生成的excel如下，没有问题:
顺便提一句，单表查询模块的更新和删除功能之前由于模板更新错误，导致点击不生效的问题已经解决！
本次更新就到此结束了，主要是增加了多表查询这么一个大的功能模板以及一些细节的优化处理，下一步看一下能不能增加图表支持或者多弄几套前台模板，现在的前台模板就一个，实在是有些单调，加油！
链接：https://pan.baidu.com/s/1L5gP5sH3LFKA8ZPurPmGhQ
提取码：wxpp
网友评论