MySQL创建连接原始方法

2019独角兽企业重金招聘Python工程师标准>>>

 MySQLUtils.java

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

/**
 * 
 * @author mistylinux
 *
 */
public class MySQLUtils {
	/**
	 * 
	 * @param source
	 *            传入要查询的数据库
	 * @param account
	 *            传入数据库用户名
	 * @param password
	 *            传入数据库密码
	 * @return 返回结果集
	 * @throws Exception
	 */
	public static Statement getStatement(String source, String account, String password) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		Connection ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + source, account, password);
		return ct.createStatement();
	}
}

Test.java

import java.sql.ResultSet;
import java.sql.Statement;

import com.mistyos.util.MySQLUtils;

public class Test {

    public static void main(String[] args) throws Exception {
	String sql="select username,password from user";
	Statement st = MySQLUtils.getStatement("db_source", "root", "xxx");
	ResultSet eq = st.executeQuery(sql);
	while (eq.next()) {
	    System.out.println("用户名:"+eq.getString("username")+" "+
		    	       "密码:"+eq.getString("password"));
	}
    }
}

 

转载于:https://my.oschina.net/mistylinux/blog/1476346