展开全部
//建立数据库连接类
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Utilities {
public static Connection getConnection() {
Connection con = null;
try {
Class.forNam("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection ("jdbc:mysql://localhost:8080/auction", "scott", "tiger");//这里是数据库连接主机的地32313133353236313431303231363533e78988e69d8331333238643539址数据库端口库名,帐户密码
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
}
}
然后通过这个连接来提取数据库中的数据 实现业务流程
package auction.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import auction.dao