日期:2014-05-18  浏览次数:20737 次

继续STRUTS下,数据源配置问题,昨天那个帖子被人恶意加了一大段广告,气愤啊!!
<!--   这里是关于连接池的配置,使用SQLSERVER2000那个TYPE包是我自己下载打进去的,我用的环境是JDK1.6+TOMCAT6.X+ECLIPSE3.2.2   -->


<?xml   version= "1.0 "   encoding= "UTF-8 "?>
<!DOCTYPE   struts-config   PUBLIC   "-//Apache   Software   Foundation//DTD   Struts   Configuration   1.2//EN "   "http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd ">

<struts-config>

<!--   Data   Sources   Configuration   -->
<data-sources>
<data-source   key= "sqlserver "   type= "org.apache.commons.dbcp.BasicDataSource ">
<set-property   property= "driverClassName "   value= "com.microsoft.jdbc.sqlserver.SQLServerDriver "/>
<set-property   property= "url "   value= "jdbc:microsoft:sqlserver://localhost:1433;databasename=user "/>
<set-property   property= "maxActive "   value= "5 "/>
<set-property   property= "user "   value= "sa "/>
<set-property   property= "password "   value= "sa "/>
<set-property   property= "autoCommit "   value= "true "/>
</data-source>
</data-sources>

<!--   ActionForm   Configuration-->
<form-beans>
<form-bean   name= "formBean1 "   type= "user.UserForm "> </form-bean>
</form-beans>

<!--   GlobalForward   Configuration   -->
<global-forwards>
<forward   name= "successed "   path= "/right.jsp "/>
<forward   name= "failed "   path= "/error.jsp "/>
</global-forwards>

<!--   Action   Configuration   -->
<action-mappings>
<action   path= "/logincheck "   type= "user.LoginCheck "   name= "formBean1 "   scope= "request "   input= "/right.jsp "/>
</action-mappings>
</struts-config>


DBUSER类,具体的业务模型
package   user;
import   javax.sql.*;
import   java.sql.*;
public   class   DBUser  
{
DataSource   dataSource;
public   DBUser(DataSource   dataSource)
{
this.dataSource   =   dataSource;
}
public   boolean   checkUser(String   username,String   password)   throws   Exception
{
Connection   connection   =   null;
String   StrSql;
ResultSet   rs;
boolean   result   =   false;
StrSql   =   "select   *   from   users   where   username= ' "   +   username   +   " 'and   password= ' "   +   password   +   " ' ";
try
{
connection   =   dataSource.getConnection();
Statement   stmt   =   connection.createStatement();
rs   =   stmt.executeQuery(StrSql);
if(rs.next())
{
result   =   true;
}
}
catch(SQLException   ex)
{
ex.printStackTrace();
}
finally
{
if(connection   !=