JAVA JDBC连接数据库

一.jdbc访问套路

记得要导入jar包以及找到连接的相关信息

导入jar包：https://mp.csdn.net/mp_blog/creation/editor/119171345

找到连接的相关信息：https://mp.csdn.net/mp_blog/creation/editor/119668152

1.加载驱动包

Class.forName("com.mysql.jdbc.Driver");

2.得到数据库连接（桥）

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/crm", "root", "123456");

3.得到statement接口指向的对象，发生sql语句到数据库中执行，并返回结果集

Statement state =conn.createStatement();
String sqlAll="SELECT deptno,dname,loc FROM dept";
ResultSet rs=state.executeQuery(sqlAll);

4.循环遍历结果

		while (rs.next()) {
			int deptno=rs.getInt("deptno");
			String dname=rs.getString("dname");
			String loc=rs.getString("loc");
			System.out.println(deptno+"\t"+dname+"\t"+loc);
			
		}

5.关闭资源

		rs.close();
		state.close();
		conn.close();

6.代码整合

package com.gongsi.cn.oa.work811.test1;

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

//JDBC访问套路
public class TestJdbc {
	//查询数据库某种表的全部内容
	public static void main(String[] args) throws Exception {
		//1.加载驱动包
		Class.forName("com.mysql.jdbc.Driver");
		//2.得到数据库连接（桥）
		Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/crm", "root", "123456");
		//3.得到statement接口指向的对象，发生sql语句到数据库中执行，并返回结果集
		Statement state =conn.createStatement();
		String sqlAll="SELECT deptno,dname,loc FROM dept";
		//发生sql语句到数据库中执行，并返回结果集
		ResultSet rs=state.executeQuery(sqlAll);
		//4.循环遍历结果
		while (rs.next()) {
			int deptno=rs.getInt("deptno");
			String dname=rs.getString("dname");
			String loc=rs.getString("loc");
			System.out.println(deptno+"\t"+dname+"\t"+loc);
			
		}
		//5.关闭资源
		rs.close();
		state.close();
		conn.close();
	}

}

 二.jdbc的异常处理

原来的代码选中——右键——Surround With

package com.gongsi.cn.mycrm;

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

public class TestJdbcException {
	public static void main(String[] args) {

		Connection conn = null;

		Statement state = null;
		ResultSet rs = null;

		try {

			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/crm", "root", "123456");
			state = conn.createStatement();
			String sqlAll = "SELECT deptno,dname,loc FROM dept";
			rs = state.executeQuery(sqlAll);
			while (rs.next()) {
				int deptno = rs.getInt("deptno");
				String dname = rs.getString("dname");
				String loc = rs.getString("loc");
				System.out.println(deptno + "\t" + dname + "\t" + loc);

			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		// 5.关闭资源 这样抛异常性能好，先判断有没有鸟，再撒网
		try {
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			state.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}