当前位置:Gxlcms > mysql > 连接数据库模版

连接数据库模版

时间:2021-07-01 10:21:17 帮助过:40人阅读

package com.mingxin.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import com.mysql.jdbc.ResultSet;import com.mysql.jdbc.Statement;public class ConnectionUtils {private static String driver = com

package com.mingxin.util;

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

import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;

public class ConnectionUtils {

	private static String driver = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://127.0.0.1:3306/db_mx";
	private static String user = "root";
	private static String password = "123456";
	private static Connection conn = null;
	
	static{
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			System.out.println("驱动加载失败..");
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection(){
		try {
			conn = DriverManager.getConnection(url, user, password);
			if(!conn.isClosed()){
				System.out.println("Successed connecting to the Database...");
			}
		} catch (SQLException e) {
			System.out.println("数据库连接失败...");
			e.printStackTrace();
		}
		return conn;
	}
	
	public static void main(String[] args) {
//		getConnection();
		try {
			Statement statement = (Statement) conn.createStatement();
			String sql = "select * from user";
			ResultSet rs = (ResultSet) statement.executeQuery(sql);
			String email = null;
			String name = null;
			String phone = null;
			while(rs.next()){
				email = rs.getString("u_email");
				name = rs.getString("u_name");
				phone = rs.getString("u_phone");
				System.out.println("u_email=" + email + " ___u_name=" + name + " ____phone=" + phone);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

人气教程排行