myjdbc.java

来自「本人上传的这段数据库连接源码是一段移植性比较高的代码！」· Java 代码 · 共 54 行

package testclass;

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


public class myjdbc {
    static {
        try {
            Class.forName("org.gjt.mm.mysql.Driver"); //加载MYSQL JDBC驱动程序
            System.out.println("Success loading Mysql Driver!");
        } catch (Exception e) {
            System.out.print("Error loading Mysql Driver!");
            e.printStackTrace();
        }
    }

    public myjdbc() {

    }

    public Connection getConnection() {
        Connection connect = null;
        try {
            connect = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/ericdb", "root", "");
            //  连接URL为 jdbc:mysql//服务器地址/数据库名
            //  后面的2个参数分别是登陆用户名和密码
            System.out.println("Success connect Mysql server!");

        } catch (Exception e) {
            System.out.print("get data error!");
            e.printStackTrace();
        }
        return connect;
    }

    public ResultSet getResultSet(String strSql) {
        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = this.getConnection().createStatement();
            rs = stmt.executeQuery(strSql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return rs;
    }

   
}