package JDBCTest;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestOperation { Connection con; Statement stmt; ResultSet rs; //可能有問題 private String m_JDBCDrive="com.mysql.jdbc.Driver"; private String m_JDBCConnectionURL="jdbc:mysql://127.0.0.1:3306/xsxx"; private String m_userID="root"; private String m_password="1234"; public TestOperation(){ try { Class.forName(m_JDBCDrive).newInstance(); System.out.println("裝載驅動成功"); } catch (InstantiationException e) { System.out.println("裝載驅動失敗"); } catch (IllegalAccessException e) { System.out.println("裝載驅動失敗"); } catch (ClassNotFoundException e) { System.out.println("裝載驅動失敗"); } } public boolean connect(){ try { con=DriverManager.getConnection(m_JDBCConnectionURL,m_userID,m_password); System.out.println("數據庫連接正確"); } catch (SQLException e) { System.out.println("數據庫連接失敗"); return false; } return true; } public ResultSet getResult(String strSQL){ try { rs=stmt.executeQuery(strSQL); return rs; } catch (SQLException e) { System.out.println("執行SQL失敗"); return null; } } public boolean updateSql(String strSQL){ try { stmt.executeUpdate(strSQL); con.commit(); return true; } catch (SQLException e) { System.out.println("執行SQL語句錯誤"); return false; } } public boolean insertSql(String strSQL){ try { stmt.executeUpdate(strSQL); con.commit(); return true; } catch (SQLException sqle) { System.out.println("insertSql():執行SQL語句錯誤"); return false; }} public void disconnect(){ try { if(con!=null){ con.close(); con=null; } } catch (SQLException e) { System.out.println("關閉數據庫失敗"); } } public static void main(String[] args) { TestOperation test=new TestOperation(); String sql1="insert into student(user,password,ID) ?values('1002','admin2','admin2')"; String sql2; ResultSet rs; if(test.connect()){ if(test.insertSql(sql1)){ System.out.println("插入成功"); sql2="select * from student"; if(test.getResult(sql2)!=null){ rs=test.getResult(sql2); try{ while(rs.next()){ System.out.println(rs.getInt(1)); } }catch(SQLException e){ e.printStackTrace(); } } } test.disconnect(); } }