淺談如何應用JDBC連接數據庫MySQL

MySQL>create database studentinfo;

import java.sql.*;public class ConnectToMySQL { public static Connection getConnection() throws SQLException , java.lang.ClassNotFoundException{ String url = "jdbc:mysql://localhost:3306/studentinfo"; Class.forName("com.MySQL.jdbc.Driver"); String userName = "root"; String password = ""; Connection con = DriverManager.getConnection(url,userName,passWord); return con; } public static void main(String[] args) {  try{   Connection con = getConnection();   Statement sql = con.createStatement();   sql.execute("drop table if exists student");   sql.execute("create table student(id int not null auto_increment,name varchar(20) not null default 'name',math int not null default 60,primary key(id));");   sql.execute("insert student values(1,'AAA','99')");   sql.execute("insert student values(2,'BBB','77')");   sql.execute("insert student values(3,'CCC','65')");   String query = "select * from student";   ResultSet result = sql.executeQuery(query);   System.out.println("Student表數據如下：");   System.out.println("---------------------------------");   System.out.println("學號"+" "+"姓名"+" "+"數學成績");   System.out.println("---------------------------------");   int number;   String name;   String math;   while(result.next()){   number = result.getInt("id");   name = result.getString("name");   math = result.getString("math");   System.out.println(number + " " + name + " " + math);   }   sql.close();   con.close();     }catch(Java.lang.ClassNotFoundException e){   System.err.println("ClassNotFoundException:" + e.getMessage());  }catch(SQLException ex){   System.err.println("SQLException:" + ex.getMessage());  } }}