beantest.java

Spring2.0宝典

/*******************************************************************
<br>Copyright (C), 2004-2006, yeeku.H.Lee
<br>Program Name:BeanTest.java
<br>Author:yeeku.H.lee [e-mail]
<br>Version:1.0
<br>This program is protected by copyright laws.
<br>Date: 2005-9-27
*******************************************************************/

package lee;

import javax.sql.DataSource;
import java.sql.Connection;
import org.springframework.jdbc.datasource.DriverManagerDataSource;


import org.springframework.jdbc.datasource.DataSourceUtils;

public class BeanTest
{
    public static void main(String[] args)throws Exception
    {
        DriverManagerDataSource ds = new DriverManagerDataSource(); 
        ds.setDriverClassName("com.mysql.jdbc.Driver");
        ds.setPassword("32147");
        ds.setUrl("jdbc:mysql://localhost:3306/j2ee");
        ds.setUsername("root");
		Connection conn = DataSourceUtils.getConnection(ds);
        System.out.println(conn);
		java.sql.Statement stmt = conn.createStatement();
		stmt.execute("insert into mytable values('wnxxx')");
        conn.close();
        System.out.println(DataSourceUtils.getConnection(ds));
        System.out.println(DataSourceUtils.getConnection(ds));

    }
}