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
}
}