以連接SqlServer2008 R2為例?

import java.sql.*;public final class JdbcUtils {private String url;private String user;private String password;public JdbcUtils(String url,String user,String password){this.url = url;this.user = user;this.password = password;}static{try {//加載驅動,原理是反射Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//Class.forName("oracle.jdbc.driver.OracleDriver");// 加載Oracle驅動程序 } catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/**** 根據SQL進行查詢操作* @param sql* @throws SQLException*/public void queryResult(String sql) throws SQLException{try(//獲取數據庫鏈接Connection conn = DriverManager.getConnection(url, user, password);//使用Connection創建一個Statement對象Statement stmt = conn.createStatement();//執行sql語句,返回查詢結果集ResultSet rs = stmt.executeQuery(sql)){ while(rs.next()){System.out.println("Id=" + rs.getLong(1) + ";ProductName=" + rs.getString(2));}}}/**** 根據SQL進行update操作* @param sql* @return* @throws SQLException*/public int updateResult(String sql) throws SQLException{try(//獲取數據庫鏈接Connection conn = DriverManager.getConnection(url, user, password);//使用Connection創建一個Statement對象 Statement stmt = conn.createStatement()){//返回執行sql的行數return stmt.executeUpdate(sql);}}/*** 使用execute方法執行SQL語句* @param sql* @throws SQLException*/public void executeSql(String sql) throws SQLException{try(Connection conn = DriverManager.getConnection(url, user, password);Statement stmt = conn.createStatement()){//判斷執行后是否有結果集合boolean hasResultSet = stmt.execute(sql);if(hasResultSet){ResultSet rs = stmt.getResultSet();ResultSetMetaData rsmdData = rs.getMetaData();int columnCount = rsmdData.getColumnCount();while(rs.next()){for (int i = 0; i < columnCount; i++) {System.out.print(rs.getString(i + 1) + "\t");}System.out.print("\n");}}else {//返回該SQL影響的行數int count = stmt.getUpdateCount();System.out.println("受影響的行數是" + count);}}} }

?

使用方法?

public static void main(String[] args) {String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=DailyProductionDB";//String oracleUrl = jdbc:oracle:thin:@127.0.0.1:1521:ecologyString user = "sa";String password = "123";JdbcUtils cs = new JdbcUtils(url, user, password);try {cs.queryResult("SELECT * FROM dbo.Product");} catch (SQLException e) {e.printStackTrace();}}

?

總結

以上是生活随笔為你收集整理的JDBC最基本CRUD操作工具类的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。