Mysql jdbc连接类

import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException，java.lang. ClassNotFoundException{
//设置url、jdbc驱动器、用户名、密码
String url =
"jdbc:mysql://localhost:3306/studentinfo";
Class.forName("com.mysql.jdbc.Driver");
String userName
= "admin";
String password
= "admin";
//建立到mysql的连接
Connection con =
DriverManager.getConnection(url，userName，password);
return con;
}
public static void main(String[] args) {
try{
Connection con = getConnection();
Statement sql = con.createStatement();
//执行sql语句，建立一个student表格，有三个属性：id、name、math
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'，'67')");
//查询语句
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());
}
}
}