讲义JDBC5（Handout JDBC5）.docVIP

讲义JDBC5（Handout JDBC5） datasource: javax.sql.datasource (interface) public connection getconnection () throws sqlexception public connection getconnection (string username, string password) throws sqlexception / / 1. create datasource - register drives xxxdatasource source = new xxxdatasource (); / / mysqldatasource, oracledatasource source.setservername (servername); / / servername - - hostname source.setdatabasename (dbname); / / dbname - - 具体的数据库 source.setport (port); / // / source.seturl (url); / / 另一种用法 source.setuser (root); source.setpassword (); / / 2. get connection connection con = source.getconnection (); * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * jndi: java naming and directory interface 目录和命名服务接口 1. volume name two service (local, remote) 绑定: one programme create datasource (mysql, oracle) volume a name (datasource) two datasource 1 . create jndi environment 生成jndi环境 java.util.properties jndienv = new java.util.properties (); jndienv.setproperty (context.initial _ context _ factory, contextfactoryname); jndienv.setproperty (context.provider _ url, url); 2 . create context object 生成上下文对象 context cx = new initialcontext (jndienv); 3 . create object (datasource, javabean, string) 生成数据源对象 4 cx.bind (name, object); 绑定 ---------------------------------------------------------------------------------------- 2. look up service by name: another program look datasource town the name (datasource) 1 . create jndi environment 生成jndi环境 java.util.properties jndienv = new java.util.properties (); jndienv.setproperty (context.initial _ context _ factory, contextfactoryname); jndienv.setproperty (context.provider _ url, url); 2 . create context object 生成上下文对象 context cx = new initialcontext (jndienv); 3 object = cx.lookup (name); 查询 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * conne