JDBC6大部以及JDBC通用添加修改任意的sql数据

来源：互联网发布：疯狂java讲义下载编辑：程序博客网时间：2024/06/10 00:35

JDBC:
1.6大部
1.加载数据库供应商提供的驱动
Class.forName("com.mysql.jdbc.Driver");
2.获取数据库连接对象
Connection conn =DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test",
"root",
"1234567890");
3.获取处理命令
Statement stmt = conn.createStatement();
4.执行sql命令
boolean f = stmt.execute(add());
5.处理执行结果
System.out.println(f);
6.回收资源
stmt.close();
conn.close();

package oop1;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.List;import com.softeem.ooptest.DBConnection;public class VoteUtils {public static boolean execUpdate(Connection conn,String sql,Object...objs){try {PreparedStatement ps = conn.prepareStatement(sql);for(int i =0;i<objs.length;i++){ps.setObject(i+1,objs[i]);}int i =ps.executeUpdate();return i>0 ? true:false;s} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return false;}public  static <T>List<T> execQuery(String sql,CallBack<T> call,Object...params){Connection conn =DBConnection.getConn();PreparedStatement ps = null;try {ps =conn.prepareStatement(sql);for(int i =0;i<params.length;i++){ps.setObject(i+1, params[i]);}ResultSet rs = ps.executeQuery();return call.getDatas(rs);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return null;}public interface CallBack<T>{public List<T> getDatas(ResultSet rs);}}

阅读全文

0 0