jdbc多种实现方式

1，驱动加载

//注册驱动
//DriverManager.registerDriver(new Driver());此方法被淘汰
Class.forName("com.mysql.jdbc.Driver");

　第一种方法的缺点：

（1）依赖jar包

（2）驱动注册了两次（在 Driver（）里面注册了一次）

2.获取链接

//建立连接2
        public static Connection  getConn2() throws SQLException
        {
                Properties info= new Properties();
                info.setProperty("user", "root");
                info.setProperty("password", "123");
                conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day06",info);
                
                return conn;
        }
        
        //建立连接3
                public static Connection  getConn3() throws SQLException
                {
                        Connection cnn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day06？user=root&password=123");
                        return conn;
                }

//获取链接
        conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day06","root","247418");

　　建立连接的三种方式：第三种方式最常用

3.对数据库的操作

//对数据库的操作--选择
        public static ResultSet QueryTest() throws Exception
        {
                rs=sta.executeQuery("select * from users");
                return rs;
                
        }
        
        //对数据库的操作--插入
        public static int insertTest() throws Exception
        {
                int num_i=sta.executeUpdate("insert into users values(005,'zhansan','123','zs@sina.com','1980-12-04')");
                return num_i;
                
        }
        //对数据库的操作--删除
        public static int deleteTest() throws Exception
        {
                int num_d=sta.executeUpdate("delete from users where ");
                return num_d;
                
        }
        //对数据库的操作--更新
        public static int updateTest() throws Exception
        {
                int num_d=sta.executeUpdate("update users set name='ooo' where ");
                return num_d;
                
        }

　　4.对结果的操作

//对结果的操作1
                public static void QueryRes1() throws Exception
                {
                        while(rs.next())
                        {
                                User u=new User();
                                u.setId(rs.getInt("id"));
                                u.setName(rs.getString("name"));
                                u.setPassword(rs.getString("password"));
                                u.setEmail(rs.getString("email"));
                                u.setBirthday(rs.getDate("birthday"));
                                al.add(u);
                        }
                        
                }
                
                //对结果的操作2
                public static void QueryRes2() throws Exception
                {
                        while(rs.next())
                        {
                                System.out.println(rs.getObject(1));
                                System.out.println(rs.getObject(2));
                                System.out.println(rs.getObject(3));
                                System.out.println(rs.getObject(4));
                                System.out.println(rs.getObject(5));
                                System.out.println("-----------------");
                        }
                        
                }

package songyan.jdbc.entity;

import java.util.Date;

public class User {
        private int id;
        private String name;
        private String password;
        private String email;
        private Date birthday;
        
        public int getId() {
                return id;
        }
        public void setId(int id) {
                this.id = id;
        }
        public String getName() {
                return name;
        }
        public void setName(String name) {
                this.name = name;
        }
        public String getPassword() {
                return password;
        }
        public void setPassword(String password) {
                this.password = password;
        }
        public String getEmail() {
                return email;
        }
        public void setEmail(String email) {
                this.email = email;
        }
        public Date getBirthday() {
                return birthday;
        }
        public void setBirthday(Date birthday) {
                this.birthday = birthday;
        }
        
        
        
        
}