[学习笔记]
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