<bean id="datasoure" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mysql"></property>
<property name="username" value="root"></property>
</bean>
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mysql"></property>
<property name="username" value="root"></property>
</bean>
1.在配置文件里面<data-source>
<data-source>
<set-perty property="url" value="jdbc:mysql://localhost:3306/mysql"/>
<set-perty property="username" value="你登陆数据库的用户名"/>
和上面一样设password,dirverClass等属性
就配置好了
2.用jdbc来配置给你个例子
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class hello{
public static void main(String [] args)
{
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/test";
String user="root";
String password="121212";
try
{
Class.forName(driver);
}catch(ClassNotFoundException ce){
System.out.println(ce);
}
try{
Connection con = DriverManager.getConnection(url,user,password);
Statement s=con.createStatement();
ResultSet rs=s.executeQuery("select * from account");
while(rs.next()){
System.out.println(rs.getString("Name")+"\t");
System.out.println(rs.getDouble("Amount")+"\t");
}
rs.close();
s.close();
con.close();
}
catch(SQLException ce){System.out.println(ce);}
}
}
千万别忘了把包导进入
你装msn没有发给我我帮你看一下
发到我邮箱里smhwell"163.com