SSH登陆示例

快来打我* 2022-08-21 06:46 205阅读 0赞

按照上一篇所写的内容配置好SSH开发环境

http://blog.csdn.net/zk673820543/article/details/51218358

源码下载

http://download.csdn.net/detail/zk673820543/9499360

1、创建数据库

新建数据库，命名为sshtest

CREATE DATABASE sshtest DEFAULT CHARACTER SET utf8 COLLATE utf8\_general\_ci;  
新建表user\_info，sql如下：  
CREATE TABLE \`t\_user\` (  
 \`id\` int(4) NOT NULL AUTO\_INCREMENT,  
 \`username\` varchar(30) NOT NULL,  
 \`password\` varchar(20) NOT NULL,  
 PRIMARY KEY (\`id\`),  
 UNIQUE KEY \`username\` (\`username\`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
出入一条数据

insert into t\_user values(1,'LJaer','123');

![Center][]

2、建立数据库连接

在MyEclipse中，将视图切换到MyEclipse Database Explorer，新建一个数据库连接

由于我这里数据库没设置密码，所以password那里就空下

![Center 1][]

![Center 2][]

由于我自己的mysql数据库没设置密码，所以没填

直接Finish。  
在左侧双击刚才新增的数据库连接，输入密码，就可以看到ssh下面的t\_user表了

![Center 3][]

![Image 1][]

hibernate.cfg.xml根据实际情况进行修改

在src下新建一个package，model.system

回到数据库视图，右键点击t\_user表，选择Hibernate Reverse Engineering

![Center 4][]

![Image 1][]

![Center 5][]![Image 1][]

![Center 6][]

![Image 1][]

直接点Finish。  
现在可以看到已经添加好的文件

![Center 7][]

5、修改web.xml

<?xml version="1.0" encoding="UTF-8"?>
 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
   <display-name>test</display-name>
 
 
   
   <welcome-file-list>
     <welcome-file>index.html</welcome-file>
     <welcome-file>index.htm</welcome-file>
     <welcome-file>index.jsp</welcome-file>
     <welcome-file>default.html</welcome-file>
     <welcome-file>default.htm</welcome-file>
     <welcome-file>default.jsp</welcome-file>
   </welcome-file-list>
   
   
   <listener>
     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
   </listener>
   <context-param>
     <param-name>contextConfigLocation</param-name>
     <param-value>classpath:applicationContext.xml</param-value>
   </context-param>
   
         
     <context-param>  
         <param-name>log4jConfigLocation</param-name>  
         <param-value>classpath:log4j.properties</param-value>  
     </context-param>  
     <context-param>  
         <param-name>log4jRefreshInterval</param-name>  
         <param-value>60000</param-value>  
     </context-param>  
     <listener>  
         <listener-class>  
             org.springframework.web.util.Log4jConfigListener  
         </listener-class>  
     </listener>  
 	 
 	
   
   <filter>
     <filter-name>struts2</filter-name>
     <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
   </filter>
   <filter-mapping>
     <filter-name>struts2</filter-name>
     <url-pattern>/*</url-pattern>
   </filter-mapping>
 </web-app>

6.修改applicationContext.xml

内容如下

<?xml version="1.0" encoding="UTF-8"?>
 <beans
 	xmlns="http://www.springframework.org/schema/beans"
 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 	xmlns:p="http://www.springframework.org/schema/p"
 	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">
 
 
 
 <bean id="sessionFactory"
     class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="configLocation" value="classpath:hibernate.cfg.xml" />
    <property name="mappingResources">
    	<list>
    		<value>model/system/TUser.hbm.xml</value></list>
    </property></bean>
    
    
 <bean id="userDao" class="dao.system.UserDao">
    <property name="sessionFactory"> 
        <ref bean="sessionFactory"/>  
    </property>
 </bean>
 
 <bean id="LoginAction" class="action.login.LoginAction" scope="prototype">
 <property name="userService" ref="userService" />
 </bean>
   
     
 <bean id="userService" class="service.system.UserService">
         <property name="userDao">
         <ref bean="userDao"/>
       </property>
   </bean>
   
 </beans>

7、.添加dao,service和action  
结构如下：

![Image 1][]

UserDao.java内容如下：

package dao.system;
 
 import java.util.List;
 import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
 import model.system.TUser;
 
 
 public class UserDao extends HibernateDaoSupport{
 public void add(TUser m)
 {
 getHibernateTemplate().save(m);
 }
 @SuppressWarnings("unchecked")
 public List<TUser> showAllUsers()
 {
 return getHibernateTemplate().find("from user");
 }
 public void update(TUser m)
 {
 getHibernateTemplate().update(m);
 }
 public void delete(String id)
 {
 getHibernateTemplate().delete(getHibernateTemplate().get(TUser.class, id));
 }
 
 public TUser getUserById(String id)
 {
 	TUser m=(TUser)getHibernateTemplate().get(TUser.class, id);
 return m;
 }
 
 //普通用户登录验证
 @SuppressWarnings("unchecked")
 public boolean checkUser(String userName,String userPassword){
 boolean flag = false;
 String hql = "from TUser as user where user.username = '"+userName+"' and user.password = '"+userPassword+"'";
 List<TUser> userList = this.getHibernateTemplate().find(hql);
 if(userList.size()>0){
 flag = true;
 }
 return flag;
 }
 }

UserService.java内容如下：

package service.system;
    
    import dao.system.UserDao;
    
    public class UserService{
    private UserDao userDao;
    
    public boolean checkUser(String userName,String userPassword)
    {
    return userDao.checkUser(userName, userPassword);
    }
    public UserDao getUserDao() {
    return userDao;
    }
    
    public void setUserDao(UserDao userDao) {
    this.userDao = userDao;
    }  
    }

LoginAction.java内容如下：

package action.login;
    
    import com.opensymphony.xwork2.ActionSupport;
    
    import service.system.UserService;
    
    public class LoginAction extends ActionSupport{
    private static final long serialVersionUID = 3989633817331294940L;
    private String username;
    private String password;
    private UserService userService = new UserService();
    public UserService getUserService() {
    return userService;
    }
    public void setUserService(UserService userService) {
    this.userService = userService;
    }
    public String getUsername() {
      return username;
    }
    public void setUsername(String username) {
      this.username = username;
    }
    public String getPassword() {
      return password;
    }
    public void setPassword(String password) {
      this.password = password;
    }
    public String execute(){
    boolean flag = false;
    if (username == null || username.trim().equals("")) {
    this.addFieldError("username", "用户名不能为空");
    return "fail";
    } else if (password == null || password.trim().equals("")) {
    this.addFieldError("password", "密码不能为空");
    return "fail";
    } else {
    flag = userService.checkUser(username, password);
    if (flag) {
    return "success";
    } else {
    return "fail";
    }
    }
    }
    }

9.修改struts.xml

<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE struts PUBLIC
 "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN"
 "http://struts.apache.org/dtds/struts-2.1.dtd">
 <struts>
 
 
 <constant name="struts.objectFactory" value="spring" />
 
 
 <package name="ssh" extends="struts-default">
 
 <action name="loginAction" class="LoginAction">
 
 <result name="fail">/jsp/login/fail.jsp</result>
 <result name="success">/jsp/login/success.jsp</result>
 </action>
 </package>
 </struts>

10.添加页面  
  
  
在WebRoot文件夹下面新建一个jsp文件夹，存放页面。  
结构如下：

![Image 1][]

fail.jsp内容如下：

<%@ page language="java" pageEncoding="utf-8"%>
 <%
 String path = request.getContextPath();
 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
 %>
 
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <html>
 <head>
 <base href="<%=basePath%>">
 <title>Fail</title>
 </head>
 <body>
 登陆失败。 
 </body>
 </html>

success.jsp内容如下：

<%@ page language="java" pageEncoding="utf-8"%>
 <%
 String path = request.getContextPath();
 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
 %>
 
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <html>
 <head>
 <base href="<%=basePath%>">
 <title>Success</title>
 </head>
 <body>
 登陆成功。 
 </body>
 </html>

修改index.jsp，内容如下：

<%@ page language="java" pageEncoding="utf-8"%>
 
 <%@taglib uri="/struts-tags" prefix="s"%>
 
 <%
 String path = request.getContextPath();
 String basePath = request.getScheme() + "://"
 + request.getServerName() + ":" + request.getServerPort()
 + path + "/";
 %>
 
 <html> 
 <head>
 <title>用户登录</title>
 </head>
 <body>
 <center>
 <div id="login">
 <s:form action="loginAction" method="post">
 <s:textfield label="用户名" name="username"></s:textfield>
 <s:password label="密码" name="password"></s:password>
 <s:submit value="登录"></s:submit>
 </s:form>
 </div>
 </center>
 </body>
 </html>

11.新增log4j.properties文件  
放在src下

内容如下：

log4j.rootLogger=DEUBG, CATALINA  
  
  
\# Define all the appenders  
log4j.appender.CATALINA=org.apache.log4j.DailyRollingFileAppender  
log4j.appender.CATALINA.File=$\{catalina.base\}/logs/catalina.  
log4j.appender.CATALINA.Append=true  
log4j.appender.CATALINA.Encoding=UTF-8  
\# Roll-over the log once per day  
log4j.appender.CATALINA.DatePattern='.'yyyy-MM-dd'.log'  
log4j.appender.CATALINA.layout = org.apache.log4j.PatternLayout  
log4j.appender.CATALINA.layout.ConversionPattern = %d \[%t\] %-5p %c- %m%n  
  
  
log4j.appender.LOCALHOST=org.apache.log4j.DailyRollingFileAppender  
log4j.appender.LOCALHOST.File=$\{catalina.base\}/logs/localhost.  
log4j.appender.LOCALHOST.Append=true  
log4j.appender.LOCALHOST.Encoding=UTF-8  
log4j.appender.LOCALHOST.DatePattern='.'yyyy-MM-dd'.log'  
log4j.appender.LOCALHOST.layout = org.apache.log4j.PatternLayout  
log4j.appender.LOCALHOST.layout.ConversionPattern = %d \[%t\] %-5p %c- %m%n  
  
  
log4j.appender.MANAGER=org.apache.log4j.DailyRollingFileAppender  
log4j.appender.MANAGER.File=$\{catalina.base\}/logs/manager.  
log4j.appender.MANAGER.Append=true  
log4j.appender.MANAGER.Encoding=UTF-8  
log4j.appender.MANAGER.DatePattern='.'yyyy-MM-dd'.log'  
log4j.appender.MANAGER.layout = org.apache.log4j.PatternLayout  
log4j.appender.MANAGER.layout.ConversionPattern = %d \[%t\] %-5p %c- %m%n  
  
  
log4j.appender.HOST-MANAGER=org.apache.log4j.DailyRollingFileAppender  
log4j.appender.HOST-MANAGER.File=$\{catalina.base\}/logs/host-manager.  
log4j.appender.HOST-MANAGER.Append=true  
log4j.appender.HOST-MANAGER.Encoding=UTF-8  
log4j.appender.HOST-MANAGER.DatePattern='.'yyyy-MM-dd'.log'  
log4j.appender.HOST-MANAGER.layout = org.apache.log4j.PatternLayout  
log4j.appender.HOST-MANAGER.layout.ConversionPattern = %d \[%t\] %-5p %c- %m%n  
  
  
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender  
log4j.appender.CONSOLE.Encoding=UTF-8  
log4j.appender.CONSOLE.layout = org.apache.log4j.PatternLayout  
log4j.appender.CONSOLE.layout.ConversionPattern = %d \[%t\] %-5p %c- %m%n  
  
  
\# Configure which loggers log to which appenders  
log4j.logger.org.apache.catalina.core.ContainerBase.\[Catalina\].\[localhost\]=INFO, LOCALHOST  
log4j.logger.org.apache.catalina.core.ContainerBase.\[Catalina\].\[localhost\].\[/manager\]=INFO, MANAGER  
  INFO, HOST-MANAGER

log4j.logger.org.apache.catalina.core.ContainerBase.\[Catalina\].\[localhost\].\[/host-manager\]=INFO, HOST-MANAGER

12、部署运行

![Center 8][]

![Center 9][]

[Center]: /images/20220724/7d5640717e594139b87241a211aa87ba.png
[Center 1]: /images/20220724/d0dd9efead7a40a1987c0346be75b141.png
[Center 2]: /images/20220724/025ecf84742d42a1bf3b26d8f990734d.png
[Center 3]: /images/20220724/22f547ec0cc34a598ca26b05d3bccac3.png
[Image 1]: 
[Center 4]: /images/20220724/73e95953234e4c1a83198b11530acfc0.png
[Center 5]: https://img-blog.csdn.net/20160422095544670?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 6]: /images/20220724/16b85e9cd6aa4e03a0413e1c6151a9a8.png
[Center 7]: /images/20220724/968970dd18d647ee881f9465e593b601.png
[Center 8]: /images/20220724/1769ede44f31481ebf245d49ba66ef37.png
[Center 9]: /images/20220724/cb9c531db2be41ceb9a4e3c61637248e.png