public class Demo
{
    public static void main(String[] args)
    {
        Connection conn = null;
        try
        {
            String SQLSelect="select current_time";
            conn = getMysqlConnection();
            ResultSet rs=conn.createStatement().executeQuery(SQLSelect);
            if(rs.next())
            {
                System.out.println("现在时间："+rs.getString(1));
            }
            rs.close();
        } catch (Exception e)
        {
            e.printStackTrace();
        } finally
        {
            try
            {
                if (conn != null)
                {
                    conn.close();
                }
            } catch (Exception e)
            {
                e.printStackTrace();
            }
        }
    }

    /**
     * 获取mysql 数据库连接
     *
     * @return
     * @throws SQLException
     */
    public static Connection getMysqlConnection() throws SQLException
    {
        String dbUrl = "jdbc:mysql://localhost/test";
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        return DriverManager.getConnection(dbUrl, "root", "abc123");
    }
}

public class DemoTest extends TestCase
{
    private Connection conn = null;

    /**
     * The fixture set up called before every test method.
     */
    protected void setUp() throws Exception
    {
        conn = getMysqlConnection();
    }

    /**
     * The fixture clean up called after every test method.
     */
    protected void tearDown() throws Exception
    {
        if (conn != null)
        {
            conn.close();
        }
    }

    /**
     * 测试查询语句
     *
     * @throws Exception
     */
    public void testSQLSelectSentence() throws Exception
    {
        String SQLSelect = "select current_time";
        conn = getMysqlConnection();
        ResultSet rs = conn.createStatement().executeQuery(SQLSelect);
        if (rs.next())
        {
            System.out.println("现在时间：" + rs.getString(1));
        }
        rs.close();
    }

    /**
     *  测试SQLinsert语句
     * @throws Exception
     */
    public void testSQLInsertSentence() throws Exception
    {

    }

    /**
     * 获取mysql 数据库连接
     *
     * @return
     * @throws java.sql.SQLException
     */
    private  static Connection getMysqlConnection() throws SQLException
    {
        String dbUrl = "jdbc:mysql://localhost/test";
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        return DriverManager.getConnection(dbUrl, "root", "root");
    }
}

ioat wrote:
CTRL+SPACE用起来方便多了，而且和JB是一样的快捷键，但和输入法冲突，我的做法是，一般只是用一种中文输入法（紫光），所以把其他的中文输入都删掉，然后用ctrl+shift切换输入法，这样ctrl+space就可以用在idea和JB上了。

linux_china wrote:
4 关注intellij的eap
intellij的好多功能多会在eap中体现，如在最新的eap1108中，ejb的开发，jsp开发有了很多的提高。html的代码的动态提示，taglib的动态提示，ejb可视化编辑，gui的图形化设计等。相信你关注后就会有所发现。