JDBC驱动加载

JDBC

1. JDBC流程

   1. 加载驱动:Class.forname(“数据驱动”);
      JDBC所用jar包下载

   2. 获取连接:Connection con = DriverManage.getConnetion();

      • package com.zf.dao;
        import com.zf.pojo.User;
        import com.zf.util.DButil;
        
        import java.sql.Connection;
        import java.sql.PreparedStatement;
        import java.sql.ResultSet;
        import java.sql.SQLException;
        import java.util.List;
        public class UserDaoImple implements UserDaoIf {
                 
            Connection con = null;
            PreparedStatement pst = null;
            ResultSet rs = null;
            @Override
            public boolean addUser(User u) {
                 
                try {
                 
                    //1.加载驱动  2.获取连接
                    con = DButil.getCon();
                    //3.获取执行sqlstatement对象
                    pst = con.prepareStatement("insert into user values(null,?,?,?,?,?,?,?)");
                    pst.setString(1,u.getUserName());
                    pst.setString(2,u.getPassWord());
                    pst.setString(3,u.getName());
                    pst.setInt(4,u.getAge());
                    pst.setString(5,u.getSex());
                    pst.setString(6,u.getPhone());
                    pst.setString(7,u.getAddress());
                    //4.执行sql语句
                    int i = pst.executeUpdate();
                    if(i>0){
                 
                        return