java 访问 数据库_java访问数据库数据

package SqlData;

import java.io.FileInputStream;

import java.io.FileReader;

import java.io.Reader;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

import D.Demo;

public class ConnectTest {

public static void main(String[] args) {

ConnectTest test = new ConnectTest();

test.demo2();

}

private void demo1() {

Connection conn = null;

PreparedStatement stmat = null;

ResultSet rs = null;

BasicDataSource dataSource = new BasicDataSource();

dataSource.setDriverClassName("com.mysql.jdbc.Driver");

dataSource.setUrl("jdbc:mysql://localhost:3306/tempdb");

dataSource.setUsername("root");

dataSource.setPassword("8888");

try {

conn = dataSource.getConnection();

String sql = "select * from sort";

stmat = conn.prepareStatement(sql);

rs = stmat.executeQuery();

while (rs.next()) {

System.out.println(rs.getString("sname"));

}

} catch (Exception e) {

// TODO: handle exception

} finally {

}

}

private void demo2() {

Connection conn = null;

PreparedStatement stmat = null;

ResultSet rs = null;

Properties properties = new Properties();

try {

properties.load(new FileReader("db.properties"));

BasicDataSource dataSource=new BasicDataSource();

String driver=properties.getProperty("driver");

String url=properties.getProperty("url");

String user=properties.getProperty("user");

String pwd=properties.getProperty("password");

dataSource.setDriverClassName(driver);

dataSource.setUrl(url);

dataSource.setUsername(user);

dataSource.setPassword(pwd);

conn=dataSource.getConnection();

String sql="select * from sort";

stmat=conn.prepareStatement(sql);

rs=stmat.executeQuery();

while (rs.next()) {

System.out.println(rs.getString("sname"));

}

} catch (Exception e) {

// TODO: handle exception

}

}

}