jdbc链接数据库

打开 mysql

输入 mysql -u root -p

create database cardsystem
 
create table friends(
id int not null primary key,
name char(20),
tel char(20),
address char(20) );
往数据库里面添加数据 
打开 use cardsystem;
insert into friends values(
    -> 0,'aaa','123','222')，

->1,'bbb','121','223');

查询数据库 show databases
查询 库里的表格
select * from friends;9

链接

抛异常写法

package com.jxycu.sky;

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

public class Test {

	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub
		//导入jar包 加载
		//加载驱动类
        Class.forName("com.mysql.jdbc.Driver");
        
        //Connection 数据链接对象 3306是mysql端口号
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cardsystem","root","");
        //数据传输对象
        Statement stm = conn.createStatement();
        
        //容器 resultset 结果集对象
       ResultSet rs =  stm.executeQuery("select * from friends");
       
       while (rs.next()) {
    	   int id = rs.getInt("id");
    	   String name = rs.getString("name");
    	   String tel = rs.getString("tel");
    	   String address = rs.getString("address");
    	   System.out.println(id + " " + name + " " + tel + " " + address);
       }
       
       
       //清理资源
       
       rs.close();
       stm.close();
       conn.close();
       /*conn.close();
        * rs.next();
        * rs.close();
        * stem.close();
        */
        
	}

}

标准写法

package com.jxycu.sky;

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

public class Test01 {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		/*加载驱动类forname
		 * 创建连接connection
		 * 传输对象statement
		 * 结果集对象resultset
		 * *
		 */
		ResultSet rs = null;
		Connection conn = null;
		Statement stm = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			
		    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cardsystem","root","");
			
			stm = conn.createStatement();
			//查询名字为bbb的数据
			rs = stm.executeQuery("select * from friends where name = 'bbb'");
			
			while (rs.next()) {
		    	   int id = rs.getInt("id");
		    	   String name = rs.getString("name");
		    	   String tel = rs.getString("tel");
		    	   String address = rs.getString("address");
		    	   System.out.println(id + " " + name + " " + tel + " " + address);
		       }
		       
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			if (rs != null) {
				try {
					rs.close();
				}catch (SQLException e) {
					e.printStackTrace();
				}
		    }
			if (stm != null) {
				try {
					stm.close();
				}catch (SQLException e) {
					e.printStackTrace();
				}
		    }
			if (conn != null) {
				try {
					conn.close();
				}catch (SQLException e) {
					e.printStackTrace();
				}
		    }
		}
		       

	}

}