数据库的小例子

注：要先在mysql中建立studentinfo表。

import java.sql.*;
            public class Test {
            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 = "764062915";
            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;