已经在spring的配置文件中配置了
<bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/zmcss"/>
<property name="username" value="root"/>
<property name="password" value="1234554321"/>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
我在WEB服务启动的时候,会调用一个pServlet。
<servlet>
<servlet-name>css1</servlet-name>
<servlet-class>com.css1.admins.pServlet</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet>现在我要在pServlet的init()方法中从数据库中读取数据,应该怎么做???
请懂的人指教一下。
<bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/zmcss"/>
<property name="username" value="root"/>
<property name="password" value="1234554321"/>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
我在WEB服务启动的时候,会调用一个pServlet。
<servlet>
<servlet-name>css1</servlet-name>
<servlet-class>com.css1.admins.pServlet</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet>现在我要在pServlet的init()方法中从数据库中读取数据,应该怎么做???
请懂的人指教一下。
这样对不?public interface ProductClassMapper {
@Select("SELECT * FROM productclass")
public List<ProductClassEntity> getProductclassList();
}
@Entity
public class ProductClassEntity {
/**
*
*/
private static final long serialVersionUID = 1L; public ProductClassEntity (){}
private String id;
private String className;
private String inputTime;
private String inputUser; /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub } public String getId() {
return id;
} public void setId(String id) {
this.id = id;
} public String getClassName() {
return className;
} public void setClassName(String className) {
this.className = className;
} public String getInputTime() {
return inputTime;
} public void setInputTime(String inputTime) {
this.inputTime = inputTime;
} public String getInputUser() {
return inputUser;
} public void setInputUser(String inputUser) {
this.inputUser = inputUser;
}}
/**
* Servlet implementation class StartLoadSer
*/
@WebServlet("/StartLoadSer")
public class StartLoadSer extends HttpServlet {
private static final long serialVersionUID = 1L;
@Autowired
private ProductClassMapper productClassMapper;
/**
* @see HttpServlet#HttpServlet()
*/
public StartLoadSer() {
super();
// TODO Auto-generated constructor stub
} /**
* @see Servlet#init(ServletConfig)
*/
public void init(ServletConfig config) throws ServletException {
// TODO Auto-generated method stub
List<ProductClassEntity> list= new ArrayList<ProductClassEntity>();
list = productClassMapper.getProductclassList();
}
}