JAVA中使用JDBC连接MySQL

来源：互联网发布：js url 编码编辑：程序博客网时间：2024/05/11 16:36
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");            }        }}
0 0