JDBC for MySql5.5 简单示例

package com.anllin.mysqltest;
 
import java.sql.*;
 
public class MysqlTest
{
    public static void main(String[] args)
    {
        connetMysqlTest();
    }
 
    public static void connetMysqlTest()
    {
        String connectionUrl = "jdbc:mysql://localhost:3306/mydata?user=root&password=123";
 
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
 
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(connectionUrl);
            conn.setAutoCommit(false);
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from dept");
            conn.commit();
            System.out.print("deptno" + " ");
            System.out.print("dname" + " ");
            System.out.println("loc");
            while (rs.next())
            {
                System.out.print(rs.getInt("deptno") + "      ");
                System.out.print(rs.getString("dname") + "      ");
                System.out.println(rs.getString("loc"));
            }
        }
        catch (Exception e)
        {
            if(null != conn)
            {
                try
                {
                    conn.rollback();
                }
                catch (SQLException e1)
                {
                    e1.printStackTrace();
                }
            }
            e.printStackTrace();
        }
        finally
        {
            if (null != rs)
            {
                try
                {
                    rs.close();
                    rs = null;
                }
                catch (Exception e2)
                {
                    e2.printStackTrace();
                }
            }
 
            if (null != stmt)
            {
                try
                {
                    stmt.close();
                    stmt = null;
                }
                catch (Exception e2)
                {
                    e2.printStackTrace();
                }
            }
 
            if (null != conn)
            {
                try
                {
                    conn.close();
                    conn = null;
                }
                catch (Exception e2)
                {
                    e2.printStackTrace();
                }
            }
        }
    }
}

  

posted @   水之原  阅读(3769)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示