Java操作sql

来源：互联网发布：开淘宝网店怎么发货编辑：程序博客网时间：2024/05/16 07:57

首先是导入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();        }    }}

0 0