java.sql.SQLException: No suitable driver
- 将jdbc驱动复制一份进jre目录下lib/ext文件夹中
test2
- 这个主要是因为必须要将action让spring来管理,所以在structs的配置文件中应当修改action的class为spring中的bean的ID,同时,name和class不能同名,否则会出问题
例如:
applicationContext.xml
<bean id="LoginAction" class="exam.action.LoginAction" scope="prototype">
<property name="userDAO">
<ref bean="UserDAO" />
</property>
</bean>
<bean
id="UserDAO" class="exam.user.UserDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
struts.xml
<constant name="struts.objectFactory" value="spring" />
<package name = "default" extends = "struts-default" namespace="/">
<action name = "log">
<result>/Login.jsp</result>
</action>
<action name="Login" class="LoginAction">
<result name="SUCCESS">/index.jsp</result>
<result name="ERROR">/Error.jsp</result>
</action>
</package>
数据库存取中文乱码
数据库:
CREATE DATABASE LFSQL
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
USE LFSQL;
CREATE TABLE LOGIN (
ID INT AUTO_INCREMENT PRIMARY KEY,
USERNAME TEXT,
PASSWORD TEXT
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
applicationContext.xml
<property name="url" value="jdbc:mysql://XXXXXXX/exam?useUnicode=true&characterEncoding=utf-8"> </property>
<property name="username" value="root"></property>
<property name="password" value="XXXXXXX"></property>
hibernate could not open connection —2016.5.13
说来也是奇葩,我在本地运行得好好的项目,放到服务器上怎么说报错就报错呢,于是乎我想起了在windows上也报过这个错误,当时我是把jdbc的驱动复制到tomcat的lib文件夹中就可以了,于是乎在ubuntu上我也这么操作,结果GG,苦思冥想之后我想起来要在jre的lib中也放驱动!!!然后我就把驱动丢到
/usr/lib/jvm/default-java/jre/lib/ext/
里面就可以了