ssh环境搭建(用户登陆实例)

users.sql

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO

CREATE TABLE [dbo].[Users] (
 [userid] [int] NOT NULL ,
 [username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [types] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
 [email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

注意：types字段：1表示管理员0表示普通用户9表示登陆失败

HibernateDaoSupport的运用及配置

package org.song.cad.dao;

import java.util.List;

import org.song.cad.vo.User;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class LoginDAO extends HibernateDaoSupport{
 public int login(String username,String password){
  Character a3=new Character('9');
  try{
   List<User> userlist=(getHibernateTemplate().find("from User where username=? and password=?", new Object[]{username,password}));
   
   int type=a3;
   if(userlist==null||userlist.size()==0)
    return a3;
   User user=userlist.get(0);
   if(user!=null){
    type=user.getType();
    System.out.println("type="+type);
   }
   return type;
   }catch(NullPointerException e){
    e.printStackTrace();
    return a3;
   }
 }
 
}

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
 "/WEB-INF/dtd/spring-beans.dtd">
<beans>
 
 <bean id="dataSource"
       class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName">
   <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value><!-- org.gjt.mm.mysql.Driver -->
  </property>
  <property name="url">
   <value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=cad</value>
  </property>
  <property name="username">
   <value>sa</value>
  </property>
  <property name="password">
   <value></value>
  </property>
 </bean>
 
 
 
 <!-- 配置SessionFactory -->
 <bean id="mySessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="mappingResources">
   <list>
   <value>org/song/cad/vo/User.hbm.xml</value>
   </list>
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.SQLServerDialect
    </prop>
    <prop key="hibernate.show_sql">true</prop>
    <prop key="current_session_context_class">thread</prop>
    <prop key="hibernate.cache.provider_class">
     org.hibernate.cache.EhCacheProvider
    </prop>
    <prop key="connection.pool_size">10</prop>
    <prop key="hibernate.hbm2ddl.auto">update</prop>
   </props>
  </property>
  <property name="dataSource">
   <ref bean="dataSource"/>
  </property>
 </bean>
 
 
 <bean id="loginDAO" class="org.song.cad.dao.LoginDAO">
  <property name="sessionFactory">
   <ref local="mySessionFactory"/>
  </property>
 </bean>
 <bean id="loginService" class="org.song.cad.service.LoginService"
 abstract="false"  lazy-init="default"
  autowire="default" dependency-check="default">
  <property name="loginDAO" ref="loginDAO"></property>
 </bean>
 <bean name="/login" class="org.song.cad.action.LoginAction"
 abstract="false" lazy-init="default"
  autowire="default" dependency-check="default">
 <property name="loginService" ref="loginService"></property>
 </bean>
</beans>

 

 

参照：

package org.song.cad;

public class Test {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO 自动生成方法存根
  Character a=new Character('0');
  int b=a;
  System.out.println(b);//48
  
  Character a2=new Character('1');
  int b2=a2;
  System.out.println(b2);//49
  
  Character a3=new Character('9');
  int b3=a3;
  System.out.println(b3);//57
 }

}