Oracle課程設(shè)計(jì)報(bào)告-倉庫管理系統(tǒng)

1、Oracle實(shí)驗(yàn)題目：倉庫管理系統(tǒng)專業(yè)班級計(jì)算機(jī)應(yīng)用與技術(shù)1440302學(xué)號：20210030226姓名：胡 強(qiáng) 指導(dǎo)教師：王122一、系統(tǒng)描述倉庫管理系統(tǒng)的功能： 1）、產(chǎn)品入倉管理：在貨物送到倉庫時(shí)，關(guān)于貨物信息進(jìn)行了解并且相關(guān)信息輸入到數(shù)據(jù)庫中，同時(shí)更新數(shù)據(jù)庫。2、產(chǎn)品出倉管理：在貨物運(yùn)出倉庫時(shí)，進(jìn)行貨物信息統(tǒng)計(jì)并且將據(jù)保存到數(shù)據(jù)庫中，同時(shí)更新數(shù)據(jù)庫。 3）倉庫貨物信息提醒：當(dāng)貨物少于某一規(guī)則的值時(shí)，或者貨物保期將至?xí)r將發(fā)出提 醒 。 4）、借出管理：憑借條借出，然后能夠還庫。5、查詢修改：管理員可以進(jìn)行一系列查詢：查詢貨物類別及貨物的信息、數(shù)量和貨物流動(dòng)的規(guī)那么關(guān)于貨物出倉進(jìn)倉的要求；

2、可以關(guān)于以上查詢進(jìn)行修改可以查詢某一天貨物流動(dòng)的信息以及出倉及入倉的詳細(xì)信息。6、初始化庫存設(shè)置：設(shè)置庫存的初始化值，庫存的上下警戒限制。7、盤庫情況：反映沒有、年的庫存情況二、系統(tǒng)需求分析利用用例圖、類圖、E-R 圖關(guān)于系統(tǒng)進(jìn)行需求分析。圖及E-R倉庫管理系統(tǒng)用例圖類圖表 1：產(chǎn)品信息表 PRO字段名數(shù)據(jù)類型長度約束說明PROINUMBER11主碼產(chǎn)品編號PRONAMEVARCHAR220NOT NULL產(chǎn)品名稱PRORESSVARCHAR250產(chǎn)品地址REPHONENUMBER20產(chǎn)品地址號碼BATENUMBER5NOT NULL保質(zhì)天數(shù)EMOVARCHAR2100說明344表 2：產(chǎn)品信

3、息管理 PRO_MAN字段名數(shù)據(jù)類型長度約束說明PROINUMBER11主碼，外碼產(chǎn)品編號BIRATEATE主碼產(chǎn)品Th產(chǎn)日期ZNUMNUMBER20NOT NULL產(chǎn)品數(shù)量EMOVARCHAR2100說明3C_PRO字段名數(shù)據(jù)類型長度約束說明PROINUMBER11主碼，外碼產(chǎn)品編號CATEATE主碼出庫日期BIRATEATENOT NULLTh產(chǎn)日期ZNUMNUMBER10NOT NULL出庫數(shù)量EMOVARCHAR2100說明4R_PRO字段名數(shù)據(jù)類型長度約束說明PROINUMBER11主碼，外碼產(chǎn)品編號RATEATE主碼入庫日期BIRATEATENOT NULLTh產(chǎn)日期RNUMNUM

4、BER10NOT NULL入庫數(shù)量EMOVARCHAR2100說明表 5：產(chǎn)品倉庫限制規(guī)那么字段名數(shù)據(jù)類型長度約束說明PROINUMBER11主碼，外碼產(chǎn)品編號BIRATEATE主碼產(chǎn)品Th產(chǎn)日期ZNUMNUMBER20NOT NULL產(chǎn)品數(shù)量EMOVARCHAR2100說明表 6：管理員表 AMIN字段名數(shù)據(jù)類型長度約束說明INUMBER11主碼管理員編號USARNAME PASSORVARCHAR210VARCHAR211NOT NULL NOT NULL管理員賬號賬號密碼E-R三、數(shù)據(jù)庫關(guān)于象設(shè)計(jì)1、表設(shè)計(jì)62、序列設(shè)計(jì)5 PAGE PAGE 10為了方便倉庫產(chǎn)品管理在數(shù)據(jù)庫中用以下序列

5、產(chǎn)Th相編號C_R_VIEW：產(chǎn)Th產(chǎn)品編號，起始值100。3、視圖設(shè)計(jì)Th存信息及產(chǎn)品的總數(shù)量，創(chuàng)立以下視圖。1創(chuàng)立名為“C_R_PRO_VIEW的視圖，用于察看產(chǎn)品的出入庫匯總情況，包括出庫的產(chǎn)品編號，入庫的產(chǎn)品編號，產(chǎn)品名稱，庫日期，出庫日期，出庫產(chǎn)品的Th產(chǎn)日期，入庫產(chǎn)品的Th產(chǎn)日期，出庫數(shù)量，入庫數(shù)量。2創(chuàng)立名為“SNUM的視圖，用于查詢一種產(chǎn)品的總庫存量，囊括產(chǎn)品編號，產(chǎn)品總數(shù)量。創(chuàng)立名“ZNUM_PRO_VIEW的視圖用于查詢產(chǎn)品的庫存信息囊括不同Th產(chǎn)日期的庫存量4、PL/SQL 功能模塊設(shè)計(jì)利用PL/SQL程序創(chuàng)立以下各種數(shù)據(jù)庫關(guān)于象。1創(chuàng)立一個(gè)當(dāng)倉庫產(chǎn)品少于最少數(shù)量或者大于

6、最大數(shù)量時(shí)顯示出產(chǎn)品數(shù)量、Th產(chǎn)日期及保質(zhì)期的函數(shù)。2創(chuàng)立一個(gè)計(jì)算距保質(zhì)期時(shí)間的存儲進(jìn)程。四、數(shù)據(jù)庫關(guān)于象創(chuàng)立描述數(shù)據(jù)庫關(guān)于象中表的創(chuàng)立、序列的創(chuàng)立、視圖的創(chuàng)立、存儲進(jìn)程的創(chuàng)立，觸發(fā)器的創(chuàng)立等內(nèi)容，實(shí)現(xiàn)系統(tǒng)的根本功能。1、表的創(chuàng)立PRO:CREATETABLEUSERS.PRO( PROINUMBER(11)NOTNULLPRONAMEVARCHAR2(20)NOTNULLPRORESSVARCHAR2(50),REPHONENUMBER(20),BATENUMBER(5)NOTNULLEMOVARCHAR2(100),PRIMARYKEY(PROI)VALIATETABLESPACEUSER

7、SPRO_MANCREATETABLEUSERS.PRO_MANPROINUMBER(11)NOTNULL, BIRATEATENOTNULL, ZNUMNUMBER(20)NOTNULL, EMOVARCHAR2(100),PRIMARYKEY(PROI,BIRATE)VALIATE, FOREIGNKEY(PROI)REFERENCESSYS.PROROI)VALIATETABLESPACEUSERS3創(chuàng)立入庫管理表 R_PROCREATETABLEUSERS.R_PROPROINUMBER(11)NOTNULL, RATEATENOTNULL, BIRATEATENOTNULL, RNU

8、MNUMBER(10)NOTNULL, EMOVARCHAR2(100),PRIMARYKEY(PROI,RATE)VALIATE, FOREIGNKEY(PROI)REFERENCESSYS.PROI)VALIATE) TABLESPACE4出庫產(chǎn)品管理 C_PROCREATETABLEUSERS.C_PROPROINUMBER(11)NOTNULL, CATEATENOTNULL, BIRATEATENOTNULL, CNUMNUMBER(10)NOTNULL,EMOVARCHAR2(100),PRIMARYKEY(PROI,FOREIGNKEY(PROI)I)VALIATE) TABLE

9、SPACE5管理規(guī)那么 PRO_LIMCREATETABLEUSERS.PRO_LIMPROINUMBER(11)NOTNULL, MINUMNUMBER(10)NOTNULL, MAXUMNUMBER(10)NOTNULL, LBIRATENUMBER(5)NOTNULL, EMOVARCHAR2(100),PRIMARYKEY(PROI)VALIATEVALIATE, SYS.PRO PAGE PAGE 11FOREIGNKEY(PROI)REFERENCESSYS.PRO(PROI)VALIATE) TABLESPACEUSERS6管理員表 AMINCREATETABLEUSERS.AM

10、ININUMBER(11)NOTNULL,USERNAMEVARCHAR2(10)NOTNULL, PASSWORVARCHAR2(11)NOTNULLPRIMARYKEY(I)VALIATETABLESPACEUSERS2、序列的創(chuàng)立CREATESEQUENCEC_R_VIEWNOCYCLENOORERNOCACH NOMAXVALUEMINVALUE100INCREMENTBY1START1003、視圖的創(chuàng)立1產(chǎn)品的出入庫情況CREATEORREPLACEVIEWC_R_PRO_VIEWASSELECT CPROI,RPROI,PRONAME,RATE,CATE,CBIRATE,RBIRA

11、TE,CNUM,RNUMFROM(SELECTASASASASRBIRATE,CNUM,RNUMFROM C_PRO FULL JOIN R_PRO ON an CATE=RAT E ORER BY RPROI) R_C WHERE PRO.PROI=CPROI AN P RO.PROI=RPROI2產(chǎn)品總數(shù)量:SNUMCREATEORREPLACEVIEWASSELECTPRO.PROI,SUM(ZNUM)SNUMFROMPRO,PRO_MANREGROUPBY3產(chǎn)品的庫存信息:ZNUM_PRO_VIEW CREATEORREPLACEVIEWASSELECTPRO_MAN.PROI,PRO

12、NAME,BIRATE,BATE,ZNUMFROMPRO1,PRO_MANWHER4、PL/SQL 程序設(shè)計(jì)1倉庫產(chǎn)品少于最少數(shù)量或者大于最大數(shù)量時(shí)顯示出產(chǎn)品數(shù)量、Th產(chǎn)日期保質(zhì)期來：CREATEORREPLACEFUNCTIONMIN_MAX_NUM_SHOW(V_PROINUMBER,V_BIRATEOUTATE,V_BATEOUTNUMBER)RETURNASV_SNUMNUMBER;V_MINUMNUMBER;V_MAXUMBEGINSELECTSUM(ZNUM)INTOV_SNUMFROMPRO_MANPROI=V_PROI;SELECTMINUM,MAXUMINTOV_MINUM,

13、V_MAXUMFROMMWHEREPROI=V_PROI;SELECTBIRATEINTOV_BIRATEFROMPRO_MANWHERE12PROI=V_PROI;SELECTBATEINTOV_BATEFROMPROWHEREPROI;IFV_SNUM-V_MINUM=0RETURNV_SNUM;ENEN;2計(jì)算距保質(zhì)期時(shí)間:CREATEORREPLACEPROCEUREV_PROINUMBER)ASV_AYSNUMBER; V_LBIRATE13CURSORC_BIRATEISSELECTBIRATEFROMPRO_MANWHEREBEGINSELECTLBIRATEINTOV_LBIR

14、ATEFROMPRO_LIMWHEREPROI=V_PROI;FORV_BIRATEINC_BIRATELOOPIFIRATETHENBMS_OUTPUT.PUTLINE(V_AYS); ENIF;ENEN；14(4)計(jì)算入庫后數(shù)量：CREATEORREPLACEFUNCTIONA_R_NUM(V_PROINUMBER,V_BIRATEOUTATE)RETURNNUMBRASV_RZNUMBEGINSELECTBIRATEINTOV_BIRATEFROMR_PROWHEREROI=V_PROI;SELECTZNUM+RNUMINTOV_RZNUMFROM(SELECTPRO_MAN.PROI,

15、RBIRATE,RNUM,ZNUMFROMR_PRO,PRO_MANWHEREANPRO_MAN.BIRATE=R_PRO.BIRATE)A_RWHEREPROI=V_PROIANA_R.RBIRATE=V_BIRATE;RETURNEN;15Javaimportjava.awt.BorerLayout; import java.awt.EventQueue;importjavax.swing.JFrame; importjavax.swing.anel;importjavax.swing.borer.EmptyBorer; import javax.swing.JButton;public

16、class jiemian2 extens JFrame 16 PAGE PAGE 19private anel contentPane;public anel getContentPane()return contentPane;/* Launch the application.*/public static voi main(String args) EventQueue.invokeLater(new Runnable()public voi run() try jiemian2 frame = newjiemian2(); frame.setVisible(true); catch

17、(Exception e)e.printStackTrace(););/* Create the frame.*/public jiemian2() setefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBouns(100, 100, 450, 300);contentPane = new anel(); contentPane.setBorer(new EmptyBorer(5, 5,5);setContentPane(contentPane); contentPane.setLayout(null);package 倉庫管理;importjav

18、a.awt.BorerLayout; import java.awt.CarLayout; import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JMenuItem; importjavax.swing.JOptionPane; import javax.swing.anel;importjavax.swing.borer.EmptyBorer; import javax.swing.JTextFiel;import javax.swing.JLabel;import java.awt.Font;impo

19、rt java.awt.event.ActionEvent; importjava.awt.event.ActionListener;import javax.swing.JButton;publicclassjiemian1extensActionListenerprivate aneljiemianjm;CarLayoutanel ; jiemian2 jm2; anel2;implements PAGE PAGE 21private static oublepublic anel getContentPane() return contentPane;public voi setCont

20、entPane(anel contentPane)this.contentPane = contentPane;private JTextFielprivate JLabel label_1; private JLabel label_2; private JTextFielprivate JTextFielprivate JButton jb1; private JButton jb2;/*Launch theapplication.*/*Create theframe.*/public jiemian1() =jiemian.get(); cl=jiemian.getCl();setefa

21、ultCloseOperation(JFrame.EXIT_ON_CLOSE); setBouns(100, 100, 450, 300);contentPane = new anel(); contentPane.setBorer(new EmptyBorer(5, 5,5);setContentPane(contentPane); contentPane.setLayout(null);text1 = new JTextFiel(); text1.setBouns(193, 22, 192,contentPane.a(text1); text1.setColumns(10);JLabell

22、abel=JLabel(u5E93u5B58u521u59CBu5316u503CuFF1A22);16);label.setFont(new Font( 微軟雅黑, Font.PLAIN,label.setBouns(46, 21, 113,contentPane.a(label);label_1=JLabel(u4E0Au8B66u6212u7EBFuFF1A);label_1.setFont(newFont(Font.PLAIN, 16);label_1.setBouns(79, 70, 80,contentPane.a(label_1);label_2=JLabel(u4E0Bu8B6

23、6u6212u7EBFuFF1A);label_2.setFont(newFont(Font.PLAIN, 16);label_2.setBouns(79, 125, 80,contentPane.a(label_2);text2 = newtext2.setColumns(10); PAGE PAGE 29text2.setBouns(193, 75, 192,contentPane.a(text2);text3 = new JTextFiel(); text3.setColumns(10); text3.setBouns(193, 130, 192,contentPane.a(text3)

24、;16);16);jb1 = new JButton(u786Eu5B9A); jb1.setFont(new Font( 華文琥珀, Font.PLAIN,jb1.setBouns(76, 194, 122,contentPane.a(jb1);jb2 = new JButton(u8F4u56E); jb2.setFont(new Font( 華文琥珀, Font.PLAIN,jb2.setBouns(262, 194, 122,contentPane.a(jb2); jb1.aActionListener(this); jb2.aActionListener(this); jm2=new

25、 jiemian2();2=jm2.getContentPane(); .a(2,two);Overriepublic voi actionPerforme(ActionEvent e) / TOO Auto-generate methoif(e.getSource()=jb1)int i=0; trychushi=new ouble(text1.getText().toString();up=new ouble(text2.getText().toString(); own=newouble(text3.getText().toString(); jm.m1_mi1.setEnable(tr

26、ue); jm.m1_mi2.setEnable(true); jm.m2_mi1.setEnable(true); jm.m2_mi2.setEnable(true);jm.m2_mi3.setEnable(true); jm.m3_mi1.setEnable(true); jm.m3_mi2.setEnable(true);JOptionPane.showMessageialog(null,成功！);catch(Exception e1)JOptionPane.showMessageialog(null,不能為空！);i=1;if(i!=1) cl.show(,if(e.getSource

27、()=jb2)cl.show(,main);package 倉庫管理;importjava.awt.BorerLayout; import java.awt.CarLayout; import java.awt.EventQueue;import javax.swing.JFrame; import javax.swing.JMenuItem; importjavax.swing.JOptionPane; import javax.swing.anel;importjavax.swing.borer.EmptyBorer; import javax.swing.JTextFiel;import

28、 javax.swing.JLabel;import java.awt.Font;import java.awt.event.ActionEvent; importjava.awt.event.ActionListener;import javax.swing.JButton;publicclassjiemian1extensActionListenerimplementsprivate aneljiemianjm;CarLayoutanel ; jiemian2 jm2; anel2;private static oublepublic anel getContentPane() retur

29、n contentPane;public voi setContentPane(anel contentPane)this.contentPane = contentPane;private JTextFielprivate JLabel label_1; private JLabel label_2; private JTextFielprivate JTextFielprivate JButton jb1; private JButton jb2;/*Launch theapplication.*/*Create theframe.*/public jiemian1() =jiemian.

30、get(); cl=jiemian.getCl();setefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBouns(100, 100, 450, 300);contentPane = new anel(); contentPane.setBorer(new EmptyBorer(5, 5,5);setContentPane(contentPane); contentPane.setLayout(null);text1 = new JTextFiel();text1.setBouns(193, 22, 192,contentPane.a(text1

31、); text1.setColumns(10);JLabellabel=JLabel(u5E93u5B58u521u59CBu5316u503CuFF1A);16);label.setFont(new Font( 微軟雅黑, Font.PLAIN,label.setBouns(46, 21, 113,contentPane.a(label);label_1=JLabel(u4E0Au8B66u6212u7EBFuFF1A);label_1.setFont(newFont(Font.PLAIN, 16);label_1.setBouns(79, 70, 80,contentPane.a(labe

32、l_1);label_2=JLabel(u4E0Bu8B66u6212u7EBFuFF1A);label_2.setFont(newFont(Font.PLAIN, PAGE PAGE 3216);16);label_2.setBouns(79, 125, 80,contentPane.a(label_2);text2 = new JTextFiel(); text2.setColumns(10); text2.setBouns(193, 75, 192,contentPane.a(text2);text3 = new JTextFiel(); text3.setColumns(10); te

33、xt3.setBouns(193, 130, 192,contentPane.a(text3);jb1 = new JButton(u786Eu5B9A); jb1.setFont(new Font( 華文琥珀, Font.PLAIN,jb1.setBouns(76, 194, 122,contentPane.a(jb1);jb2 = new JButton(u8F4u56E); jb2.setFont(new Font( 華文琥珀, Font.PLAIN,16);jb2.setBouns(262, 194, 122,contentPane.a(jb2); jb1.aActionListene

34、r(this); jb2.aActionListener(this); jm2=new jiemian2(); 2=jm2.getContentPane(); .a(2,two);Overriepublic voi actionPerforme(ActionEvent e) / TOO Auto-generate methoif(e.getSource()=jb1)int i=0; trychushi=new ouble(text1.getText().toString();up=new ouble(text2.getText().toString(); own=newouble(text3.

35、getText().toString(); jm.m1_mi1.setEnable(true); jm.m1_mi2.setEnable(true); jm.m2_mi1.setEnable(true); jm.m2_mi2.setEnable(true); jm.m2_mi3.setEnable(true); jm.m3_mi1.setEnable(true); jm.m3_mi2.setEnable(true);JOptionPane.showMessageialog(null,成功！);catch(Exception e1)JOptionPane.showMessageialog(nul

36、l,不能為空！);i=1;if(i!=1) cl.show(,if(e.getSource()=jb2)33cl.show(, main);package 倉庫管理;importjava.awt.BorerLayout; import java.awt.CarLayout; import java.awt.EventQueue;import javax.swing.JFrame; importjavax.swing.JOptionPane; importjavax.swing.anel;importjavax.swing.borer.EmptyBorer; importjavax.swing.

37、JLabel;import java.awt.Font;importjavax.swing.JTextFiel; import javax.swing.JButton; PAGE PAGE 39importjava.awt.event.ActionListener; import java.awt.event.ActionEvent;publicclassjiemian3extensJFrameActionListenerprivate anel contentPane; private JTextFiel textFiel; private JTextFielprivate JTextFie

38、lprivate JTextFieljiemian jm;CarLayout cl; anel ;private JButton jb1,jb2;/*Launch theapplication.*/*Create theframe.*/public jiemian3() setefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBouns(100, 100, 450, 300);contentPane = new anel(); contentPane.setBorer(new EmptyBorer(5, 5,5);setContentPane(con

39、tentPane); contentPane.setLayout(null);JLabellabel=JLabel(u5165u5E93u4EA7u54C1u540u79F0uFF1A);label.setFont(new Font(Font.BOL, label.setBouns(38, 19, 127, 28); contentPane.a(label);JLabellabel_1=JLabel(u5165u5E93u4EA7u54C1u6570u91CFuFF1A);label_1.setFont(newFont( 黑體,Font.BOL,15);label_1.setBouns(38,

40、 57, 127,contentPane.a(label_1);JLabellabel_2=JLabel(u5165u5E93u4EA7u54C1u7F16u53F7uFF1A);15);label_2.setFont(newFont( 黑體,Font.BOL,label_2.setBouns(38, 95, 114,contentPane.a(label_2);JLabellabel_3=JLabel(u5165u5E93u4EA7u54C1u4EF7u683CuFF1A);15);label_3.setFont(newFont( 黑體,Font.BOL,label_3.setBouns(3

41、8, 133, 114,contentPane.a(label_3);textFiel = new JTextFiel(); textFiel.setFont(new Font(Font.BOL,15);15);15);15);textFiel.setBouns(196, 22, 162,contentPane.a(textFiel); textFiel.setColumns(10);textFiel_1 = new JTextFiel(); textFiel_1.setFont(newFont(Font.BOL,textFiel_1.setColumns(10); textFiel_1.se

42、tBouns(196, 60, 162,contentPane.a(textFiel_1);textFiel_2 = new JTextFiel(); textFiel_2.setFont(newFont(Font.BOL,textFiel_2.setColumns(10); textFiel_2.setBouns(196, 98, 162,contentPane.a(textFiel_2);textFiel_3 = new JTextFiel(); textFiel_3.setFont(newFont(Font.BOL,textFiel_3.setColumns(10); textFiel_

43、3.setBouns(196, 136, 162,contentPane.a(textFiel_3);jb1 = new JButton(u5165u5E93); jb1.aActionListener(new ActionListener()public voi actionPerforme(ActionEvent e);jb1.setFont(newFont(Font.BOL,jb1.setBouns(72, 179, 111, 34); contentPane.a(jb1);jb2 = new JButton(u8F4u56E); jb2.setFont(newFont(Font.BOL

44、,jb2.setBouns(247, 179, 111, 34); contentPane.a(jb2);cl=jm.getCl(); =jm.get(); .a(contentPane,three); jb1.aActionListener(this); jb2.aActionListener(this);Overriepublic voi actionPerforme(ActionEvent e) / TOO Auto-generate methoif(e.getSource()=jb1)JOptionPane.showMessageialog(null,入庫成if(e.getSource

45、()=jb2)cl.show(,two);package 倉庫管理;importjava.awt.BorerLayout; import java.awt.CarLayout; import java.awt.EventQueue;import javax.swing.JFrame; PAGE PAGE 43importjavax.swing.JOptionPane; importjavax.swing.anel;importjavax.swing.borer.EmptyBorer; importjavax.swing.JLabel;import java.awt.Font;import ja

46、va.awt.event.ActionEvent; importjava.awt.event.ActionListener;importjavax.swing.JTextFiel; import javax.swing.JButton;publicclassjiemian4extensActionListenerprivate anel contentPane; private JTextFiel textFiel; private JTextFielprivate JTextFieljiemian jm;CarLayout cl; anel ;implementsJButton jb1,jb

47、2;/*/*Launch theapplication.*/*Create theframe.*/public jiemian4() setefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBouns(100, 100, 450, 300);contentPane = new anel(); contentPane.setBorer(new EmptyBorer(5, 5,5);setContentPane(contentPane); contentPane.setLayout(null);JLabellabel=JLabel(u51FAu5E93u4EA7u54C1u540u79F0uFF1A);15);label.setFont(new Font(Font.BOL, label.setBouns(36, 35, 112, 28); contentPane.a(label);textFiel = new JTextFiel(); textFiel.setFont(new Font(Font.BOL,textFiel.setColumns(10); te