(完整版)java_ATM机银行存取款系统的设计与实现毕业论文

if(list.get(i).getHuming(). equals( e1) { TODO Auto-generated catch block e1.printStackTrace();

} catch (SQLException e1) { }

TODO Auto-generated catch block e1.printStackTrace();

} }

package action;

import java.awt.TextArea; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.SQLException; import java.util.List; import javax.swing.JButton; import javax.swing.JFrame; import vo.Lsvo; import dao.Lsdao; 用户历史界面

public class Lsact extends JFrame implements ActionListener{

private static final long serialVersionUID = 1L; JFrame f=new JFrame(\用户历史查询\);

TextArea t=new TextArea(15,130); setWrapStyleWord();

JButton JB1 = new JButton(\查询\); String (String[]agrs){ }

@Override

public void actionPerformed(ActionEvent e) {

TODO Auto-generated method stub List list=null; try {

list = new Lsdao().ff(); Lsact l=new Lsact(); l.ff(\

} catch (ClassNotFoundException e1) {

TODO Auto-generated catch block e1.printStackTrace();

} catch (SQLException e1) { }

StringBuffer sb = new StringBuffer(); System.out.println(list);

SimpleDateFormat f=new SimpleDateFormat(\ sb.append(\账户 \ + \操作时间

TODO Auto-generated catch block e1.printStackTrace();

\ +\操作 \+ \账户余额 \ +\);

for(int i=0;i

if(list.get(i).getHuming(). equals(()+\ \+

list.get(i).getCaozuo()+\ \+\+ list.get(i).getYue()+\ \ );

System.out.println(list.get(i).getShijian());SimpleDateFormat SimpleDateFormat f=new SimpleDateFormat(\HH:mm:ss\ }

}

System.out.println(f.format(list.get(i).getShijian()));

t.setText(sb.toString()); } }

t.setText(sb.toString());

sb.append(\);

Oracle部分：

建表：

-- Create table create table LISHI (

shijian VARCHAR2(50), key constraints alter table LISHI

add constraint 户名外键 foreign key (HUMING)

references YONGHU (HUMING); -- Create table create table YONGHU ( DATE )

tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage (

initial 64K minextents 1 maxextents unlimited );

-- CreateRecreate primary, unique and foreign key constraints alter table YONGHU

add constraint 户名 primary key (HUMING) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage