jsp教学第15天课件

JSP课第15天课件1、JNDI=JavaNamingDiretoryInterface 命名目录 数据库服务器,DbServer文档服务器,ftpserver邮件服务器,mailserver证书服务器,CAServer消息服务器,MsgServer14、当使用jdbc工作框架，try/catch/finally时<Resourcename="jdbc/MyDS"auth="Container"username="studsys"<Resourcename="jdbc/MyDS"auth="Container"username="studsys"password="orcl"<Resourcename="jdbc/MyDS"auth="Container"maxActive="8"maxIdle="4"/>tomcat<Resourcename="jdbc/MyDS"auth="Container"maxActive="8"maxIdle="4"/><Resourcename="jdbc/MyDS"maxActive="8"maxIdle="4"/><Resourcename="jdbc/MyDS"maxActive="8"maxIdle="4"/>showdatabases;showtables;usestudsys;usetest;usesetcharsetusestudsys;show setcharset 字段名称5MSSQLORACLE十一、jndi1、相关工具包<%@pagelanguage="java"import="java.util.*"<%@page<%@page<%@page<%@page<%@page<%@page<!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01检测JNDIConnectionconn=null;//Contextcnt=newInitialContext();//DataSourceconn=ds.getConnection()//Stringsql="select*fromuser_reg";ResultSetrs=stmt.executeQuery(sql);intno=0;Stringname=rs.getString("name");Stringpassword=rs.getString("password");} 十二、JNDICSpublicpublicclassTestJNDIpublicstaticvoidtest()throwsException{Connectionconn=null;//Contextcnt=newInitialContext();//接 //依据 Stringsql="select*fromuser_reg";ResultSetrs=stmt.executeQuery(sql);intno=0;Stringname=rs.getString("name");Stringpassword=rs.getString("password");} }publicstaticvoidmain(String[]args)throws}}}十三、JNDI1jndi2、jdbc的驱动jar包[tomcat]\lib\[tomcat]\lib\[tomcat]\lib\mysql-connector-java-5.1.18-bin.jar3、jndi的开始运行的地方必须在jsp,servlet十四、jdbcjndiCSBS差好十五、A，原子性十六、jdbc2、事务处理框架Connectionconn=null; }e){);}}publicpublicclassTestJdbcTransactionpublicstaticvoidtest(){Connectionconn=null;try{StatementStringsql1="updatestudysetscore=137.66wherestud_id=10000andcourse_id=2"; Stringsql1="updatestudysetscore=155.66wherestud_id=10000andcourse_id=2";Stringsql2="updatestudysetscore=149.76wherestud_id=10001andcourse_id=2";mit();//要么全部成功

}catch(Exception{try}catch(SQLExceptione1)//TODOAuto-generatedcatchblock}}}}publicstaticvoidmain(String[]args)TestJdbcTransaction.test();//在本类中，上面的一行与这一行等效，}}publicabstractclassDbUtilpublicstaticConnectiontryConnectionconn=null;//Contextcnt=newInitialContext();//接 //依据 return}e){);return}}publicpublicstaticConnectiontry StringStringusername="studsys";Connectionconn=null;return}e){return}}十七、JSP运行有错误的servlet,或jsp时<%@pagelanguage="java"imp