java链接mysql数据库

4步

• 加载驱动，有驱动才有链接
• 获取链接，通过驱动创建链接，有链接才有代理。
• 通过链接创建代理
• 结果集用来主要来接受select语句的查询结果。

package databasetool;

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

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class DBTool {
	private static final String driverManger = "com.mysql.jdbc.Driver";
	private static Connection conn;
	private static Statement stmt;
	private static ResultSet rs;// 结果集导入的是sql的包

	public static Connection getconn() {// 获取链接
		conn = null;
		String url = "jdbc:mysql://localhost:3306/shopdb";
		String user = "root";
		String password = "passwd";
		try {
			Class.forName(driverManger);
			try {
				conn = (Connection) DriverManager.getConnection(url, user, password);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}

	/*
	 * 增删改操作
	 */
	public static int update(String sql) {
		conn = getconn();
		int line = 0;
		try {
			stmt = (Statement) conn.createStatement();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			line = stmt.executeUpdate(sql);// 代理执行语句，返回影响的行数。
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return line;
	}

	public static ResultSet query(String sql) {
		conn = getconn();
		rs = null;
		try {
			stmt = (Statement) conn.createStatement();
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;
	}

	public static void close() {
		try {
			if (rs != null) {
				rs.close();
			}
			if (stmt != null) {
				stmt.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}