spring配置mysql数据库及对数据库的操作

最新推荐文章于 2024-03-19 16:28:22 发布

lsx1065227020

最新推荐文章于 2024-03-19 16:28:22 发布

阅读量259

点赞数

文章标签：数据库 mysql spring class bean stylesheet

本文链接：https://blog.csdn.net/lsx1065227020/article/details/8064331

版权

applicationContext.xml

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
             <property name="driverClassName">
              <value>com.mysql.jdbc.Driver</value>
             </property>
             <property name="url">
              <value>jdbc:mysql://localhost:3306/banktest</value>
             </property>
             <property name="username">
              <value>root</value>
             </property>
             <property name="password">
              <value></value>
             </property>
           </bean>
           <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
             <property name="dataSource">
              <ref local="dataSource"/>
           </property>
           </bean>
         <bean id="userdaoImpl" class="com.yuwang.cn.dao.impl.UserDaoImpl" lazy-init="true">
         <property name="jdbcTemplate">
           <ref local="jdbcTemplate"/>
         </property>
         </bean>

     <bean id="loginService" class="com.yuwang.cn.service.LoginService" lazy-init="true">
      <property name="userdaoImpl">
       <ref local="userdaoImpl"/>
      </property>
     </bean>
     <bean id="loginAction" class="com.yuwang.cn.action.LoginAction" lazy-init="true">
      <property name="loginserv">
       <ref bean="loginService"/>
      </property>
     </bean>

//struts.xml配置

    <struts>

    <package name="" extends="struts-default">
    <action name="addUserAction" class="loginAction" method="addUserAction">
      <result name="success">jsp/home/login.jsp</result>
    </action>
    </package>
    </struts>

//Dao接口

package com.yuwang.cn.dao;

import com.yuwang.cn.model.UserModel;

public interface UserDao{
public int inserUser(UserModel userModel);
}

//daoimpl是Dao接口的实现

package com.yuwang.cn.dao.impl;

import org.springframework.jdbc.core.JdbcTemplate;

import com.yuwang.cn.dao.UserDao;
import com.yuwang.cn.model.UserModel;

public class UserDaoImpl implements UserDao{
private JdbcTemplate jdbcTemplate;

public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  this.jdbcTemplate = jdbcTemplate;
}
/**
*向users表中插入数据
*/
public int inserUser(UserModel userModel) {
  // TODO Auto-generated method stub
  String sql = "insert into users values(?,?,?)";
  Object []params = new Object[]{
    userModel.getId(),
    userModel.getName(),
    userModel.getPswd()
  };
  return this.getJdbcTemplate().update(sql, params);
}

}

//service层

package com.yuwang.cn.service;

import com.yuwang.cn.dao.UserDao;
import com.yuwang.cn.model.UserModel;

public class LoginService {
private UserDao userdaoImpl;
public UserDao getUserdaoImpl() {
  return userdaoImpl;
}
public void setUserdaoImpl(UserDao userdaoImpl) {
  this.userdaoImpl = userdaoImpl;
}
/**
* 插入数据service
* @param userModel
* @return
*/
public int addUser(UserModel userModel){
  return userdaoImpl.inserUser(userModel);

}

}

//action层
package com.yuwang.cn.action;

import com.opensymphony.xwork2.ActionSupport;
import com.yuwang.cn.model.UserModel;
import com.yuwang.cn.service.LoginService;

public class LoginAction extends ActionSupport{
private UserModel user = new UserModel();
private LoginService loginserv;
public LoginService getLoginserv() {
  return loginserv;
}
public void setLoginserv(LoginService loginserv) {
  this.loginserv = loginserv;
}
public UserModel getUser() {
  return user;
}
public void setUser(UserModel user) {
  this.user = user;
}
public String addUserAction(){
  int i = loginserv.addUser(user);
  System.out.println(i);
  return "success";
}
}

//jsp页面

<html>
<head>
    <base href="<%=basePath%>">

    <title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">