weblogic92配置jndi数据源(mysql)

louyaoluan

　　登录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();
}
}