Shulou(Shulou.com)06/02 Report--

Editor to share with you how to configure MyEclipse+WebLogic+MySQL data sources, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The configuration of MyEclipse+WebLogic+MySQL data source, first of all, it feels that it is relatively simple to configure the data source of Web application on the console of Weblogic. Here, as a test, for clarity, it is divided into three headings: test project preparation, data source configuration, and release testing.

Test engineering preparation

Mainly prepare to test and configure the data source of the Java Web project, the project name is WeblogicDataSource.

The BlogService class obtains an instance of a data source (DataSource) by looking up the JNDI name, and then, by connecting to the MySQL database, queries the records from the table jblog _ article in the database blog, and returns a List collection of results. The source code for BlogService.java is as follows:

Package org.shirdrn.blog; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.naming.Context; import javax.naming.InitialContext; import javax.sql.DataSource; import org.shirdrn.blog.entity.Article Public class BlogService {public List getAticles (String sql) throws Exception {/ / change the method to get the data by passing a sql query, which will call Context ctx = new InitialContext (); DataSource ds = (DataSource) ctx.lookup ("jdbc/mysql") in the following Servlet; / / the data source name is jdbc/mysql Connection conn = ds.getConnection (); Statement stmt = conn.createStatement (); ResultSet rs = stmt.executeQuery (sql) List articleList = new ArrayList (); while (rs.next ()) {Article article = new Article (); article.setId (new Integer (rs.getInt (1); article.setCid (new Integer (rs.getInt (2); article.setUid (new Integer (rs.getInt (3); article.setUserName (rs.getString (4)); article.setTitle (rs.getString (5)) Article.setUrlName (rs.getString (6)); article.setStatus (new Short (rs.getShort (7); article.setPassword (rs.getString (8)); article.setContent (rs.getString (13)); articleList.add (article);} return articleList;}}

An entity class Article is used above, and the entity class code is as follows:

Package org.shirdrn.blog.entity; public class Article {private Integer id; private Integer cid; private Integer uid; private String userName; private String title; private String urlName; private Short status; private String password; private String from; private String forumUrl; private String description; private String excerpt; private String content; private String comments; private String views; private Integer dataline; private Boolean isTop; private Boolean isCommend; private Boolean isCheck; private String tags; public Integer getId () {return id } public void setId (Integer id) {this.id = id;} public Integer getCid () {return cid;} public void setCid (Integer cid) {this.cid = cid;} public Integer getUid () {return uid;} public void setUid (Integer uid) {this.uid = uid;} public String getUserName () {return userName;} public void setUserName (String userName) {this.userName = userName } public String getTitle () {return title;} public void setTitle (String title) {this.title = title;} public String getUrlName () {return urlName;} public void setUrlName (String urlName) {this.urlName = urlName;} public Short getStatus () {return status;} public void setStatus (Short status) {this.status = status;} public String getPassword () {return password } public void setPassword (String password) {this.password = password;} public String getFrom () {return from;} public void setFrom (String from) {this.from = from;} public String getForumUrl () {return forumUrl;} public void setForumUrl (String forumUrl) {this.forumUrl = forumUrl;} public String getDescription () {return description;} public void setDescription (String description) {this.description = description } public String getExcerpt () {return excerpt;} public void setExcerpt (String excerpt) {this.excerpt = excerpt;} public String getContent () {return content;} public void setContent (String content) {this.content = content;} public String getComments () {return comments;} public void setComments (String comments) {this.comments = comments;} public String getViews () {return views } public void setViews (String views) {this.views = views;} public Integer getDataline () {return dataline;} public void setDataline (Integer dataline) {this.dataline = dataline;} public Boolean getIsTop () {return isTop;} public void setIsTop (Boolean isTop) {this.isTop = isTop;} public Boolean getIsCommend () {return isCommend;} public void setIsCommend (Boolean isCommend) {this.isCommend = isCommend } public Boolean getIsCheck () {return isCheck;} public void setIsCheck (Boolean isCheck) {this.isCheck = isCheck;} public String getTags () {return tags;} public void setTags (String tags) {this.tags = tags;}}

The Servlet implemented is also relatively simple. The Servlet name is GetArticlesServlet and the mapping name is getArticles. The code is as follows:

Package org.shirdrn.servlet; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.shirdrn.blog.BlogService; public class GetArticlesServlet extends HttpServlet {public GetArticlesServlet () {super ();} public void destroy () {super.destroy () } public void doGet (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost (request, response);} public void doPost (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {HttpSession session = request.getSession (); String sql = "select * from jblog_article"; BlogService bs = new BlogService (); List articleList = null; try {articleList = bs.getAticles (sql);} catch (Exception) {e.printStackTrace () } session.setAttribute ("articleList", articleList); response.sendRedirect ("listArticles.jsp");} public void init () throws ServletException {}}

There is only one related list page that displays the query results, that is, listArticles.jsp, with the following code:

<% @ page language= "java" import= "java.util.*" pageEncoding= "utf-8"% > <% @ page import= "org.shirdrn.blog.entity.Article"% > < html > < head > < title > blog article list page < / title > < / head > < body > <% List articleList = (List) session.getAttribute ("articleList") < / body > < table style= "color:yellow" align= "center" bgcolor= "green" border= "1" borderColor= "black" > < tr > < th > ID < / th > < th > CID < / th > < th > UID < / th > < th > username < / th > < th > title < / th > < / tr > <% for (int item0; I < articleList.size ()) Article +) {Article a = (Article) articleList.get (I) < tr > < td > <% = a.getId () > < / td > < td > <% = a.getCid ()% > < / td > < td > <% = a.getUid ()% > < / td > < td > <% = a.getUserName ()% > < / td > < td > <% = a.getTitle ()% > < / td > < / tr > <%} > < / table > < / html >

The content of the application deployment description file web.xml for the corresponding Java Web project is as follows:

< web-app > < servlet > < servlet-name > GetArticlesServlet < / servlet-name > < servlet-class > org.shirdrn.servlet.GetArticlesServlet < / servlet-class > < / servlet > < servlet-mapping > < servlet-name > GetArticlesServlet < / servlet-name > < url-pattern > / getArticles < / url-pattern > < / servlet-mapping > < welcome-file-list > < welcome-file > index.jsp < / welcome-file > < / welcome-file-list > < / web-app >

It is worth noting that the web-app 2.3 deployment description file is used here, and if it is 2.4, it is bound to make an error.

Configure the data source

In MyEclipse, configure the Paths in Weblogic in Server, that is, add the jar file of the JDBC driver of the database to the CLASSPATH. I use the MySQL database here, and the corresponding JDBC driver version is mysql-connector-java-5.0.8-bin.jar, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 1

After compiling the project in MyEclipse, first use MyEclipse's packaging tool to package the WAR package:

Select "J2EE"-> "WAR file (MyEclipse)" under Export, specify the path, and I stored it under D:\ bea\ user_projects\ domains\ sndomain\ applications\ WeblogicDataSource.war.

At this point, you can start Weblogic Server (if Weblogic Server is configured, for example, mine is snserver) and log in to Weblogic Console. Open the "Web Application Module" under "deployment" on the left, and you can see "_ appsdir_WeblogicDataSource_dir". This is because when I export to a war file in MyEclipse, I export it directly to the Weblogic Server application directory and deploy it automatically, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 2

You can see that in the deployment tab on the right, deployment status is available.

To configure the data source, the first thing to do is to configure the database connection buffer pool, and then the configuration of the data source based on the changed connection pool.

(1) configuration of database connection pool

The following is the configuration process for database connection pooling:

In the left navigation menu, open Services-> JDBC, and click connection buffer Pool, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 3

Click the configure new JDBC connection buffer pool link, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 4

Configure the database type (MySQL here) and the database driver (select com.mysql.jdbc.Driver here), and click the continue button, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 5

Configure the JDBC connection pool name (MySQLcp in this case), database name (blog in this case), host name (localhost in this case), port number (MySQLcp database here, default is 3306), database user name (root in this case), database login password, and then click the continue button, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 6

Click Test driver configuration to test the JDBC driver for the previously configured database, if there is no problem, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 7

The green text "connected successfully" appears in the upper left corner, otherwise it will not pass the configuration test. Click the create and deploy button to see the successfully configured JDBC database connection buffer pool, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 8

(2) configure data sources

In the left navigation menu, open Services-> JDBC, and click data sources, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 9

Click the configure new JDBC data source link to configure the data source name (MySQLds in this case) and JNDI name (jdbc/mysql in this case), as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 10

Click the continue link, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 11

You can select an existing database connection pool from the drop-down list, and then click the continue button, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 12

Click the create button to create the data source based on the data source options you just configured, as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 13

The data source configuration is complete.

At this point, the data source MySQLcp (jdbc/mysql) can provide a data source for the Web application.

Release test

If the packaged war file of the Web application is not placed in the Weblogic Server application directory, it can be uploaded on Weblogic Console. If it has been placed in the Weblogic Server application directory, it can be tested.

Open the connection http://192.168.151.201:7001/WeblogicDataSource/getArticles and display the list as shown in the figure:

Configuration of MyEclipse+WebLogic+MySQL data source figure 14

Through the test, it shows that the above configured data source exists, which can provide the data source for the tested Web application.

These are all the contents of the article "how to configure MyEclipse+WebLogic+MySQL data sources". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.