加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > Java > 正文

java当中JDBC当中JNDI用来查找dataSource的例子

发布时间:2020-12-15 07:31:52 所属栏目:Java 来源:网络整理
导读:[学习笔记] 8.JNDI用来查找dataSource的例子: import javax.naming.InitialContext; import javax.naming.Context; import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; import java.util.Properties; import net.sourceforge.jtds.jdbcx

[学习笔记]

8.JNDI用来查找dataSource的例子:

import javax.naming.InitialContext;
import javax.naming.Context;

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource;

import java.util.Properties;
import net.sourceforge.jtds.jdbcx.*;
public class ClassPut {
??????? public static void main(String a[]) {
??????????????? try {
/*????????????????? JtdsDataSource dataSource=new? JtdsDataSource();
??????????????????????? dataSource.setServerName("localhost");
??????????????????????? dataSource.setDatabaseName("NorthWind");
??????????????????????? dataSource.setUser("sa");
??????????????????????? dataSource.setPassword("1234");
*/
??????????????? ??? MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolDataSource();
??????????????????? ds.setURL("jdbc:mysql://localhost:3306/test");
??????????????????? ds.setUser("root");
??????????????????? ds.setPassword("1234");????????????????? ????
????????????????????????
????????????????????????
??????????????????????? Properties prop = new Properties();
??????????????????????? prop.setProperty(Context.INITIAL_CONTEXT_FACTORY,
??????????????????????????????????????? "com.sun.jndi.fscontext.RefFSContextFactory");

??????????????????????? Context ctx=new InitialContext(prop);
/*here the following statement writes a file .bindings under the f Disk. because this project is under the f disk.*/
??????????????????????? ctx.rebind("abc",ds);


??????????????? } catch (Exception e) {
??????????????????????? e.printStackTrace();
??????????????? }
??????? }
}
上面的程序只是存入硬盘,想查找出来得用下面的程序:

import javax.naming.InitialContext;
import javax.naming.Context;

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import net.sourceforge.jtds.jdbcx.*;
public class ClassGet {
??????? public static void main(String a[]) {

??????????????? try {
??????????????????????? Properties prop = new Properties();
??????????????????????? prop.setProperty(Context.INITIAL_CONTEXT_FACTORY,
??????????????????????????????????????? "com.sun.jndi.fscontext.RefFSContextFactory");
??????????????????????? Context ctx=new InitialContext(prop);

文章转载自原文:https://blog.csdn.net/qq_43650923/article/details/100652625

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读