- 论坛徽章:
- 0
|
根据这个错误提示:at query.QueryFrame.getEmployees(QueryFrame.java:27)
at query.QueryFrame.actionPerformed(QueryFrame.java:62)
程序里的对应的这两句:
Session session=HibernateUtil.currentSession();
for(Iterator it=getEmployees(content).iterator();it.hasNext(); )
源程序:
package query;
import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Iterator;
import java.util.List;
import javax.swing.*;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
public class QueryFrame extends JFrame implements ActionListener {
/**
*
*/
private static final long serialVersionUID = 1L;
JTextField jf=new JTextField(20);
JButton find=new JButton("查询");
JPanel panel_find=new JPanel();
JPanel panel_content=new JPanel();
public List getEmployees(String empname)throws HibernateException{
Session session=HibernateUtil.currentSession();
Transaction tx=session.beginTransaction();
String sql="from Emloyee where name like '%"+empname+"%'";
Query query=session.createQuery(sql);
List list=query.list();
tx.commit();
HibernateUtil.closeSession();
return list;
}
public QueryFrame(){
this.setTitle("查询系统");
Container c=this.getContentPane();
jf.addActionListener(this);
find.addActionListener(this);
panel_find.add(jf);
panel_find.add(find);
c.add(panel_find, "North");
c.add(panel_content,"Center");
this.setSize(400,400);
this.setLocation(200,100);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e){
panel_content.removeAll();
String content=jf.getText();
int i=0;
for(Iterator it=getEmployees(content).iterator();it.hasNext(); ){
Employee emp=(Employee)it.next();
JLabel label=new JLabel(emp.getId()+""+emp.getName()+""+emp.getDepartment()+""+emp.getSalary());
JPanel panel= new JPanel();
panel.add(label);
panel_content.add(panel);
i++;
}
panel_content.setLayout(new GridLayout(i,1));
panel_content.validate();
}
public static void main(String[] args) {
new QueryFrame();// TODO Auto-generated method stub
}
} |
|