mysqltest.java

张新曼 精通JSP Web 开发技术与典型应用 随书光盘源码

package at3;
import java.util.*;
import java.sql.*;
import javax.sql.*;


public class MySQLTest {
	private DataSource dataSource;//数据源变量；

	public DataSource getDataSource() {
		return dataSource;
	}

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

	public String TestMySQL(){
		try {
		   Connection conn=dataSource.getConnection();
		   if (conn!=null) 
			  return "Spring-MySQL测试成功!";
		   }
		catch(Exception e)
		 {
			e.printStackTrace();
			return "Spring-MySQL测试失败!";
		 }
		return null;
		}
	}