这个是applicationContext.xml的内容****************************************************************************
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor
</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>***</value>
</property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
.......
<list>
</property>
</bean>
......
</beans>
****************************************************************************
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor
</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>***</value>
</property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
.......
<list>
</property>
</bean>
......
</beans>
****************************************************************************
解决方案 »
- 后台报错java.sql.SQLException: Column 'BoardId' not found.
- 上传图片到FTP的时候图片是空白的,流不为空,不知道怎么回事
- 汇编实现从 一个文件读信息,并将信息写入另一文件 。问题程序
- 请教struts里ActionForm的问题
- 经过struts Action处理后,找不到图片或js文件
- 哪个用过网络框架MINA?
- 看过精通Struts:基于MVC的JavaWeb设计与开发(孙卫琴)的帮帮忙!
- 一个C和JAVA通信(通过SOCKET)的问题
- 大家快来帮我解决一个奇怪的问题!!!!
- J2ee包括以下13种技术
- hibernate-extensions生成POJO问题。在线等
- 有意在业余搞项目的朋友请进---->
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor
'给你看看我的做参考
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.jnetdirect.jsql.JSQLDriver</value>
</property>
<property name="url">
<value>jdbc:JSQLConnect://localhost:1433/depot</value>
</property>
只是换了一个JDBC的驱动吧
你的JNETDIRECT在哪里有下载呢
换了这个驱动也一样
*********************************************************************
10:47:58,628 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: null
10:47:58,628 ERROR JDBCExceptionReporter:72 - Cannot create JDBC driver of class 'com.jnetdirect.jsql.JSQLDriver' for connect URL '
jdbc:JSQLConnect://localhost:1433/msnews
'
10:47:58,628 WARN SettingsFactory:103 - Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.jnetdirect.jsql.JSQLDriver' for connect URL '
jdbc:JSQLConnect://localhost:1433/msnews
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
... 35 more
*********************************************************************
而且不用SPRING却不会报错
这是怎么回事
<property name="url">
<value>
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor
</value>
改成
<property name="url">
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor</value>
就没有错了,是文件的编码问题吗?
************************************************************
这个问题解决了,可是新问题又来了13:46:30,812 INFO SessionFactoryImpl:152 - building session factory
13:46:30,822 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/E:/My%20Web/ms-info/WebRoot/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
13:46:32,424 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
13:46:32,434 INFO SessionFactoryImpl:379 - Checking 0 named queries又是提示 configuration 没有找到,
以前我这CSDN也发过这个帖子,后来有人说是主键生成的问题,因为我的数据库主键是自增的,而我选用hibernate 的主键生成器却是 uuix.hex ,从而出现这个错误,后来我把 uuix.hex 换成了 native 就好了。而现在我使用了 spring
数据库主键是自增的,hibernate 主键生成器是 native
却又出现了这个错误,烦死了
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor
</value>
放到同一行
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor</value>
com.jnetdirect.jsql.JSQLDriver只能做物理连接,不能提供真正的连接池,建议你用com.jnetdirect.jsql.JSQLDriver,它才能提供真正的连接池。?????
不是明白你的意思
两个驱动都是一样的啊
***********************************************************
15:33:53,406 INFO Environment:464 - Hibernate 3.0.5
15:33:53,406 INFO Environment:477 - hibernate.properties not found
15:33:53,416 INFO Environment:510 - using CGLIB reflection optimizer
15:33:53,426 INFO Environment:540 - using JDK 1.4 java.sql.Timestamp handling
15:33:54,137 INFO HbmBinder:260 - Mapping class: model.UAddCoinLog -> U_AddCoinLog
15:33:54,397 INFO HbmBinder:260 - Mapping class: model.ChrPopularizeDetail -> Chr_PopularizeDetail
15:33:54,497 INFO HbmBinder:260 - Mapping class: model.NNewsSort -> N_NewsSort
15:33:54,567 INFO HbmBinder:260 - Mapping class: model.URegInfo -> U_RegInfo
15:33:54,617 INFO HbmBinder:260 - Mapping class: model.TNewsList -> T_NewsList
15:33:54,657 INFO HbmBinder:260 - Mapping class: model.ChrPopularizeList -> Chr_PopularizeList
15:33:54,688 INFO HbmBinder:260 - Mapping class: model.ManagerList -> ManagerList
15:33:54,748 INFO HbmBinder:260 - Mapping class: model.UAttributeInfo -> U_Attribute_Info
15:33:54,818 INFO HbmBinder:260 - Mapping class: model.UBasicInfo -> U_BasicInfo
15:33:55,208 INFO HbmBinder:260 - Mapping class: model.IInfoSort -> I_InfoSort
15:33:55,298 INFO HbmBinder:260 - Mapping class: model.IKeywords -> I_Keywords
15:33:55,358 INFO HbmBinder:260 - Mapping class: model.MemberMsg -> MemberMsg
15:33:55,439 INFO HbmBinder:260 - Mapping class: model.CorpPopularizeLog -> Corp_PopularizeLog
15:33:55,529 INFO HbmBinder:260 - Mapping class: model.IInfoList -> I_InfoList
15:33:55,579 INFO HbmBinder:260 - Mapping class: model.KeywordsSaleLog -> Keywords_Sale_Log
15:33:55,579 INFO Configuration:875 - processing extends queue
15:33:55,579 INFO Configuration:879 - processing collection mappings
15:33:55,589 INFO HbmBinder:2041 - Mapping collection: model.NNewsSort.TNewsLists -> T_NewsList
15:33:55,589 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.corpPopularizeLogs -> Corp_PopularizeLog
15:33:55,589 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.UAttributeInfos -> U_Attribute_Info
15:33:55,589 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.UBasicInfos -> U_BasicInfo
15:33:55,589 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.memberMsgs -> MemberMsg
15:33:55,589 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.UAddCoinLogs -> U_AddCoinLog
15:33:55,599 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.IInfoLists -> I_InfoList
15:33:55,599 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.chrPopularizeDetails -> Chr_PopularizeDetail
15:33:55,599 INFO HbmBinder:2041 - Mapping collection: model.URegInfo.keywordsSaleLogs -> Keywords_Sale_Log
15:33:55,599 INFO HbmBinder:2041 - Mapping collection: model.ChrPopularizeList.chrPopularizeDetails -> Chr_PopularizeDetail
15:33:55,599 INFO HbmBinder:2041 - Mapping collection: model.IInfoSort.IInfoLists -> I_InfoList
15:33:55,609 INFO HbmBinder:2041 - Mapping collection: model.IInfoSort.IInfoSorts -> I_InfoSort
15:33:55,609 INFO HbmBinder:2041 - Mapping collection: model.IKeywords.chrPopularizeLists -> Chr_PopularizeList
15:33:55,609 INFO HbmBinder:2041 - Mapping collection: model.IKeywords.keywordsSaleLogs -> Keywords_Sale_Log
15:33:55,609 INFO Configuration:888 - processing association property references
15:33:55,609 INFO Configuration:917 - processing foreign key constraints
15:33:56,140 INFO ConnectionProviderFactory:53 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
JSQLConnect(5.53) Trial license - expires on:Wed Oct 11 05:57:08 CST 2006
15:33:56,530 INFO SettingsFactory:77 - RDBMS: Microsoft SQL Server, version: 8.0.2039
15:33:56,530 INFO SettingsFactory:78 - JDBC driver: JNetDirect JSQLConnect 4.0 - JDBC 3.0, version: 5.53
15:33:56,580 INFO Dialect:92 - Using dialect: org.hibernate.dialect.SQLServerDialect
15:33:56,590 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
15:33:56,600 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
15:33:56,600 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
15:33:56,600 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
15:33:56,610 INFO SettingsFactory:144 - Scrollable result sets: enabled
15:33:56,610 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): enabled
15:33:56,610 INFO SettingsFactory:160 - Connection release mode: on_close
15:33:56,610 INFO SettingsFactory:187 - Default batch fetch size: 1
15:33:56,610 INFO SettingsFactory:191 - Generate SQL with comments: disabled
15:33:56,610 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
15:33:56,610 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
15:33:56,620 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
15:33:56,620 INFO SettingsFactory:203 - Query language substitutions: {}
15:33:56,620 INFO SettingsFactory:209 - Second-level cache: enabled
15:33:56,630 INFO SettingsFactory:213 - Query cache: disabled
15:33:56,630 INFO SettingsFactory:321 - Cache provider: org.hibernate.cache.EhCacheProvider
15:33:56,650 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
15:33:56,660 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
15:33:56,670 INFO SettingsFactory:257 - Echoing all SQL to stdout
15:33:56,670 INFO SettingsFactory:261 - Statistics: disabled
15:33:56,670 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
15:33:56,680 INFO SettingsFactory:279 - Default entity-mode: pojo
15:33:56,781 INFO SessionFactoryImpl:152 - building session factory
15:33:56,801 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/E:/My%20Web/ms-info/WebRoot/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
15:33:58,904 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
15:33:58,904 INFO SessionFactoryImpl:379 - Checking 0 named queries
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor
</value>
放到同一行
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MsNews;SelectMethod=cursor</value>
先不管别的,放到同一行。
我写错了,com.microsoft.jdbc.sqlserver.SQLServerDriver只能提供物理连接。
那个我已经放到一行了<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.jnetdirect.jsql.JSQLDriver</value>
</property>
<property name="url">
<value>jdbc:JSQLConnect://localhost:1433/MsNews</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>***</value>
</property>
</bean>
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>net.sourceforge.jtds.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=test</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>dc</value>
</property>
</bean>
class改一下,把错误贴出来。
16:11:14,929 INFO SettingsFactory:279 - Default entity-mode: pojo
16:11:15,009 INFO SessionFactoryImpl:152 - building session factory
16:11:15,039 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/E:/My%20Web/ms-info/WebRoot/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
16:11:16,992 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
16:11:16,992 INFO SessionFactoryImpl:379 - Checking 0 named queries这是 applicationContext.xml 文件
===================================================================================
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>net.sourceforge.jtds.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:jtds:sqlserver://localhost:1433;DatabaseName=MsNews</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>***</value>
</property>
</bean>
java.lang.NullPointerException
at model.ManagerListDAO.findByProperty(ManagerListDAO.java:81)
at model.ManagerListDAO.findByManager(ManagerListDAO.java:89)
at manager.ManagerLogin.checkLogin(ManagerLogin.java:128)
at manager.ManagerLogin.doPost(ManagerLogin.java:103)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
16:58:15,745 ERROR [ManagerLogin]:260 - Servlet.service() for servlet ManagerLogin threw exception
java.lang.NullPointerException
at model.ManagerListDAO.findByProperty(ManagerListDAO.java:81)
at model.ManagerListDAO.findByManager(ManagerListDAO.java:89)
at manager.ManagerLogin.checkLogin(ManagerLogin.java:128)
at manager.ManagerLogin.doPost(ManagerLogin.java:103)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
------------------------------------------------------------
---------------------------------------------
package model;import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;/**
* Data access object (DAO) for domain model class ManagerList.
* @see model.ManagerList
* @author MyEclipse - Hibernate Tools
*/
public class ManagerListDAO extends HibernateDaoSupport { private static final Log log = LogFactory.getLog(ManagerListDAO.class); //property constants
public static final String MANAGER = "manager";
public static final String MANAGER_PSW = "managerPsw"; @Override
protected void initDao() {
//do nothing
}
public void save(ManagerList transientInstance) {
log.debug("saving ManagerList instance");
try {
getHibernateTemplate().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
public void delete(ManagerList persistentInstance) {
log.debug("deleting ManagerList instance");
try {
getHibernateTemplate().delete(persistentInstance);
log.debug("delete successful");
} catch (RuntimeException re) {
log.error("delete failed", re);
throw re;
}
}
public ManagerList findById( java.lang.Integer id) {
log.debug("getting ManagerList instance with id: " + id);
try {
ManagerList instance = (ManagerList) getHibernateTemplate()
.get("model.ManagerList", id);
return instance;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
}
public List findByExample(ManagerList instance) {
log.debug("finding ManagerList instance by example");
try {
List results = getHibernateTemplate().findByExample(instance);
log.debug("find by example successful, result size: " + results.size());
return results;
} catch (RuntimeException re) {
log.error("find by example failed", re);
throw re;
}
}
public List findByProperty(String propertyName, Object value) {
log.debug("finding ManagerList instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from ManagerList as model where model."
+ propertyName + "= ?";
return getHibernateTemplate().find(queryString, value);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
} public List findByManager(Object manager) {
return findByProperty(MANAGER, manager);
}
public List findByManagerPsw(Object managerPsw) {
return findByProperty(MANAGER_PSW, managerPsw);
}
public ManagerList merge(ManagerList detachedInstance) {
log.debug("merging ManagerList instance");
try {
ManagerList result = (ManagerList) getHibernateTemplate()
.merge(detachedInstance);
log.debug("merge successful");
return result;
} catch (RuntimeException re) {
log.error("merge failed", re);
throw re;
}
} public void attachDirty(ManagerList instance) {
log.debug("attaching dirty ManagerList instance");
try {
getHibernateTemplate().saveOrUpdate(instance);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}
public void attachClean(ManagerList instance) {
log.debug("attaching clean ManagerList instance");
try {
getHibernateTemplate().lock(instance, LockMode.NONE);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
} public static ManagerListDAO getFromApplicationContext(ApplicationContext ctx) {
return (ManagerListDAO) ctx.getBean("ManagerListDAO");
}
}
而参数的能保证传进去了
java.lang.NullPointerException
at model.ManagerListDAO.findByProperty(ManagerListDAO.java:81)那个WARN是正常的 楼主不用管他你出现的问题是这里仔细看你的81行,出现了null错误。应该是你传进去的参数有问题。仔细检查吧。
getHibernateTemplate().loadAll(ManagerList.class);还是出现了java.lang.NullPointerException 的异常
java.lang.NullPointerException仔细检查吧。看看是不是你的类和mapping文件有问题。
---------------------------------------------------------------------
package model;import java.util.Date;
/**
* ManagerList generated by MyEclipse - Hibernate Tools
*/public class ManagerList implements java.io.Serializable {
// Fields private Integer id;
private String manager;
private String managerPsw;
private Date addTime;
private Date lastLoginTime;
// Constructors /** default constructor */
public ManagerList() {
} /** minimal constructor */
public ManagerList(String manager, String managerPsw, Date addTime) {
this.manager = manager;
this.managerPsw = managerPsw;
this.addTime = addTime;
}
/** full constructor */
public ManagerList(String manager, String managerPsw, Date addTime, Date lastLoginTime) {
this.manager = manager;
this.managerPsw = managerPsw;
this.addTime = addTime;
this.lastLoginTime = lastLoginTime;
}
// Property accessors public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
} public String getManager() {
return this.manager;
}
public void setManager(String manager) {
this.manager = manager;
} public String getManagerPsw() {
return this.managerPsw;
}
public void setManagerPsw(String managerPsw) {
this.managerPsw = managerPsw;
} public Date getAddTime() {
return this.addTime;
}
public void setAddTime(Date addTime) {
this.addTime = addTime;
} public Date getLastLoginTime() {
return this.lastLoginTime;
}
public void setLastLoginTime(Date lastLoginTime) {
this.lastLoginTime = lastLoginTime;
}
}---------------------------------------------------------------------这是mapping 文件*********************************************************************
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="model.ManagerList" table="ManagerList" schema="dbo" catalog="MsNews">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="native" />
</id>
<property name="manager" type="java.lang.String">
<column name="Manager" length="20" not-null="true" />
</property>
<property name="managerPsw" type="java.lang.String">
<column name="ManagerPsw" length="32" not-null="true" />
</property>
<property name="addTime" type="java.util.Date">
<column name="addTime" length="23" not-null="true" />
</property>
<property name="lastLoginTime" type="java.util.Date">
<column name="lastLoginTime" length="23" />
</property>
</class>
</hibernate-mapping>*********************************************************************
能帮我看看是哪里出问题了吗?
<column name="lastLoginTime" length="23" />
</property>初步怀疑是Date搞鬼 仔细检查你的源文件吧。
是否有初始化lastLoginTime=new Date();?
加在哪里呢
ManagerList.java
*************************************************************************
package manager;import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;import model.ManagerListDAO;
import unit.methods;public class ManagerLogin extends HttpServlet { private String M_RegName, M_Psw, validator_Code; private HttpSession Hsession; methods mds = new methods();
ManagerListDAO mld = new ManagerListDAO(); /**
* Destruction of the servlet. <br>
*/
@Override
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
} /**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request
* the request send by the client to the server
* @param response
* the response send by the server to the client
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
@Override
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE></TITLE></HEAD>");
out.println(" <BODY>");
out.println(" 非法操作,请返回重试!");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
} /**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to
* post.
*
* @param request
* the request send by the client to the server
* @param response
* the response send by the server to the client
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
@Override
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html");
response.setCharacterEncoding("gb2312");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE></TITLE></HEAD>");
out.println(" <BODY>"); M_RegName = mds.filterStr(request.getParameter("M_RegName"));
M_Psw = mds.filterStr(request.getParameter("M_Psw"));
validator_Code = mds.filterStr(request.getParameter("check_code"));
Hsession = request.getSession(true); out.println(this.checkLogin()); out.println(M_RegName + "<br />" + M_Psw + "<br />" + validator_Code);
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
} /**
* Initialization of the servlet. <br>
*
* @throws ServletException
* if an error occure
*/
@Override
public void init() throws ServletException {
// Put your code here
} private String checkLogin() { String returnStr = null;
List list = mld.findByManager(new String(M_RegName)); if (!list.iterator().hasNext()) {
returnStr = "" + "<script language=\"javascript\">"
+ " parent.showErrorMsg(\"用户名错误!\");" + "</script>";
} else {
list = mld.findByManagerPsw(new String(M_Psw));
if (!list.iterator().hasNext()) {
returnStr = "" + "<script language=\"javascript\">"
+ " parent.showErrorMsg(\"登陆密码错误!\");" + "</script>";
} else {
if (Hsession.getAttribute("ImgCode").equals(validator_Code)) {
returnStr = ""
+ "<script language=\"javascript\">"
+ " parent.document.location.href=\"service/index.jsp\";"
+ "</script>";
} else {
returnStr = "" + "<script language=\"javascript\">"
+ " parent.showErrorMsg(\"请输入正确的图形验证码!\");"
+ "</script>";
}
}
} return returnStr;
}
}