~~~ package cy.db; import java.util.*; import java.sql.*; public class Conn { PreparedStatement ps=null; Connection ct=null; //聲明Connection對象 ResultSet rs=null;//聲明ResultSet類，用來存放獲取的結果集！！ String driver="com.mysql.jdbc.Driver"; String url="jdbc:mysql://122.14.200.136:3306/javadb"; String user="root"; String passwd="6a133f0024"; public Conn() { try { Class.forName(driver); ct=DriverManager.getConnection(url,user,passwd); } catch (Exception e) {} } public ResultSet query(String sql,String []paras) { try { ps=ct.prepareStatement(sql); for(int i=0;i<paras.length;i++) { ps.setString(i+1, paras[i]); } rs=ps.executeQuery(); } catch (Exception e) {} return rs; } public void close() { try { if(rs!=null) rs.close(); if(ps!=null) ps.close(); if(ct!=null) ct.close(); } catch (Exception e) {} } } ~~~