weblogic92配置jndi数据源(mysql)

登录weblogic管控制台http://127.0.0.1:7001/console，Service->Jdbc->DataSources，点击lock&edit，建立数据源，并测试成功。

 

测试weblogic92配置的jndi数据源的java代码

package com.css.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class TestDS {

	/**
	 * 测试jndi数据源(weblogic集群)
	 * @param args
	 * @throws NamingException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws NamingException, SQLException {
		Properties prop = new Properties();
		
		prop.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
		prop.put(Context.PROVIDER_URL, "t3://127.0.0.1:7011,127.0.0.1:7012");
		prop.put(Context.SECURITY_PRINCIPAL, "weblogic");
		prop.put(Context.SECURITY_CREDENTIALS, "weblogic");
		
		Context context = new InitialContext(prop);
		DataSource dataSource = (DataSource) context.lookup("jdbc/testds");
		Connection conn = dataSource.getConnection();
		PreparedStatement ps = conn.prepareStatement("select * from user_info");
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			System.out.println("id is " + rs.getString(1) + "\n" + "name is " + rs.getString(2));
		}
		
		rs.close();
		ps.close();
		conn.close();
		context.close();
	}

}