英语学习助手数据库课程设计说明书

英语学习助手数据库课程设计说明书英语学习助手数据库课程设计说明书/英语学习助手数据库课程设计说明书广西大学数据库课程设计

学生姓名徐彦冬

学号：1307300210学生姓名蓝玉笛学号：1307300330学院:计电学院专业:网络工程题目:英语学习助手

指导教师：叶进

2015年12月28日目录1.任务分工157472.设计目的1190653.设计内容1195243.1主要的数据表1271483.2主要功能132324.开发和运行环境介绍110725.需求分析1195245.1功能需求1271485.2性能需要1195245.3数据流程图132326.逻辑模型设计132327.系统设计及实现1195247.1模块功能描述1271487.2软件实现1195247.3用户使用说明132328.遇到的问题及相应解决办法110729.个人体会及建议123158参考文献1任务分工徐彦冬（组长）：数据库的建立，所有数据的录入和课程实验报告撰写蓝玉笛：图形界面的建立和功能实现2.设计目的学生根据所学的数据库原理及程序设计的知识，能够针对一个小型的数据库管理系统，进行系统的需求分析，系统设计，数据库设计，编码，测试等，完成题目要求的功能，从而达到掌握开发一个小型数据库的目的。3.设计内容(1)主要的数据表英语分级单词表，常用单词例句表、短文表等等。(2)主要功能1）实现英语单词的录入、修改、删除基本操作。2）实现常用英语单词例句的录入、修改、删除基本操作。3）实现英语单词检索、翻译等。4）常用英语单词例句、短文检索。5）随机生成一份单词测试题目。4.开发和运行环境介绍开发工具：NetBeansIDE8.1,MySQL运行环境：Windows7、Windows8、Windowsxp操作系统。5.需求分析5.1功能需求本系统的功能分为如下几大模块：1.单词模块：包括单词表的建立，单词的录入、修改、删除等基本操作。单词录入要求能够实现录入（增加）单词及其汉语翻译；修改要求能修改单词的拼写以及其汉语意思；删除即能够删除某一单词记录。2.例句模块：包括例句表的建立，例句的录入、修改、删除等基本操作。例句表包括例句及其中文翻译等。例句录入要求能够实现录入（增加）例句及其汉语翻译；修改要求能修改例句的单词以及其汉语意思；删除即能够删除某一例句记录。3.试题模块：随机生成一份相应难度的单词测试表。可以给出英文单词选择其正确的汉语翻译4.检索模块：包括单词检索和例句检索，。单词检索要实现输入一个单词，可以检索出它的汉语翻译。例句检索要能实现输入句子，可以检索出其中文翻译。5.2性能需求（1）尽量采取学校及自身现有软硬件环境，及先进的网络信息资源，从而达到充分利用学校现有资源，提高系统系统开发水平的目的。（2）系统要考虑实用性，尽量实现英汉互译。，并达到操作过程的直观，方便，实用等要求。（3）系统采用模块化程序设计方法，既便于系统功能的各种组合和修改。5.3数据流程图（1）管理员顺序图显示界面管理员数据库显示界面管理员数据库选择身份输入账号密码验证登录信息符合，登录成功不符合，登录失败图1顺序图（2）游客顺序表显示界面游客显示界面游客选择身份验证登录信息类型类型单词（3）E-R图单词英语学习助手例句翻译关键单词英语学习助手例句翻译关键单词单词单词短文短文编号编号编号句子编号句子等级翻译等级翻译图2E-R图6.逻辑模型设计6.1单词表6.2例句表6.3短文表6.4管理员表7.系统设计及实现7.1模块功能描述自测，实现单词和例句的修改实现单词和例句的检索实现例句的录入，删除实现单词的录入，删除7.2软件实现1.添加单词：publicclassAddWordextendsJFrameimplementsActionListener{privatejavax.swing.JButtonjButton1;privatejavax.swing.JButtonjButton2;privatejavax.swing.JLabeljLabel1;privatejavax.swing.JLabeljLabel2;privatejavax.swing.JLabeljLabel3;privatejavax.swing.JLabeljLabel4;privatejavax.swing.JLabeljLabel5;privatejavax.swing.JLabeljLabel6;privatejavax.swing.JScrollPanejScrollPane1;privatejavax.swing.JTextAreajTextArea1;privatejavax.swing.JTextFieldjTextField1;privatejavax.swing.JTextFieldjTextField2;privatejavax.swing.JTextFieldjTextField3;privatejavax.swing.JTextFieldjTextField4;privateStringid="";privateStringurl="";privateStringdriver="";privateStringuser="";privateStringpasswd="";privateConnectionconn=null;privateWordsword=null;privateHandlerhandler=null;publicAddWord(){initComponent();init();}privatevoidinitComponent(){this.setSize(350,400);this.setResizable(false);this.setLocationRelativeTo(null);this.setTitle("添加单词");jLabel1=newjavax.swing.JLabel();jTextField1=newjavax.swing.JTextField();jTextField2=newjavax.swing.JTextField();jTextField3=newjavax.swing.JTextField();jTextField4=newjavax.swing.JTextField();jScrollPane1=newjavax.swing.JScrollPane();jTextArea1=newjavax.swing.JTextArea();jLabel2=newjavax.swing.JLabel();jLabel3=newjavax.swing.JLabel();jLabel4=newjavax.swing.JLabel();jLabel5=newjavax.swing.JLabel();jLabel6=newjavax.swing.JLabel();jButton1=newjavax.swing.JButton();jButton2=newjavax.swing.JButton();jLabel1.setFont(newjava.awt.Font("宋体",0,24));//NOI18NjLabel1.setText("添加单词");jTextArea1.setColumns(20);jTextArea1.setRows(5);jScrollPane1.setViewportView(jTextArea1);jLabel2.setText("编号:");jLabel3.setText("单词:");jLabel4.setText("类型:");jLabel5.setText("等级:");jLabel6.setText("翻译:");jButton1.setText("添加");jButton2.setText("取消");this.jButton1.addActionListener(this);this.jButton2.addActionListener(this);this.url="jdbc:mysql://localhost:3306/transist";this.driver="com.mysql.jdbc.Driver";this.user="root";this.passwd="1234";}添加例句：publicAddExample(){initComponent();init();}privatevoidinitComponent(){this.setSize(350,400);this.setResizable(false);this.setLocationRelativeTo(null);this.setTitle("添加例句");jLabel1=newjavax.swing.JLabel();jTextField1=newjavax.swing.JTextField();jScrollPane1=newjavax.swing.JScrollPane();jTextArea1=newjavax.swing.JTextArea();jLabel2=newjavax.swing.JLabel();jLabel3=newjavax.swing.JLabel();jLabel4=newjavax.swing.JLabel();jLabel6=newjavax.swing.JLabel();jButton1=newjavax.swing.JButton();jButton2=newjavax.swing.JButton();jComboBox1=newjavax.swing.JComboBox<>();jScrollPane2=newjavax.swing.JScrollPane();jTextArea2=newjavax.swing.JTextArea();jLabel1.setFont(newjava.awt.Font("宋体",0,24));//NOI18NjLabel1.setText("添加例句");jTextArea1.setColumns(20);jTextArea1.setRows(5);jScrollPane1.setViewportView(jTextArea1);jLabel2.setText("编号:");jLabel3.setText("单词:");jLabel4.setText("例句:");jLabel6.setText("翻译:");jButton1.setText("添加");jButton2.setText("取消");jTextArea2.setColumns(20);jTextArea2.setRows(5);jScrollPane2.setViewportView(jTextArea2);this.jButton1.addActionListener(this);this.jButton2.addActionListener(this);this.url="jdbc:mysql://localhost:3306/transist";this.driver="com.mysql.jdbc.Driver";this.user="root";this.passwd="1234";添加短文：publicclassAddEassyextendsJFrameimplementsActionListener{privatejavax.swing.JButtonjButton1;privatejavax.swing.JButtonjButton2;privatejavax.swing.JLabeljLabel1;privatejavax.swing.JLabeljLabel2;privatejavax.swing.JLabeljLabel3;privatejavax.swing.JLabeljLabel4;privatejavax.swing.JLabeljLabel5;privatejavax.swing.JLabeljLabel6;privatejavax.swing.JScrollPanejScrollPane1;privatejavax.swing.JScrollPanejScrollPane2;privatejavax.swing.JTextAreajTextArea1;privatejavax.swing.JTextAreajTextArea2;privatejavax.swing.JTextFieldjTextField1;privatejavax.swing.JTextFieldjTextField2;privatejavax.swing.JTextFieldjTextField3;privateStringid="";privateStringurl="";privateStringdriver="";privateStringuser="";privateStringpasswd="";privateConnectionconn=null;privateHandlerhandler=null;privateEassyeassy=null;publicAddEassy(){initComponent();init();}privatevoidinitComponent(){this.setSize(575,615);this.setResizable(false);this.setLocationRelativeTo(null);this.setTitle("添加短文");jLabel1=newjavax.swing.JLabel();jTextField1=newjavax.swing.JTextField();jLabel2=newjavax.swing.JLabel();jLabel3=newjavax.swing.JLabel();jButton1=newjavax.swing.JButton();jButton2=newjavax.swing.JButton();jTextField2=newjavax.swing.JTextField();jScrollPane1=newjavax.swing.JScrollPane();jTextArea1=newjavax.swing.JTextArea();jLabel4=newjavax.swing.JLabel();jTextField3=newjavax.swing.JTextField();jScrollPane2=newjavax.swing.JScrollPane();jTextArea2=newjavax.swing.JTextArea();jLabel5=newjavax.swing.JLabel();jLabel6=newjavax.swing.JLabel();jLabel1.setFont(newjava.awt.Font("宋体",0,24));//NOI18NjLabel1.setText("添加短文");jLabel2.setText("编号:");jLabel3.setText("标题:");jButton1.setText("添加");jButton2.setText("取消");jTextArea1.setColumns(20);jTextArea1.setRows(5);jScrollPane1.setViewportView(jTextArea1);jLabel4.setText("正文:");jTextArea2.setColumns(20);jTextArea2.setRows(5);jScrollPane2.setViewportView(jTextArea2);jLabel5.setText("正文翻译:");jLabel6.setText("标题翻译:");this.jButton1.addActionListener(this);this.jButton2.addActionListener(this);this.url="jdbc:mysql://localhost:3306/transist";this.driver="com.mysql.jdbc.Driver";this.user="root";this.passwd="1234";}privatevoidinit(){javax.swing.GroupLayoutlayout=newjavax.swing.GroupLayout(getContentPane());getContentPane().setLayout(layout);layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGap(41,41,41).addComponent(jButton1).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE).addComponent(jButton2).addGap(43,43,43)).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGap(203,203,203).addComponent(jLabel1)).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGap(27,27,27).addComponent(jLabel2)).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,layout.createSequentialGroup().addGap(17,17,17).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jLabel3,javax.swing.GroupLayout.Alignment.TRAILING).addComponent(jLabel4,javax.swing.GroupLayout.Alignment.TRAILING)))).addGap(25,25,25)).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,layout.createSequentialGroup().addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jLabel5,javax.swing.GroupLayout.Alignment.TRAILING).addComponent(jLabel6,javax.swing.GroupLayout.Alignment.TRAILING)).addGap(18,18,18))).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,false).addComponent(jScrollPane2,javax.swing.GroupLayout.DEFAULT_SIZE,439,Short.MAX_VALUE).addComponent(jTextField1).addComponent(jTextField2).addComponent(jScrollPane1).addComponent(jTextField3)))).addContainerGap(54,Short.MAX_VALUE)));layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addGap(26,26,26).addComponent(jLabel1).addGap(18,18,18).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jTextField1,javax.swing.GroupLayout.PREFERRED_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(jLabel2)).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jTextField2,javax.swing.GroupLayout.PREFERRED_SIZE,48,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(jLabel3)).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED).addComponent(jScrollPane1,javax.swing.GroupLayout.PREFERRED_SIZE,163,javax.swing.GroupLayout.PREFERRED_SIZE)).addGroup(layout.createSequentialGroup().addGap(77,77,77).addComponent(jLabel4))).addGap(18,18,18).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jTextField3,javax.swing.GroupLayout.PREFERRED_SIZE,48,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(jLabel6)).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addComponent(jScrollPane2,javax.swing.GroupLayout.PREFERRED_SIZE,153,javax.swing.GroupLayout.PREFERRED_SIZE).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,30,Short.MAX_VALUE).addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jButton1).addComponent(jButton2))).addGroup(layout.createSequentialGroup().addComponent(jLabel5).addGap(0,0,Short.MAX_VALUE))).addContainerGap()));pack();}publicvoidshowFrame(Handlerhandler){this.handler=handler;this.setVisible(true);}publicvoidaddWord(){Stringnum=this.jTextField1.getText();Stringtitle=this.jTextField2.getText();Stringduanwen=this.jTextArea1.getText();Stringfanyi=this.jTextArea2.getText();Stringtitlefanyi=this.jTextField3.getText();if(num.equals("")){print("请填写编号！");return;}if(title.equals("")){print("请填写标题！");return;}if(duanwen.equals("")){print("请填写正文！");return;}if(fanyi.equals("")){print("请填写翻译！");return;}if(titlefanyi.equals("")){print("请填写标题翻译！");return;}if(againConfirm("确定添加?")!=0){return;}try{Class.forName(driver);this.conn=DriverManager.getConnection(url,user,passwd);Stringsql="insertintoeassyvalues(?,?,?,?,?)";PreparedStatementpsta=this.conn.prepareStatement(sql);psta.setObject(1,num);psta.setObject(2,title);psta.setObject(3,duanwen);psta.setObject(4,titlefanyi);psta.setObject(5,fanyi);psta.executeUpdate();this.conn.close();}catch(Exceptione){e.printStackTrace();}this.eassy=newEassy(num,title,duanwen,fanyi,titlefanyi);if(this.eassy!=null)this.handler.getEassys().add(eassy);this.handler.loadEassyData();this.dispose();}publicvoidprint(Stringmsg){JOptionPane.showMessageDialog(this,msg,"错误",JOptionPane.ERROR_MESSAGE);}publicintagainConfirm(Stringmsg){returnJOptionPane.showConfirmDialog(this,msg,"询问",JOptionPane.YES_NO_OPTION);}@OverridepublicvoidactionPerformed(ActionEvente){if(e.getSource()==this.jButton1){addWord();}if(e.getSource()==this.jButton2){this.dispose();}}}单词、例句和短文检索：publicclassSearchextendsJFrameimplementsActionListener{privatejavax.swing.JButtonjButton1;privatejavax.swing.JButtonjButton2;privatejavax.swing.JButtonjButton3;privatejavax.swing.JComboBox<String>jComboBox1;privatejavax.swing.JComboBox<String>jComboBox2;privatejavax.swing.JPaneljPanel1;privatejavax.swing.JPaneljPanel2;privatejavax.swing.JScrollPanejScrollPane1;privatejavax.swing.JScrollPanejScrollPane2;privatejavax.swing.JScrollPanejScrollPane3;privatejavax.swing.JScrollPanejScrollPane4;privatejavax.swing.JTabbedPanejTabbedPane1;privatejavax.swing.JTextAreajTextArea1;privatejavax.swing.JTextAreajTextArea2;privatejavax.swing.JTextAreajTextArea3;privatejavax.swing.JTextAreajTextArea4;privatejavax.swing.JTextFieldjTextField1;privateSelectselect=null;privateStringid="";privateStringurl="";privateStringdriver="";privateStringuser="";privateStringpasswd="";privateConnectionconn=null;privateList<Words>words=null;privateList<Example>examples=null;privateEassyeassy=null;publicSearch(){initComponent();init();}privatevoidinitComponent(){this.setSize(700,500);this.setResizable(false);this.setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);this.setLocationRelativeTo(null);this.setTitle("检索");this.jTabbedPane1=newjavax.swing.JTabbedPane();this.jPanel1=newjavax.swing.JPanel();this.jComboBox1=newjavax.swing.JComboBox<>();this.jComboBox2=newjavax.swing.JComboBox<>();this.jScrollPane1=newjavax.swing.JScrollPane();this.jTextArea1=newjavax.swing.JTextArea();this.jScrollPane2=newjavax.swing.JScrollPane();this.jTextArea2=newjavax.swing.JTextArea();this.jButton1=newjavax.swing.JButton();this.jButton2=newjavax.swing.JButton();this.jPanel2=newjavax.swing.JPanel();this.jScrollPane3=newjavax.swing.JScrollPane();this.jTextArea3=newjavax.swing.JTextArea();this.jButton3=newjavax.swing.JButton();this.jTextField1=newjavax.swing.JTextField();this.jScrollPane4=newjavax.swing.JScrollPane();this.jTextArea4=newjavax.swing.JTextArea();this.jComboBox1.setModel(newjavax.swing.DefaultComboBoxModel<>(newString[]{"英语","中文"}));this.jComboBox2.setModel(newjavax.swing.DefaultComboBoxModel<>(newString[]{"英语","中文"}));this.jTextArea1.setColumns(20);this.jTextArea1.setRows(5);this.jScrollPane1.setViewportView(jTextArea1);this.jTextArea2.setColumns(20);this.jTextArea2.setRows(5);this.jScrollPane2.setViewportView(jTextArea2);this.jButton1.setText("返回");this.jButton2.setText("翻译");this.jTabbedPane1.addTab("单词检索",jPanel1);this.jTextArea3.setColumns(20);this.jTextArea3.setRows(5);this.jScrollPane3.setViewportView(jTextArea3);this.jButton3.setText("检索");this.jTextArea4.setColumns(20);this.jTextArea4.setRows(5);this.jScrollPane4.setViewportView(jTextArea4);this.jTabbedPane1.addTab("短文检索",jPanel2);this.jTextArea2.setForeground(Color.BLACK);this.jTextArea2.setFont(newFont("宋词",Font.BOLD,13));this.jButton1.addActionListener(this);this.jButton2.addActionListener(this);this.jButton3.addActionListener(this);this.url="jdbc:mysql://localhost:3306/transist";this.driver="com.mysql.jdbc.Driver";this.user="root";this.passwd="1234";this.words=newArrayList<Words>();this.examples=newArrayList<Example>();}privatevoidinit(){javax.swing.GroupLayoutjPanel1Layout=newjavax.swing.GroupLayout(jPanel1);jPanel1.setLayout(jPanel1Layout);jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequentialGroup().addGap(255,255,255).addComponent(jButton2).addGap(0,0,Short.MAX_VALUE)).addGroup(jPanel1Layout.createSequentialGroup().addGap(21,21,21).addComponent(jScrollPane1,javax.swing.GroupLayout.PREFERRED_SIZE,253,javax.swing.GroupLayout.PREFERRED_SIZE).addGap(18,18,18).addComponent(jScrollPane2))).addContainerGap()).addGroup(jPanel1Layout.createSequentialGroup().addGap(82,82,82).addComponent(jComboBox1,javax.swing.GroupLayout.PREFERRED_SIZE,116,javax.swing.GroupLayout.PREFERRED_SIZE).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,230,Short.MAX_VALUE).addComponent(jComboBox2,javax.swing.GroupLayout.PREFERRED_SIZE,131,javax.swing.GroupLayout.PREFERRED_SIZE).addGap(124,124,124)));jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jComboBox1,javax.swing.GroupLayout.PREFERRED_SIZE,35,javax.swing.GroupLayout.PREFERRED_SIZE).addComponent(jComboBox2,javax.swing.GroupLayout.PREFERRED_SIZE,35,javax.swing.GroupLayout.PREFERRED_SIZE)).addGap(18,18,18).addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,false).addComponent(jScrollPane1,javax.swing.GroupLayout.DEFAULT_SIZE,319,Short.MAX_VALUE).addComponent(jScrollPane2)).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,11,Short.MAX_VALUE).addComponent(jButton2)));javax.swing.GroupLayoutjPanel2Layout=newjavax.swing.GroupLayout(jPanel2);jPanel2.setLayout(jPanel2Layout);jPanel2Layout.setHorizontalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel2Layout.createSequentialGroup().addContainerGap().addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(jPanel2Layout.createSequentialGroup().addComponent(jScrollPane3,javax.swing.GroupLayout.PREFERRED_SIZE,305,javax.swing.GroupLayout.PREFERRED_SIZE).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED).addComponent(jScrollPane4,javax.swing.GroupLayout.DEFAULT_SIZE,348,Short.MAX_VALUE)).addGroup(jPanel2Layout.createSequentialGroup().addComponent(jButton3).addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jTextField1))).addContainerGap()));jPanel2Layout.setVerticalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,jPanel2Layout.createSequentialGroup().addGap(20,20,20).addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jButton3).addComponent(jTextField1,javax.swing.GroupLayout.DEFAULT_SIZE,30,Short.MAX_VALUE)).addGap(14,14,14).addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jScrollPane3,javax.swing.GroupLayout.DEFAULT_SIZE,342,Short.MAX_VALUE).addComponent(jScrollPane4)).addContainerGap()));javax.swing.GroupLayoutlayout=newjavax.swing.GroupLayout(getContentPane());getContentPane().setLayout(layout);layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout.createSequentialGroup().addContainerGap().addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jTabbedPane1).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,layout.createSequentialGroup().addGap(0,0,Short.MAX_VALUE).addComponent(jButton1))).addContainerGap()));layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(javax.swing.GroupLayout.Alignment.TRAILING,layout.createSequentialGroup().addContainerGap(24,Short.MAX_VALUE).addComponent(jTabbedPane1,javax.swing.GroupLayout.PREFERRED_SIZE,445,javax.swing.GroupLayout.PREFERRED_SIZE).addGap(8,8,8).addComponent(jButton1)));pack();}publicList<Words>eclishToChinese(Stringeclish){try{if(this.conn==null)returnnull;Stringsql="SELECT*FROMwordsWHEREwordLIKE"+"'%"+eclish+"%'";PreparedStatementpsta=this.conn.prepareStatement(sql);ResultSetres=psta.executeQuery();BeanListHandler<Words>blh=newBeanListHandler<Words>(Words.class);if(res==null)returnnull;