Java操作sql

首先是导入MySQL官方JDBC驱动程序（百度mysql-connector-java下载）

/*连接数据库*/
public class LianJieShuJuKu {
    private static final String url = "jdbc:mysql://127.0.0.1/university?createDatabaseIfNotExist=true&&characterEncoding=utf-8&autoReconnect=true";
    private static final String name = "com.mysql.jdbc.Driver";
    private static final String user = "root";
    private static final String password = "root";
    public Connection conn = null;
    //public PreparedStatement pst = null;

    /*连接数据库*/
    public Connection getConnection() {
        try {
            Class.forName(name);// 指定连接类型
            conn = DriverManager.getConnection(url, user, password);// 获取连接
            return conn;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
    /*关闭连接*/
    public void close() {
        try {
            this.conn.close();
            //this.pst.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

/*操作数据库例子*/
public class CunShuJu {
    public static void main(String[] args) {
        String sql = "INSERT INTO school (ID,Name,Piny,Py,Rank) VALUES ('1','x','hha','haha','123');";
        LianJieShuJuKu db = new LianJieShuJuKu();
        Connection coon = db.getConnection();
        try {
            PreparedStatement p = coon.prepareStatement(sql);
            p.execute();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
}