JAVA中使用JDBC连接MySQL

package com.xuankai.sql;

import java.sql.*;


public class JdbcTest
{
    String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/test";
        String user = "root";
        String passwd = "root";
        Connection conn = null;
        Statement statement = null;
        String sql = "insert into test(name,myclass,score) values('jack','0230',50)";
        
        public boolean addStudent()
        {
            boolean flag = false;

            try
            {
                Class.forName(driver);
            }
            catch(ClassNotFoundException e) { e.printStackTrace();}
            try
            {
                conn = DriverManager.getConnection(url,user,passwd);
                System.out.println(conn);
            }
            catch(SQLException e) { e.printStackTrace();}
            try
            {
                statement = conn.createStatement();
                int row = statement.executeUpdate(sql);
                if(row == 1){flag = true;}
            }
            catch(SQLException e) { e.printStackTrace();}
            finally
            {
                if(null!=statement)
                {
                    try{ statement.close();}
                    catch(SQLException e) { e.printStackTrace();}
                }
                if(null!=conn)
                {
                    try{conn.close();}
                    catch(SQLException e) { e.printStackTrace();}
                }
            }
            
        
        return flag;
        
    }
        
        public static void main(String[] args)
        {
            JdbcTest jt = new JdbcTest();
            boolean flag = jt.addStudent();
            if(flag)
            {System.out.println("succssed!!");}
            else
            {
                System.out.println("failed");
            }
        }
}