- P(gun)]
Java̎ԇԇ}
ճWֻҪпҪ͕ԇ}ԇ}Ըõ،ߵ֪RMпy֪ʲôӵԇ}Ǻԇ}СJava̎ԇԇ}Hϣ܉
Java̎ԇԇ} 1
1.HibernateԭʲôҪ?
ԭ 1.xȡļ 2.xȡӳϢ(chung)SessionFactory 3._Session 4.(chung)Transation 5.־û 6.ύ 7.P(gun)]Session 8.P(gun)]SesstionFactory
ʲôҪã 1. JDBCL(sh)(j)Ĵa˷b˔(sh)(j)Lӷ؏Դa 2. HibernateһJDBC־ûһ(yu)ORMF(xin)̶ܴȵĺDAOӵľa 3. hibernateʹJavaCֹ(ji)a팍F(xin) 4. hibernateܷdzãǂpӳ`Ժܳɫָ֧NP(gun)ϵ(sh)(j)һһĸNsP(gun)ϵ
2.Hibernatetd?
1. Hibernate2tdF(xin)a)w b)(Collection)
2. Hibernate3 ṩˌԵtd Hibernateڲԃ(sh)(j)ĕr(sh)(j)]дc(ni)(sh)(j)IJrŴc(ni)͌F(xin)td(ji)ʡ˷ă(ni)_NĶ˷ܡ
3.HibernateӌF(xin)֮g'P(gun)ϵ?(磺һP(gun)ϵ)
c֮gP(gun)ϵҪwF(xin)ڱc֮gP(gun)ϵMвnjMв҂аеıcӳһͨ^ļеmany-to-oneone-to-manymany-to-many
4.Struts1̣
1͑˞g[l(f)HTTPՈ2(j)web.xmlԓՈActionServletա3(j)struts-config.xml ActionServletȌՈеą(sh)䵽ActionFormȻActionServletٌՈl(f)͵Action M̎4ǷCҪCt{(dio)ActionFormvalidateCʧtD(zhun)inputɹt^m(x)5ActionActionForm@Ô(sh)(j){(dio)javabean еĘI(y)շ̎픵(sh)(j)6ActionActionForwardD(zhun)JSPAction7HTTP푑͑˞g[
MVCOӋģʽmodalģ͡ ҲQI(y)߉΄յĴa,ஔcJavaBeanviewҕD䌍@ʾஔJSPcontrollerģͺҕDĽ^ஔservletstruts1ǻMVCOӋģʽhibernateǻORMP(gun)ϵӳ
5.strutsʲô?
struts1ǻJSPservletһ_ԴWebÿʹõMVCOӋģʽstruts2ǻwebworkg(sh)Ŀܣsunwebwork˾(lin)_l(f)һܷdzRȫĿstruts2struts1]κP(gun)ϵһȫµĿ
6.springʲô?
springһSܵĴsZļg(sh)IOC(ƷD(zhun)ҲQهע)AOP(澎)
7.hibernateʲô?
hibernateǻORMP(gun)ϵӳ(Ɍ(sh)(j)P(gun)ϵ(sh)(j)ӳęC)F(xin),(sh)(j)־ûĹ
8.JSFʲô?
JavaServer FaceǻڽMweb_l(f)sturtsĿ
9.(sh)(j)ͼsʲô?
Ǟߔ(sh)(j)ęzٶȣǽڔ(sh)(j)(j)һֶνļsǞ˱֔(sh)(j)sзǿռsIsIsȵ
10.springʲô
@}ͨ^҂?yu)ʲôҪʹspring@}룺AOP _l(f)ˆTԄ(chung)ОԵP(gun)עcQMP(gun)עc뵽óaʹ AOP ( ־־յ)ͿԷֽɷ沢õ?q)ϣͬr?q)Čģ͵ďs IOC S(chung)һԘ(gu)쌦đíh(hun)Ȼ@Щfąf(xi)~ IOC ^ JNDI]ʹһѳSնλԪ(singleton)ֱӘ(gu)(straight construction)ÿһf(xi)(gu)ġf(xi)(collaborator) SpringʹһAOPҲһIOC Spring õĵطQ SpringֻҪ JavaBean Ժļه(f(xi))ȻԺҪrQƽӿڵąf(xi)
11.ԼԒҪUstruts2Ĉ(zh)
Struts 2ܱ¿Է֞3֣ĿFilterDispatcherI(y)տActionÑF(xin)I(y)I(y)߉MĿFilterDispatcherStruts 2ܵĻA˿܃(ni)Ŀ̺̎CI(y)տAction͘I(y)߉MҪÑԼF(xin)ġÑ_l(f)Action͘I(y)߉Mͬr߀ҪP(gun)ļĿFilterDispatcherʹ
Struts 2ĹStruts 1ҪΣcWebWorkܻͬfStruts 2WebWork汾Ҫ£1͑˞g[l(f)HTTPՈ2(j)web.xmlԓՈFilterDispatcher3(j)struts.xmlãҵҪ{(dio)õActionͷ ͨ^IoCʽֵעoAciton4Action{(dio)ØI(y)߉M̎I(y)߉@һC5Action(zh)ꮅ(j)struts.xmlеҵķؽY(ji)resultD(zhun)6HTTP푑͑˞g[
Java̎ԇԇ} 2
һ.x}(30)
1.ЩrԽKֹǰ̵\?
a. һr
b. ԓ{(dio)sleep()r
c. (chung)һ¾̕r(cǰM̟oP(gun))
d. һ(yu)ȼߵľM;wB(ti)r
2. Щ阋(gu)캯(sh)Զx
a. (gu)캯(sh)rQԓcͬ
b. dԽͬQ
c. ʹrԄӈ(zh)И(gu)캯(sh)ژ(gu)캯
(sh)(ni)O׃ijֵMЃ(ni)
d. ϶
3. P(gun)ڮ̎CƵĔЩ_
a. catchֲrrŕ(zh)finally(oՓǷë(zh))
b. try^(q)εijl(f)rŕ(zh)catch^(q)εij
c. ՓǷl(f)e`r(zh)finally
d. ϶
4. P(gun)ڽӿڵĔЩ_
a. ӿеĔ(sh)(j)Oֵ(ǽӿеij)
b. ӿеķdz
c. ӿڿ
d. ϶_
5.JavaZ،(Overriding)d(Overloading)ǶB(ti)ԵIJͬF(xin)߅Щfnj?
A. ،Ǹc֮gB(ti)ԵһNF(xin)
B. ،һжB(ti)ԵһNF(xin)
C. dһжB(ti)ԵһNF(xin)
D. dǸc֮gB(ti)ԵһNF(xin)
6.StrutsõҕDаЩM?
A. JSP
B. Servlet
C. ActionServlet
D. Action
E. I(y)߉I(y)Ք(sh)(j)JavaBean
F. EJB
G. ͑˺
7. strutsP(gun)FormBeanЩf_ģ
A FormBeanһN(sh)(j)beanҪÁbύρĔ(sh)(j)@Щ(sh)(j)foAction
B FormBeanпԌςfą(sh)Mһ¸ʽϵC@NCһN͑˵C
C Ñÿύa(chn)һµFormBean
D ӑB(ti)FormBeanMC
8ЩMservlet{(dio)ԇ?()
AʹôӡZ ӋC\з
BʹApache Log4J
CʹIDEɵ{(dio)ԇ
DֱӲ鿴HTMLԴa ????
Ee`o͑
9P(gun)servletĹf_Щ?()
Axȡ͑l(f)́@ʽ(sh)(j)
Bxȡ͑l(f)́[ʽ(sh)(j)
CĽY(ji)
Dl(f)@ʽĔ(sh)(j)o͑
El(f)[ʽĔ(sh)(j)o͑
10P(gun)session÷Щe`?(
AHttpSession session = new HttpSession()
request.getSession()
BString haha =(String) session.getParameter(Attribute)(haha)
Csession.removeAttribute(haha)
Dsession. setAttribute(hahaֵ)
11P(gun)f_Щ?()
AURLݔՈr뵽JSP
BܺӰJSP(ni)
Cļ׃ʹ
DļĺҪքӵظʹ(ҪքӸ)
12P(gun)bean`f_Щ?()
A߂һㅢ(sh)()Ę(gu)캯(sh)(DZ횵)
Bԓй_Č׃(ֶ)
CеČԶͨ^getXxxsetXxxL
D͵ČʹisXxxgetXxx
13P(gun)MVCfe`Щ?()
AʹÏsĿ
BʹÃ(ni)RequestDispatcher܉ܺõ،F(xin)MVC
CһMl(f)׃ĕrMVCӰϵy(tng)OӋ
D҂MVC̎Ո
14Ę˺ЩJSTL˺?()
15strutse`Щf_?
A StrutsПoς
B StrutsܻMVCģʽ
C Struts̏sY(ji)(gu)Ȇ}()
D StrutsЧؽĿļ(sh)Ŀ
}( 5)
1{(dio)ú(sh)MOD(12310)ֵ___
2select round (123.671) from dual@Zݔֵ______
3(chung)һRr׃ʹõַ_____
4v_comm = 2800 X := NVL (V_comm0) tXֵ____
5{(dio)ú(sh)INSTR(Here you areer)ֵ___
Д}(10)
1WHEREӾӛ䛣ҲָƷֽMY(ji)ėl ()
2UNIQUEsвֵܰ ()
3DATE͔(sh)(j)аrgֵ ()
4Isпֵ ()
5͞4)ݔ롰hellotֻܴ惦hell ()
6Group byӾIJԃY(ji)ź ()
7xΘ˕rеselectZ䲻ʹorder byӾ䡣(Ӳԃ
) ()
9|l(f)һl(f) ^̿зֵ ()
10instead
of|l(f)ֻǻҕD
ġSQLZ(̖(ni))(10)
1ԃ¸(JOB)ĆT˔(sh)
2ԃcTSMITHͬһT(DEPTNO)ĆT(ENAME)Y(SAL)ͲT
3ԃІT(ENAME)Y(SAL)Yȼ(GRADE)
4ԃ@ùY(SAL)ߵ3TϢ
5ԃІT(ENAME)(ENAME)
}(15)
1. PL/SQLMÑԶx̎3E
ʲô?
2. ?q)Щ?ҪB
3. ListMapSetӿȡԪؕrʲôc?
List ضԪ؏ԪSet o؏Ԫ(ni)Map key-valueֵvalueɶֵ
4 .struts1.0struts2.0ą^(q)e?οƃɷNеĆģʽ?
5. һstruts1.0F(xin)HԃɇZ(Ӣ)
6.strutsôform-beanaction
7. HibernateԎķ퓙Cʲô?ʹHibernateԎķtʲôʽ?
8. hibernateһļصʲô?
9.ʲôӵĔ(sh)(j)mϴŵڶ?
10һspringʲô?
11ĿwF(xin)Springе澎wf
12 |l(f)|l(f)Ĕ(sh)(j)Щ?
13 ҕDĺxԼʹҕDĺ̎
14 ORACLE5Ns
15 ORACLE^̺ͺ(sh)Įͬc
}(30)
1(chung)һPL/SQLK(j)Ñݔľ̖empвԃԓ̖ĆTT̖ܾ̖ҪЮ̎
2(chung)һPL/SQLK(j)ÑݔĹemplݔ@һÿλTľ̖ܹڣÿlϢʽ£(ΘˌF(xin))
̖ ܹ
7751 JOHN 95-12-31
3һ(sh)ДEMPijһ(JOB)ǷEMPڴ˹QtTRUEtFALSE
4һ|l(f)EMP(zh)вǰl(f)|l(f)TĹY(SAL)^5000MЈeܲ
^5000IJŌT̖r(SYSDATE)UP_EMP
(ע˱ѽãY(ji)(gu)UP_EMP(EMPNO NUMBER(4)SAL NUMBER(72)UDETE DATE))
5ݔY(ji)Ƕ?
importjava.util.Date
public class Test extends Date{
public static void main(String[] args) {
new Test().test()}
public void test(){
System.out.println(super.getClass().getName())}}
6ijaݔĽY(ji)Ƕ? public class smallT
{}
public static void main(String args[]) { } public int get() { } try { } finally { } return 2 return 1 smallT t = new smallT() int b = t.get() System.out.println(b)
7Ӿѭh(hun)10ѭh(hun)100ֻصӾѭh(hun)10ٻصѭh(hun)100ѭh(hun)50Ո
8ȥһVector؏͵Ԫ
9һַаַӢַ͔(sh)ַՈy(tng)ӋʹӡַĂ(sh)
10. xxx˾sqlԇ
Table EMPLOYEES Structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Salary number(82)
HiredDate DATE
Departmentid number(2)
Table Departments Structure:
Departmentid number(2) Primary Key
DepartmentName VARCHAR2(25).
(1)EMPLOYEES팑ԃڽ߹Y[10002000]֮g߆T(last_name)ԡObama^ІTг@ЩTȫϢ
(2) EMPLOYEES팑ԃTƽY1800
ԪIJTІTг@ЩTȫϢ()
(3) EMPLOYEES팑ԃ˹YڲTƽYĆTг@ЩTȫϢԓTY߳TƽYٷֱ
1𰸣ABD
2𰸣 D
3𰸣BC
4𰸣AB
5AC
6𰸣AG
7𰸣A
8A B C D E
9A B C D E
10A B D
11A B C
12B D
13A C
14A B C
15A B C
16𰸣C
3 123.7 & 2800 2
Д
̡̡̡̡̡
ČSQLZ
1Select jobcount(*) from emp group by job
2Select enamesaldeptno from emp where deptno=(select deptno from emp where ename=SMITH)
3Select enamesalgrade from empsalgrade where sal between losal and hisal
4Select * from (select * from emp order by sal desc) where rownum<=3
5Select e1.ename empnamee2.ename mgrname from emp e1emp e2 where e1.mgr=e2.empno
庆
ͨ^Ͱl(f)ث@Զx
һ֞Զx
ڈ(zh)вʹ RAISE Z@ʽذl(f)
Į̎Į
2(1).
Ǻһ}cǰĿ˟oP(gun)Щ棬ԱֵעcǰĿP(gun)ķ˽ȫ}ֻxеһròּ(ji)ɂһ^̳ǔ(sh)(j)
(2).^У
^һN(lin)Y(ji)ČӴģSĄãṩһN_ԵķһԏĬF(xin)е@^̷Q^^ԭʼ Qԭʼ()ԭʼQĻ()ԏĻ^з͌׃Ļµķʹ֮mҪ
(3).b
bǰ^̺͔(sh)(j)(sh)(j)Lֻͨ^ѶxĽ?q)Ӌʼ@F(xin)ԱLһϵȫbČ@Щͨ^һܱoĽӿL
(4). B(ti)ԣ
B(ti)ָSͬČͬһϢ푑B(ti)(sh)B(ti)ԺͰB(ti)B(ti)ZԾ`О鹲aă(yu)ݣܺõĽQˑó(sh)ͬ}
List ضԪ؏ԪءSet o؏Ԫ(ni)Map key-valueֵvalueɶֵ
3List ضԪ؏ԪSet o؏Ԫ(ni)Map key-valueֵvalueɶֵ
4aAction
struts1.2ҪAction^һstruts2.0 ActionҪ^ActionSupport bģʽ
struts1.2 ActiondžģʽIJұǾ̰ȫHһActionČ̎еՈ
Struts1.2 Action_l(f)reСġActionYԴǾ̰ȫĻͬ
struts2.0 ActionÿһՈa(chn)һ˛]о̰ȫ}
cServletه
struts1.2 ActionهServlet API鮔һAction{(dio)ÕrHttpServletRequestHttpServletResponsefoexecut
struts2.0 ActionهSActionÓxΪyԇҪStruts2 Action
ȻLʼRequestResponse
ԪpٻֱLHttpServletRequestHttpServletResponseıҪ
dɜy
yԇstruts1.2 ActionһҪ}execute¶Servlet API(@ʹÜyԇҪه)һUչstruts TestCase
ṩһstruts1.2ģMMМyԇ
Struts2.0 Actionͨ^ʼOÌ{(dio)÷yԇهע롱ҲʹÜyԇ
Java̎ԇԇ} 3
javaԇ}Ŀ1
1.ՄՄXML?fWebWeb.xmlļ?
XML(Extensible Markup Language)ɔUչӛZcHTMLһSGML(Standard Generalized Markup Language˜ͨØӛZ)XmlInterneth(hun)пƽ_هڃ(ni)ݵļg(sh)Ǯǰ̎Y(ji)(gu)ęnϢUչӛZXMLһNεĔ(sh)(j)惦ZʹһϵкεĘӛ(sh)(j)@Щӛ÷ķʽmȻXMLռõĿgȶMƔ(sh)(j)ҪռøĿgXMLO了պʹ
web.xmlÚgӭ퓣servletfilterlistenerȵ
2.jspЩ(ni)Ì?÷քeʲô?()
1)requestʾHttpServletRequestP(gun)g[ՈϢṩˎׂګ@ȡcookie headersession(sh)(j)õķ
2)responseʾHttpServletResponseṩˎׂOͻ g[푑ķ(cookies^Ϣ)
3)outjavax.jsp.JspWriterһṩˎׂʹg[ݔY(ji)
4)pageContextʾһjavax.servlet.jsp.PageContextڷȡNֿgservletP(gun)ČAPIҰbͨõservletP(gun)ܵķ
5)sessionʾһՈjavax.servlet.http.HttpSessionSessionԴAÑĠB(ti)Ϣ
6)application ʾһjavax.servle.ServletContext@ڲP(gun)servletservleth(hun)Ϣ
7)configʾһjavax.servlet.ServletConfigԓڴȡservletijʼ(sh)
8)pageʾԓa(chn)`һservlet
9)exception ᘌe`W(wng)δ
3.ʲô?ЩҪf@ЩԵĺx
(Transaction)Lܸ(sh)(j)иN(sh)(j)헵һ(zh)ІԪ(unit)
ͨɸ(sh)(j)ٿvZԻZ(SQLC++Java)ÑĈ(zh)𣬲begin transactionend transactionZ((sh){(dio))綨_ʼ(begin transaction)սY(ji)(end transaction)֮g(zh)еȫwM
Ցԓ4ԣԭһxm(x)ԡ@ĂͨQACID
ԭ(atomicity)һһɷָĹλаTҪôҪô
һ(consistency)ձʹ(sh)(j)һһԠB(ti)׃һһԠB(ti)һcԭP(gun)
x(isolation)һյĈ(zh)вܱոɔ_һՃ(ni)IJʹõĔ(sh)(j)l(f)Ǹxl(f)(zh)еĸ֮gܻɔ_
־(durability)m(x)ҲQ(permanence)ָһһύ(sh)(j)Д(sh)(j)ĸ׃͑ԓԵġϲԓκӰ
4Collection Collectionsą^(q)e?
Collectionjava.utilµĽӿڣǸNϵĸӿ^ĽӿҪSet List;Collectionsǂjava.utilµᘌϵĎṩһϵoB(ti)F(xin)Nϵ̰ȫȲ
5HashMapcTreeMapą^(q)e?
HashMapͨ^hashcode(ni)MпٲTreeMapеԪضijN̶ҪõһĽY(ji)͑ԓʹTreeMap(HashMapԪصDz̶)
6ArrayListVectorą^(q)e?
ͬ:VectorǾ̰ȫģҲfͬArrayListǾ̲ȫģͬ;(sh)(j)L:ҪLrVectorĬJLԭһArrayListsԭһ
Java̎ԇԇ}𰸡P(gun)£
Java̎ԇ}10-25
javaTԇԇ}03-10
Java̎ԇ}03-24
2016javaԇ}켰03-09
javaԇ}201703-06
Java̎ԇ}03-29
Java mainԇ}03-14
NIITJCJavaԇ}03-30
Javaԇ}201602-26