一个JDBC简单连接

一个最基本的JDBC连接：
  
         Connection conn = null;
         PreparedStatement pt = null;
                try {
                        Class.forName("com.mysql.jdbc.Driver");
                        conn = DriverManager
                                        .getConnection("jdbc:mysql://localhost:3306/test?user=root&password=111111");
                        conn.setAutoCommit(false);
                        pt = conn.prepareStatement("insert into ming "+" values(?,?)");                       

                        pt.setString(1, " xvm03 ");
                        pt.setString(2, " 123 ");
                        pt.executeUpdate();
                        pt = null;
                        pt = conn.prepareStatement("insert into ming "+" values(?,?,?)");
                        //create table ming(name varchar(20),password varchar(20))
                        pt.setString(1, " xvm03 ");
                        pt.setInt(2, 12);
                        pt.executeUpdate();
                        System.out.println("!!!!!!commit1");
                        System.out.println("!!!!!!!!no commit");
                        conn.commit();
                        conn.close();
                        pt.close();
                        System.out.println("ss");
                } catch (Exception E) {
                       
                        E.printStackTrace();
                        try
                        {
                                conn.rollback();
                                System.out.println("======");
                        }
                        catch(Exception e)
                        {
                                e.printStackTrace();
                               
                        }
                } finally {
                        if (null != pt) {
                                pt.close();
                        }
                        if(null!=conn){
                                conn.close();
                        }
                }