JDBC六步驟：
1、注冊(cè)數(shù)據(jù)庫(kù)驅(qū)動(dòng)
2读宙、連接數(shù)據(jù)庫(kù)對(duì)象
3璧亚、獲得執(zhí)行sql語(yǔ)句
4谴供、執(zhí)行SQL語(yǔ)句
5能扒、處理執(zhí)行后的結(jié)果
6佣渴、 釋放資源
public class JDBCTest {
public static void main(String[] args){
Connection conn = null;
PreparedStatement ps = null;
try {
//1:j加載驅(qū)動(dòng)
Class.forName("com.mysql.jdbc.Driver");
//2：連接數(shù)據(jù)庫(kù)
conn = getCollection();
//3、獲得執(zhí)行sql語(yǔ)句
String sql = "SELECT * FROM changjiang_account";
//4初斑、執(zhí)行SQL語(yǔ)句
ps = conn.prepareStatement(sql);
ResultSet resultSet = ps.executeQuery();
//5辛润、處理執(zhí)行后的結(jié)果
String result = doResultSet(resultSet);
System.out.println(result);
}catch (Exception e){
if (ps != null){
try {
ps.close();
}catch (Exception e1){
}
}
if (conn != null){
try {
conn.close();
}catch (Exception e2){
}
}
}
}
public static Connection getCollection(){
try {
String url = "jdbc:mysql://xxx.xxx.xxx:3306/xxx?characterEncoding=utf8";
String name = "xxxx";//將要連接數(shù)據(jù)庫(kù)的賬戶(hù)
String password = "xxxxxx";//將要連接數(shù)據(jù)庫(kù)的密碼
return DriverManager.getConnection(url, name, password);
}catch (SQLException e){
System.out.println("獲取Connection失敗");
}
return null;
}
public static String doResultSet(ResultSet resultSet) throws SQLException {
if (resultSet == null){
return "";
}
StringBuffer stringBuffer = new StringBuffer();
while (resultSet.next()){
long id = resultSet.getLong("id");
stringBuffer.append(id + " ");
}
return stringBuffer.toString();
}
}
