快疯了~~jdbc连接问题~~在线急等

Question

我用spring mvc 做了一个连接数据库的练习，但他到获得连接的时候老抛异常，也导包了，请高人指点
-------------
public class Loginmds implements Mds{
private DataSource dataSource ;

public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
System.out.println(this.dataSource);
}
public void insertaaa(String name) {
System.out.println("insertaaa");
Connection con = null;
java.sql.PreparedStatement psat = null;

try {
System.out.println("------------------->"+con);
con = dataSource.getConnection();
psat = con.prepareStatement("insert into aa (name) values(?)");
psat.setString(1,name);
psat.execute();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} finally{
try {
con.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
--------------------------
这是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.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>
jdbc:mysql://localhost:3306/login
</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>lanpo</value>
</property>
</bean> <bean id="urlMapping"
class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="mappings">
<props>
<prop key="/login.do">LoginAction</prop>
</props>
</property>
</bean> <bean id="viewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass">
<value>
org.springframework.web.servlet.view.InternalResourceView
</value>
</property>
<property name="prefix">
<value>/jsp/</value>
</property>
<property name="suffix">
<value>.jsp</value>
</property>
</bean> <bean id="LoginAction" class="com.aaa.loginAction">
<property name="ok">
<value>ok</value>
</property>
<property name="no">
<value>er</value>
</property>
<property name="l">
<ref bean="mdss"/>
</property>
</bean> <bean id="mdss" class="com.aaa.Loginmds">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean></beans>--------------------------------
抛的异常java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
at com.aaa.Loginmds.insertaaa(Loginmds.java:40)
at com.aaa.loginAction.handleRequest(loginAction.java:28)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
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:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
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(Thread.java:595)

Answer 1

java.sql.SQLException:   No   suitable   driver 
可以肯定是没有驱动.sql的三个驱动包你放在服务器中了,不是指导入了项目中,只有在项目中使用连接的时候才需要你把包导进项目里.这里是用配置文件的,采用dataSource来得到连接的,那么应该把包放入容器中,比如说tomcat,就放在common\lib包里(程序与容器共用)或者server\lib中(容器专有,我不知道记得对不对).

Answer 2

No   suitable   driver 
没有合适的驱动,mysql的三个驱动包都导入了吗?

Answer 3

mysql-connector-java-5.0.5-bin.jar
gg一下这个驱动,
mysql的貌似以前的jar包邮时候就是有问题.
我用的这个,么发现什么不对.

Answer 4

服务器下面的common/lib里面copy一份jdbc的jar包