Java固定资产标准管理系统源代码

〃/〃〃/〃〃〃〃〃〃/〃/〃〃/〃/〃〃/〃/〃〃/〃/〃〃〃///〃//〃//〃//〃//〃//〃//〃//〃，〃〃〃//〃//

用户登录

〃/〃〃/〃〃〃〃〃〃/〃/〃〃/〃〃〃/〃〃0///〃/〃/〃〃/〃〃〃/〃〃/〃/〃〃/〃/〃〃/〃，〃〃〃/〃〃/

packagecom.perty;

importjava.awt.GridLayout;

importjava.awt.event.ActionEvent;

importjava.awt.event.ActionListener;

importjava.sql.*;

importjava.sql.Statcmcnt;

importjava.sql.ResultSet;

importjavax.swing.JButton;

importjavax.swing.JLabcl;

importjavax.swing.JTextFicld;

importjavax.swing.JPasswordField;

importjavax.swing.JPanel;

importjavax.swingJFrame;

publicclassuser_landextendsJFrameimplementsActionListener{

staticConnectionconn二null;

staticStatementsiat=null;

staticResultSetrs=null;

staticStringurl="jdbc:sqlserver://l:1433;DatabaseName=_Property";

staticStringuser="sa";

staticStringpassword="";

JPanelpl,p2,p3,p4,p5;

JLabelIbll,lbl2,lbl3,lbl4;

JTextFieldtxt_name;

JPasswordFicld(xt_pwd;

JButtonblnI,btn2,btn3;

sialic{

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

}catch(Exceptione){

System.out.println("加载驱动失败");

e.printSlackTraceO；

publicuser_land(i(

this.setTitle("固定资产及设备用户登录)

p1=newJPanel();

p2=ncwJPanel();

p3=newJPanel();

p4=newJPanel();

p5=newJPanel();

Ibll=newJLabel("欢迎登录)

lbl2=newJLabel("用户名:");

lbl3=newJLabel(“密码：");

Ibl4=ncwJLabcl();

txt_name=newJTextField(lO);

txt_pwd=newJPasswordField(lO);

btnl二newJButton("登录")

bu】2=ncwJBuiton("清空，')；

btn3=newJBunon("退出)

pl.add(lbll);

p2.add(lb12);

p2.add(txt_name);

p3.add(lbl3);

p3.add(txt_pwd);

p4.add(btn1);

p4.add(btn2);

p4.add(b(n3);

p5.add(lb14);

this.sctLayout(ncwGridLayout(5,l));

this.add(pl);

this.add(p2);

this.add(p3);

this.add(p4);

lhis.add(p5);

this.setBounds(400.300,400,300);

this.setDcfaultCloseOperation(EXIT_ON_CLOSE);

this.setVisible(true);

〃添加按钮登录事件

binI.addActionListener(

newActionListener(){

publicvoidactionPerformed(ActionEvente){

if((txt_name.gctTcxt().cquals("")==triie)&&(txt_pwd.gctTcxt().cquals("")==false))

lbl4.selTexi("登录失败，用户名不能为空)

if((lxl_iKinic.gclTcxl().cquals("")==fLtlse)&&(lxl_pwd.gclTcxl().cquals("")==lruc))

lbl4.setText("登录失败，密码不能为空")；

if((txt_name.getText().equals("")==true)&&(txt_pwd.getText().equals("")==true))

lbl4.setText("登录失败，用户名/密码不能为空”);

if(is_Property()){

newSys_intcrface().show();

I

else

if((txt_namc.gctTcxt().cquals("")==falsc)&&(txt_pwd.gctTcKt().cquals("")==falsc))

lbl4.seiTexi("登录失败,用户名/密码错误)

)

}

)；

bin1.addAclionListener(this);

〃清空用户名和密码

btn2.addActionListcncr(

newAc:ionListener(){

publicvoidactionPcrfornicd(ActionEvente){

txt_nanic.setTcxt(null);

lxt_pwd.setText(null);

lbl4.setText(null);

)

)

)；

〃退出

btn3.addActionListcner(

newActionListener(){

publicvoidactionPerformed(ActionEvente){

System.exit(O);

)

)

)；

)

protectedvoiduser_land(Objec(selVisible){

//TODOAuto-generatedmethodstub

publicbooleanis_Propcrty(){

try{

conn=DriverManager.getConnection(url.user,password);

//System.out.printin("连接成功")；

slat=conn.crealeStatement();

Stringsql=,,select*fromAdmin_InfoH;

rs=stat.cxccutcQucry(sql);

while(rs.next()){

//System.out.println(rs.getString("A_name")+"\t"+rs.geiString("A_pwd"));

Stringname=lxt_name.getText();

Stringpwd=txt_pwd.getText();

if(naine.cquals(rs.gctString("A_namc"))&&

pwd.equals(rs.getString("A_pwd"))){

//System.out.prinUn("登录成功!!");

returntrue;

}catch(SQI.Exceptione){

System.out.println("连接失败!!!”);

e.printStackTraceO;

)

〃关闭数据走

finally!

try{

if(rs!=null){

rs.close();

1

if(stat!=null){

stat.close();

)

if(conn!=null){

conn.close();

)

}catch(Exceptione2){

Sy-uuLpriulln("关闭失败)

e2.printStackTrace();

)

)

returnfalse;

publicstaticvoidmain(StringlJargs){

newuser_land();

publicvoidactionPerformed(ActionEvenle){

//Systeni.exit(O);

this.sctVisiblc(falsc);

)

)

〃/〃〃/〃〃〃〃〃〃/〃/〃〃/〃/〃〃/〃/〃〃/〃/〃〃〃/〃〃/〃〃/〃//〃//〃/〃〃/〃//〃,7〃〃〃//〃//〃〃〃〃〃//〃//〃〃〃/〃/〃//〃/，〃〃〃/

主界面

〃//〃〃/〃/〃〃/〃//〃/〃〃//〃/〃/〃〃0///〃/〃/〃〃/〃〃〃/〃〃/〃/〃〃/〃/〃〃/〃,7〃〃〃/〃〃/〃〃〃〃〃///〃//〃/〃〃〃〃//〃〃〃〃〃

packageperty;

importjava.awt.BorderLayout;

importjava.awt.Color;

importjava.awt.Dialog;

importjava.awt.FlowLayoul;

importjava.awt.Font;

iinpurljava.awl.event.AuliunEvcnl;

importjava.awt.event.ActionListener;

importjavax.swing.JFramc;

importjavax.svvingJLabcl;

importjavax.swing.JMenuBar;

importjavax.swing.JMenuI:em;

importjavax.swing.JMcnu;

importjavax.swingJPanel;

importjavax.swing.JTextArea;

importjavax.swing.JTextField;

publicclassSys_interfaceextendsJFramcimplementsActionListener{

JPanelp=null;

JMenuItemjmi_l,jmi_2jmi_3,jmi_4.jmi_5,jmi_6,jmi_7jmi_8jmi_9,jnii_10;

JMcnuBarjmb=null;

JMenujml=nulljm2=null,jm3=nulljm4=null;

JLabeltext;

publicSys_interface(){

Ihis.setTitle（"固定资产及设备管理系统）

tcxt=ncwJLabel（"欢迎进入固定资产及设备管理系统）

text.setFont（newFont（"宋体”,1,28））;

text.setForeground（Color.blue）;

p=newJPanel（）;

jmb-iicwJMunuBiirO;

jm_l=newJMenu（"系统功效）

jm_2=newJMemi（"资产管理）

jm_3:newJMenu（"系统查询）

jm_4=newJMenu（"帮助）

jmi_l=newJMenuIlem（"用户登录"）;

jmi_2=newJMenuIlem（"注销用户"）;

jmi_3=newJMenuItem（"用户添加"）；

jmi_4=newJMenuItem（"退出系统"）；

jmi_5=newJMenHiem（"资产借出管理）

jmi_6=newJMenuItemC'资产信息管理”）;

jmi_7=newJMcnuhcm（"资产信息查询”）；

jmi_8=ncwJMcnUtcm（"资产借出查询）

jmi_9=newJMenjhem（"资产归还杳询）

jmi」0=newJMenuItem（"相关"）;

jm_l.add（jmi_l）;

jm_l.add（jmi_2）;

jm_l.add（jmi_3）;

jm_l.add（jini_4）;

jm_2.add（jmi_5）;

jm_2.add（jmi_6）;

jm_3.add（jmi_7）;

jm_3.add(jmi_8);

jm_3.add(jmi_9);

jm_4.add(jini_10);

jmb.add(jni_l);

jmb.add(jm_2);

jnib.add(jiii_3);

jmb.add(jm_4);

add(text.BorderLayout.CENTER);

this.sctJMcnuBanjnib);

//this.setLayout(newBordcrLayoutO);

//(his.add(p,BorderLayout.NORTH);

jmi_laddActionI.istener(

newActionListcncr(){

publicvoidac(ionPerfbrmed(Ac(ionEven(e){

newuser_land().show();

}

)

)；

jmi_2.addActionListener(this);

jmi_2.addActionListener(newActionListcncr(){

©Override

publicvoidactionPerformed(ActionEventargO){

newuser_land().show();

})；

jmi_3.addActionListener(

newAu.iuiiLislcnci(){

publicvoidactionPerformed(ActionEvente){

newPass_word().show();

}

)

)；

jmi_4.addActionListener(

newAc:ionListener(){

publicvoidactionPcrformcd(ActionEvente){

System.exil(O);

I

}

)；

jmi_5.addActionListener(

newAc:ionListener(){

publicvoidactionPerformed(ActionEvente){

newloan_prop_manage().show<);

1

)

)；

jmi_6.addActionListener(

newAc:ionListcncr(){

publicvoidactionPerfbrmed(Ac(ionEvente){

newpropcrty_Info().show();

)

)

)；

jiiii_7.addAuliunLislcficr(

newAc:ionListener(){

publicvoidactionPerfbrmed(ActionEvente){

newprop_info_select().show();

1

)

)；

jmi_8.addActionListener(

newAc:ionListcncr(){

publicvoidac(ionPerfbrmed(AclionEvente){

newLoan_prop_select().show();

}

)

）；

jmi_9.addActionListener(

newAc:ionListener(){

publicvoidactionPerformed(ActionEvente){

newback_prop_select().show();

}

)

)；

jmi_10.addActionListener(

newAc:ionListener(){

publicvoidactionPcrfornicd(ActionEvente){

newabout().show();

)

)

)；

this.sctBounds(200,200,500,400);

this.setDefaultCloseOperation(EXIT_ON_CLOSE);

)

publicvoidactionPerformcd(ActionEvente){

//System.exit(O);

this.setVisible(false);

publicstaticvoidmain(String[]args){

newSys_interface().show();

)

)

〃/〃〃//〃/〃〃〃〃/〃/〃〃/〃/〃〃//〃/〃〃〃〃/〃//〃///〃/〃//〃//〃//〃〃〃〃〃〃////〃〃/〃//〃//〃//〃//〃//〃〃〃//〃/〃

资产借出管理

〃/〃〃/〃〃/〃/〃〃〃〃〃〃/〃/〃〃〃/〃〃//〃〃〃/〃〃/〃/〃〃/〃//〃//〃//〃/〃〃/〃,7〃//〃//〃〃〃〃〃〃〃〃〃//〃〃/〃/〃

packageperty;

importjava.awt.*;

importjava.awt.evcnt.ActionEvent;

importjava.awt.event.ActionLislener;

importjava.sql.*;

inipurtjava.util.Vculur.

importjavax.swing.*;

importjava.awt.event.FocusEvent;

importjava.awt.event.FocusListener;

importjava.awt.event.MouseEvent;

importjava.awt.event.MouseListener;

importjavax.swing.event.ListSelectionEvent;

importjavax.swing.event.ListSclcctionListcncr;

importjavax.swing.event.TableModelListener;

importjavax.swing.event.TableModelEvent;

importjavax.swing.table.DefanltTahleModel;

importjavax.swing.tahle.TablcModel;

publicclassloan_prop_manageextendsJFrameimpleirentsActionListener{

Vector<Vector>data=null;

DefaultTableModelmodel=null;

Connectionconn=null;

Statementstat=null;

ResultSetrsl=null;

JTableloan_prop=null;

JLabellabel;

JTextFieldtext;

JTextFieldtxtO1,txtO2,txtO3,txtO4,txtO5,txtO6;

JPanelpl=null,p2=nulLp3=null,p4,p5,p6.p7,p8,p9,p10;

Choicecl=null,c2=null;

JLabelIbl=nulljb2=null,lb3=null,lb4=null,lb5=null,lb6=null;

JButtonb(n_ok=null;

JBullon

JButtonbtn_fresh=null;

JButtonbtn_save=null;

JButtonbtn_del=null;

Vector<String>columnName=newVector();

publicloan_prop_manage(){

texl=newJTextField。；

columnName.add("资产编号");

columnName.add("资产名称”);

columnName.addC资产型号)

columnName.add("借出时间)

cchimnName.add("借出数量

columnName.add("借出人)

p1=newJPanel();

p2=newJPanel();

p3=newJPanel();

p4=nevvJPanel();

p5=newJPanel();

p6=newJPanel();

p7=ncwJPanclO;

p8=newJPanel();

p9=newJPanelO;

pl0=newJPanelO;

Ibl=newJLabel(“资产编号)

lb2=newJLabel(“资产名称)

lb3=newJLabel("资产型号”);

lb4=newJLabel("借出时间)

lb5=newJLabel("借出数量)

lb6=ncwJLabcl("借出人)

txt01=newJTextField(8);

txtO2=newJTextField(8);

txtO3=newJTextField(8);

txt04=ncwJTcxtFicld(8);

tx(05=newJTextField(8);

tx(06=newJTextField(8);

c1=newChoice();

c2=ncwChoice();

text=newJTex(Field(5);

cl.add(“资产编号)

c2.add("=")；

btn_ok=ncwJButton("确定)

btn_exit=newJBuiion("退出");

btn_fresh=newJBulton("刷新")；

btn_save=newJButton("保留")；

bin_del=nev\JBuiton("删除)

pl.add(newJLabel("查询字段"));

pl.add(cl);

pl.add(ncwJLabel("运算符"));

pl.add(c2);

pl.add(newJLabel("输入数据”))；

pl.add(text);

pl.add(btn_ok);

pl.add(btn_exit);

pl.setBorder(BorderFactory.crcateTitlcdBord，r("请操作"));

p3.add(lbl);

p3.add(txt01);

p4.add(lb2);

p4.add(txt02);

p5.add(lb3);

p5.add(txtO3);

p6.add(lb4);

p6.add(txt04);

p7.add(lb5);

p7.add(txtO5);

p8.add(lb6);

p8.add(txt06);

plO.add(btn_fresh);

p10.add(htn_save);

plO.add(btn_dcl);

p2.setLayout(newGridLayout(3,2));

p2.add(p3);

p2.add(p4);

p2.add(p5);

p2.add(p6);

p2.add(p7);

p2.add(p8);

loan_prop=newJTable(this.getDaie(),columnName);

model=newDefaultTableModel(getDate(),columnNanie);

p9.add(newJScrollPane(loan_prop));

this.setLayout(newGridLayout(4,I));

this.add(pl);

this.add(p9);

this.add(p2);

this.add(plO);

this.sclBouiids(400,300,500,400);

this.setDefaultCloseOperation(EXIT_ON_CLOSE);

ihis.setTitle("资产借出管理)

btn_save.addActionListener(newActionListener(){

publicvoidactionPerfbnncd(ActionEventargO){

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn=DrivcrManager.gctConncction("jdbc:sqiservcr://:1433;DatabaseName=_prop

erty"；'sa","");

stat=conn.createStatement();

Stringsq1="insertinfoloan_info

(prop_namc,prop_typc,loan_timc,loan_num)"+"valucs("'+tx[02.gctTcxt()+",,",+txt03.gctTcxt()+,"/

"+txtO4.ge(Texl()+',','"+txlO5.gecTexi()+"')"；

stat.executeUpdate(sql);

DefaultTableModelmod=new

DefaultTableModel(getDate(),columnName);

loan_prop.setModel(mod);

loan_prop.repaint();

loan_prop.updatcUI();

}catch(Exceptione){

System.out.println(e.getMessage());

lry{

if(rsl!=null){

rsl.close();

)

if(s(at!=null){

slal.closc();

)

if(conn!=null){

conn.closeO;

}

}catch(Exceptione2){

Sysiem.oul.prinUn("关闭失败")；

e2.printStackTrace();

)

)

})；

htn_ok.addActionI.istener(

newActionListcncr(){

publicvoidactionPerformed(ActionEvente){

DefaultTableModeldtb=new

DefaultTableModcl(selectE)ate(),cokimnName);

loan_prop.setModel(dtb);

loan_prop.repaint();

loan_prop.updateUI();

)

})；

/*btn_exit.a<ldActionListener(newActionListener(){

publicvoidactionPerfbimed(ActionEventargO){

});*/

btn_exit.addActionListener(this);

bln_fresh.addActionListener(newActionListener(){

publicvoidauliuiiPcrlbrincd(AclioiiEvcnlargO){

DefaultTableModelmod=new

DefaultTableModel(getDate(),columnName);

loan_prop.setModel(mod);

loan_prop.repaint();

loan_prop.upda(eUI();

)

))；

loan_prop.gctSelcctionModcl().addListSelcctionListcncr(

newListSelectionLis(ener(){

publicvoidvalueChanged(LislSelectionEvente){

htn_del.addAcfionI.istencr(newActionI.istener(){

publicvoidactionPcrfbnncd(ActionEvcntargO){

try{

intj=loan_prop.getSelectedRow();

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn=DriverManager.getConnection('jdbc:sqlserver://:1433;DatabaseName=_prop

stat=conn.createStatement();

Stringsqll="deletefromloan_infbwhere

piop_id="+""+data.get(j).get(0)+"";

stat.executeUpdate(sql1);

}catch(Exccptionee){

Systcm.out.printin(ec.gctMessage());

}finally!

try{

if(rsl!=null){

rsl.close();

)

if(stat!=null){

stat.close();

}

if(conn!=null){

conn.close();

)

I

catch(Exceptione2){

“*—!11.014下所。11("关闭失败")；

c2.printStackTracc();

)

1

DcfaultTableModelmod=new

DefaultTableModel(getDate(),columnName);

loan_prop.setModel(mod);

loan_prop.repaint();

loan_prop.updatcUl();

})；

});

loan_prop.getSelcctionModel().addListSclectionListcncr(

newListSclectionListcncr(){

publicvoidvalueChanged(LislSeleclionEvente){

inti=loan_prop.getSelectedRow();

lxl01.sclTcxl(dcita.gcl(i).^el(0).loSlriiig());

txt()2.setText((String)data,get(i).get(1));

txtO3.setText((String)data.get(i).get(2));

txt04.setText(data.get(i).get(3).toString());

txt05.setText(data.get(i).get(4).toString());

txt06.setText(da(a.get(i).get(5).toString());

}

})；

)

publicVectorselectDate(){

data=newVector<Vector>();

try(

Class.fbrName(',com.microsoft.sqlserver.jdbc.SQLServerDrivern);

conn=DiiverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_prop

erty",“sa","")；

stat=conn.createStatement();

intx=Inleger.parseInt(text.ge(Text().trim());

//System.out.println(x);

rsl二stal.executeQuery("select*fromloan_infbwhereprop_id="+x);

while(rsl.next()){

Vectoral=newVector();

al.add(rsl.getlnt("prop_id"));

al.add(rsI.getString("prop_name"));

al.add(rs1.getStiing("prop_typc"));

al.add(rs1.getDate("loan_time,'));

al.add(rs1.getlnt("loan_num"));

al.add(rs1,getString("u_name"));

dala.add(al);

1

}catch(Exceplione){

e.printStackTrace();

}finally!

try1

if(rsl!=null){

rsl.close();

)

if(slat!=null){

stat.close();

}

if(conn!=null){

conn.close();

}

}catch(Exceptione2){

System.out.priniln("关闭失败");

e2.prinlStackTrace();

I

}

returndata;

1

publicVectorgetDate(){

data=newVector<Vector>();

try(

Class.forNameC'com.microsoft.sqlserver.jdbc.SQLScrvcrDriver");

conn=DiiverManager.getConnec(ion("jdb€：sqlserver://:1433;DatabaseName=_prop

W”)；

stat=conn.createStatement();

rs1=stat.executeQuery(,,select*fromloanjnfo");

while(rsl.next()){

Vectoral=newVector();

al.add(rsl.getlnt("prop_id"));

al.add(rsI.getSlringCprop^ame1'));

al.add(rsl.getString("prop_type"));

al.add(rsLgctDate("loan_time"));

al.add(rsI.getlnt("loan_num"));

al.add(rs1.getString("u_name"));

dala.add(al);

)

}calch(Exceplione){

System.out.println(e.getMessage());

}finally!

try{

if(rsl!=null){

rsl.cIoseO;

}

if(stat!=null){

stat.closeO;

if(conn!=null){

conn.close();

}

}ca(ch(Exceplione2){

Syslem.oul.printin("关闭失败")；

c2.prinlSLaukTiacc();

)

)

returndata;

1

publicstaticvoidmain(S(ring[]args){

newloan_prop_manage().show();

)

publicvoidactionPerformed(ActionEvente){

//System.exit(O);

this.sctVisiblc(false);

)

}

〃〃/〃/〃〃/〃/〃〃/〃/〃〃/〃〃〃/〃〃/〃/〃〃/〃〃/〃/〃〃/〃/〃〃〃/〃〃//〃〃〃//〃//〃〃〃//〃//〃〃〃//〃〃〃〃〃〃〃/〃

资产借出查询

〃〃/〃/〃〃〃〃/〃/〃///〃/〃〃/〃//〃/〃〃/〃//〃/〃〃/〃〃〃/〃〃/〃/〃〃/〃〃/〃/"7〃〃〃〃〃〃〃〃〃〃〃〃/〃/〃〃/〃//〃

packageperty;

importjava.sql.*;

importjava.util.ArrayList;

importjavax.swing.JButton;

importjava.awt.event.*;

importjavax.swing.JTextFiekl;

importjava.util.Vector;

importjava.awt.BordcrLayout;

importjava.awt.Choice;

importjava.awt.FlowLayout;

importjavax.swing.BorderFactory;

importjavax.swing.JFrame;

importjavax.swing.JLabel;

importjavax.swing.JPanel;

importjavax.swing.JScrollPane;

importjavax.swing.JTable;

importjavax.swing.table.DefaultTableModel;

publicclassLoan_prop_selcctextendsJFrameimplementsActionListcncr{

Connectionconn=null:

Statementstat=null;

ResultSetrs=null;

JTabletable=null;

JLabcllabel;

JTextFieldtext;

JButlonbtn_ok=null.bin_exi(=null;

JPanelpl=nulLp2=null;

Vcctor<String>columnNamc=ncwVcctor();

publicLoan_prop_select(){

ihis.setTitle("资产借出查询”);

columnName.add("流水号)

columnName.add("资产编号)

columnName.addC'借用人)

columnName.add("借出数量)

columnName.add("借出时间");

pl=ncwJPancl();

p2=newJPanei();

iext=newJTextFieldO;

text=newJTextField(5);

btn_ok=newJBuuon("查询")；

btn_exit=newJBulton("退出")；

pl.add(ncwJLabcl(“资产编号”));

pl.add(text);

p1.add(btn_ok);

pl.add(btn_exit);

pl.sctBordcr(BorderFactory.creatcTitlcdBordcr("数据查询"));

btn_exit.addActionListener(this);

table=ncwJTable(this.gctDatc(),columnName);

this.setLayout(newBorderLayoutO);

this.add(p1,BorderLayout.NORTH);

this.add(ncwJScix)llPanc(tablc),BordcrLayout.CENTER);

this.setBounds(4C0.300,500,400);

this.setDefaultCloseOperation(EXIT_ON_CLOSE);

btn_ok.addActionListener(newActionListenerO{

@Override

publicvoidactionPerformed(ActionEventargO){

DefauItTableModeldtm=newDefaultTableModel(selectDate(),columnName);

table.seiModeUdtm);

table.repaint();

table.updaleUK);

)

))；

)

publicVectorsclcctDa:c(){

Vector<Veclor>dala=newVeclor<Vec(or>();

lry{

Class.fbrName(,'com.microsoft.sqlserver.jdbc.SQLServerDriver,');

conn=DriverManager.ge(Connection("jdbc:sqIserver://:1433;DatabaseName=_prop

erty"；'saH,"");

stat=conn.crcatcStatcmcnt();

intx=Integer.parseInl(text.getText().trim());

//System.outprintln(x);

rs=stat.exectteQuery("select*fromloan_infbwhereprop_id="+x);

while(rs.next()){

Vectoral=newVector();

al.add(rs.gctString("loan_id"));

al.add(rs.getStiing("prop_id"));

al.add(rs.getString("u_id"));

al.add(rs.gclSuiiig("luaii_iiiiiu"));

al.add(rs.getString("loan_time"));

data.add(al);

)

}catch(Exceptione){

Systern.out.println(e.getMessageO);

}finally{

〃关闭

try{

if(rs!=null){

rs.close();

}

if(stat!=null){

sca(.close();

)

if(conn!=null){

conn.close();

)

}catch(Exceptione2){

System.out.prinUn("关闭失败)

e2.printStackTrace();

retumdata;

publicVectorge(Date(){

Vec(or<Vector>data=newVector<Vector>();

uy{

Class.forNameC'com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn=DriverManager.getConnection("jdbc:sqlserver://:1433;DatabaseName=_prop

erty\"sa',,"M);

stat=conn.crea(eSta(ement();

rs=stal.execi：teQuery("select*fromloan_Info");

while(rs.next()){

Vectoral=ncwVector();

al.add(rs.getString("loan_id"));

al.add(rs.getString("prop_id"));

al.add(rs.gctString("loan_niim"));

al.add(rs.getString("loan_time"));

data.add(al);

}

}catch(Exceptione){

System.out.prin(ln(e.ge(Message());

}finally!

〃关闭

try{

if(rs!=null){

rs.close();

if(stat!=null){

stat.closeO;

)

if(conn!=null){

uunn.uloscO;

)

}ca(ch(Exceptione2){

System.out.println("关闭失败)

e2.printStackTrace();

}