1.需要引入druid。jar包
2.写获取datasource的类
import com.alibaba.druid.pool.DruidDataSource;
import javax.sql.DataSource;
public class GetDataSourceUtil {
public static DataSource getdatacource() {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setUrl("jdbc:mysql://localhost:3306/a53");
dataSource.setUsername("root");
dataSource.setPassword("mysql");
return dataSource;
}
}
3.用刚才的datasource类获取datasource
public static void main(String[] args) {
jdbc_selectone();
}
public static void jdbc_selectone() {
Connection connection = null;
PreparedStatement pstat = null;
ResultSet results = null;
try {
DataSource dataSource=GetDataSourceUtil.getdatacource();
connection=dataSource.getConnection();
pstat = connection.prepareStatement("select * from a53");
results = pstat.executeQuery();
while (results.next()) {
// 获得每条数据,中name属性的值
System.out.println("name:" + results.getString(3));
// 获得每条数据中,第1个属性的值(下标从1开始)
// System.out.print("id值:" + results.getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
}
}