JDBC连接数据库代码

//连接是需要导包   http://pan.baidu.com/s/1o6nyuOa 
/*配合数据库建立表

create database day14 character set utf8 collate utf8_general_ci;

use day14;

create table users(
id int primary key,
name varchar(40),
password varchar(40),
email varchar(60),
birthday date
);
insert into users(id,name,password,email,birthday) values

(1,'zs','123456','[e-mail]','1980-12-04');
insert into users(id,name,password,email,birthday) values

(2,'lisi','123456','[e-mail]','1981-12-04');
insert into users(id,name,password,email,birthday) values

(3,'wangwu','123456','[e-mail]','1979-12-04');

*/
package cn.itcast.demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Demo1 {
    public static void main(String[] args) throws Exception {

        String url="jdbc:mysql://localhost:3306/day14";
        String username="root";
        String password="seeker";

        //1.加载驱动
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());

        //2.获取与数据库的连接,导接口包，程序的维护性好，
        Connection conn = DriverManager.getConnection(url, username, password);

        //3.获得发送语句的statement对象
        Statement st=conn.createStatement();

        //4.向数据库发送sql,并获得结果集（表格方式封装）
        String sql="select id,name,password,email,birthday from users";
        ResultSet rs=st.executeQuery(sql);

        //5.取出结果集的数据
        while(rs.next())//往后移动，指向具体的数据行
        {
            System.out.println("id=" + rs.getObject("id"));
            System.out.println("name=" + rs.getObject("name"));
            System.out.println("password=" + rs.getObject("password"));
            System.out.println("email=" + rs.getObject("email"));
            System.out.println("birthday=" + rs.getObject("birthday"));
        }
        //6.关闭连接、与数据库交互的对象也释放掉
        rs.close();
        st.close();
        conn.close();
    }
}