Java–代碼之簡潔

用於對資料庫的添，刪，改，查的類，不論任何SQL語句都可以，覺得好的就流個言。THANKS！

 

 

package com.project.database;<br />import java.io.UnsupportedEncodingException;<br />import java.sql.Connection;<br />import java.sql.DriverManager;<br />import java.sql.PreparedStatement;<br />import java.sql.ResultSet;<br />import java.sql.SQLException;<br />import com.project.utils.EncodingManager;<br />public class OperatorDataBase {<br /> private Connection connection = null;<br /> private PreparedStatement pst = null;<br /> EncodingManager em = new EncodingManager();<br /> private Connection createConnection() throws ClassNotFoundException, SQLException<br /> {<br /> Class.forName("com.mysql.jdbc.Driver");<br /> connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/project","root","lichaoever");<br /> return this.connection;<br /> }</p><p> /**<br /> * 執行查詢操作<br /> * @param sql<br /> * @param objects<br /> * @return<br /> * @throws SQLException<br /> * @throws ClassNotFoundException<br /> */<br /> public ResultSet executeQuery(String sql , Object...objects) throws SQLException, ClassNotFoundException<br /> {<br /> if(connection == null)this.createConnection();<br /> pst = connection.prepareStatement(sql);<br /> this.bindParameter(pst, objects);<br /> return pst.executeQuery();<br /> }</p><p> /**<br /> * 執行更新，修改操作<br /> * @param sql<br /> * @param objects<br /> * @return<br /> * @throws ClassNotFoundException<br /> * @throws SQLException<br /> */<br /> public int executeupdate(String sql , Object...objects) throws ClassNotFoundException, SQLException<br /> {<br /> if(connection == null)this.createConnection();<br /> pst = connection.prepareStatement(sql);<br /> this.bindParameter(pst, objects);<br /> return pst.executeUpdate();<br /> }</p><p> /**<br /> * 綁定參數<br /> * @param pst<br /> * @param objects 參數列表<br /> * @throws SQLException<br /> */<br /> public void bindParameter(PreparedStatement pst , Object...objects) throws SQLException<br /> {<br /> if(objects == null)return;<br /> int i = 1;<br /> for(Object object : objects)<br /> {<br /> pst.setObject(i ++, object);<br /> }<br /> }</p><p> public void close() throws SQLException<br /> {<br /> this.close(null);<br /> }</p><p> public void close(ResultSet rs) throws SQLException<br /> {<br /> if(rs != null)<br /> {<br /> rs.close();<br /> rs = null;<br /> }<br /> if(pst != null)<br /> {<br /> pst.close();<br /> pst = null;<br /> }<br /> if(connection != null)<br /> {<br /> connection.close();<br /> connection = null;<br /> }</p><p> }<br />}