启动ManagedServer要到domain的home目录下的bin/stopManagedWebLogic.cmd启动。启动完后进入控制台，ManagedServer处于running状态。
index.jsp
<%@page import="weblogic.apache.org.apache.velocity.runtime.directive.Foreach"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.List,com.test.bean.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
Hello
<a href="http://localhost:7011/testCluster3/TestEntityBean">click to query</a>
<table align="center" cellpadding="3" cellspacing="1" bgcolor="#0099FF" width="700">
<%
Object userList = request.getAttribute("userList");
if(userList != null){
List<User> list = (List<User>)userList;
for(int i =0;i<list.size();i++){
Object o = list.get(i);
User user = (User)o;
%>
<tr>
<td><%=user.getId()%></td>
<td><%=user.getName()%></td>
</tr>
<%
}
}
%>
</table>
</body>
</html>
TestEntityBean.java
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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 com.test.bean.User;
/**
* Servlet implementation class TestEntityBean
*/
@WebServlet("/TestEntityBean")
public class TestEntityBean extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public TestEntityBean() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
Context ctx;
try {
ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("MySQLDS");
Connection conn = ds.getConnection();
Statement stmt = null;
ResultSet rs = null;
stmt = conn.createStatement();
String sql = "select * from test;";
rs = stmt.executeQuery(sql);
List<User> userList = new ArrayList<User>();
while(rs.next()){
System.out.println(rs.getInt("id"));
System.out.println(rs.getString("name"));
User user = new User();
user.setName(rs.getString("name"));
user.setId(rs.getInt("id"));
userList.add(user);
}
request.setAttribute("userList",userList);
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
rd.forward(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
}
User.java
package com.test.bean;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="test")
public class User {
private int id;
private String name;
@Id
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
当前位置：
论坛首页 »
自由讨论区 »
Tomcat, WebLogic及J2EE讨论区
»
发起投票
技术讨论
加好友
发消息
2015-1-16 16:58:08 |
赞(
操作
