connect.java

学习Java 非常好的电子 讲义。欢迎大家下载。学习。

package javabean;


import java.sql.*;

public class Connect
{

    String url;
    String sql;
    Connection conn;
    Statement stmt;
    ResultSet rs;

    public Connect()
    {
        url = "jdbc:mysql://localhost/testdb?useUnicode=true&characterEncoding=GBK";
        rs = null;
    }

    public ResultSet executeQuery(String s)
    {
        try
        {
            Class.forName("org.gjt.mm.mysql.Driver");
            conn = DriverManager.getConnection(url, "", "");
            stmt = conn.createStatement();
            rs = stmt.executeQuery(s);
        }
        catch(Exception exception)
        {
            System.err.println("Link Error" + exception.getMessage());
        }
        return rs;
    }
}