/*

 * 简单数据库测试

 * @李志杰

 * 2013-8-4

 */

package com;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.ResultSet;

public class Sql_1

{

    public static void main(String[] args)

    {

        Connection con = null;

        try

        {

            // 获得MySQL驱动的实例

            Class.forName("com.mysql.jdbc.Driver").newInstance();

            // 提供地址用户名密码并获得连接对象

            con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/card","root", "");

            if (!con.isClosed())

            {

                // 连接成功提示

                System.out.println("Successfully connected to MySQL server using TCP/IP...");

            }

            // 有Connection对象创建Statement

            Statement st = con.createStatement();

            // 运行SQL语句读取

            ResultSet rs = st.executeQuery("SELECT * FROM mycard");

            // 循环读取数据

            while (rs.next())

            {

                // 打印数据

                System.out.println(rs.getString("uname"));

            }

            // 关闭

            con.close();

        }

        catch(Exception e)

        {

            System.err.println("Exception: " + e.getMessage());

        }

    }

}