JDBC-MySQL连接数据库

//MySQL连接数据库

package database;

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

public class JdbcMySql {
	public static void main(String[] args) {
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		
		try {
			//加载驱动 MySql
			Class.forName("com.mysql.jdbc.Driver");
			//创建连接
			conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8",   
                    "root", "admin");
			//获取指令对象 
			st = conn.createStatement();
			//发送指令,并返回结果  
			rs = st.executeQuery("select * from student");
			//获取结果集
			while(rs.next()){
				System.out.println("id:"+rs.getInt(1));
				System.out.println("username:"+rs.getString(2));
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try{
				if (rs != null) {   
                    rs.close();   
                }   
                if (st != null) {   
                    st.close();   
                }   
                if (conn != null) {   
                    conn.close();   
                }   
			}catch(SQLException e){
				e.printStackTrace();
			}
		}
	}
}

 

   //数据  

create table student(
    id int auto_increment primary key,
    username varchar(10)
)engine=innodb default charset=utf8
insert into student(username) values('李四');
insert into student(username) values('张三');
insert into student(username) values('王五');
insert into student(username) values('赵六');
insert into student(username) values('林奇');