package bi.shi.demo01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* @program: bi_shi_test
* @description: 創建一個連接資料庫的工具類
* @author: xin yi
* @create: 2021-09-12 14:30
*/
public class DBUtil {
public static Connection getConnection(){
String driver = "";
String url = "";
String name = "";
String password = "";
Connection connection = null;
try {
Class.forName(driver);
connection = DriverManager.getConnection(url, name, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
}
package bi.shi.demo01;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @program: bi_shi_test
* @description: 寫一段Jdbc連接Oracle的程式,并實作資料查詢
* @author: xin yi
* @create: 2021-09-12 14:33
*/
public class SearchInfo {
public void searchInfo(int id){
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
String sql = "select * from tableName where id = ?";
connection = DBUtil.getConnection();
try {
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1,id);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
String name = resultSet.getString("name");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/299628.html
標籤：其他
上一篇：在Idea中創建maven工程，搭建mybatis框架并完成資料庫表的增刪改查操作
下一篇：資料庫學習之資料更新