execute root oca change ride import 本地 date() mysq
- 单线程版
- /**
- *
- */
- import java.sql. * ;
- import java.util.Date;
- import org.omg.CORBA.PUBLIC_MEMBER;
- /**
- * @author Administrator
- *
- */
- public class Mysql {
- public void Chaxun() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch(Exception e) {
- // TODO: handle exception
- e.printStackTrace();
- }
- String url = "jdbc:mysql://localhost:3306/beijing"; //jabc的路径
- Connection connection;
- try {
- connection = DriverManager.getConnection(url, "root", "liwanlei");
- Statement statement = connection.createStatement();
- String sql = "select * from student where id=1";
- ResultSet resultSet = statement.executeQuery(sql);
- if (resultSet.next()) {
- System.out.println(resultSet.getString("name"));
- }
- statement.close();
- connection.close();
- } catch(Exception e) {
- // TODO: handle exception
- System.out.println(e);
- }
- }
- public void Change() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch(Exception e) {
- // TODO: handle exception
- e.printStackTrace();
- System.out.println("异常");
- }
- String url = "jdbc:mysql://localhost:3306/beijing"; //jabc的路径
- Connection connection;
- try {
- connection = DriverManager.getConnection(url, "root", "liwanlei");
- Statement statement = connection.createStatement();
- String sql = "UPDATE student SET name=? WHERE id=?";
- PreparedStatement preparedStatement = connection.prepareStatement(sql);
- preparedStatement.setString(1, "liwanlei");
- preparedStatement.setInt(2, 1);
- preparedStatement.executeUpdate();
- System.out.println("ok");
- } catch(Exception e) {
- // TODO: handle exception
- System.out.println("异常");
- }
- }
- public void Adddate() {
- Date aDate = new Date();
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch(Exception e) {
- // TODO: handle exception
- System.out.println("加载驱动失败");
- }
- String url = "jdbc:mysql://localhost:3306/beijing";
- Connection connection;
- try {
- connection = DriverManager.getConnection(url, "root", "liwanlei");
- Statement statement = connection.createStatement();
- String sql = "insert into student (id,name,age,address) values (?,?,?,?)";
- PreparedStatement preparedStatement = connection.prepareStatement(sql);
- for (int i = 1; i < 10; i++) {
- preparedStatement.setInt(1, i);
- preparedStatement.setString(2, "liwanddlei" + i);
- preparedStatement.setInt(3, i * 333);
- preparedStatement.setString(4, "beijiddng" + i);
- preparedStatement.executeUpdate();
- }
- preparedStatement.close();
- connection.close();
- Date date = new Date();
- System.out.println((date.getTime() - aDate.getTime()));
- System.out.println("插入慕成功");
- } catch(Exception e) {
- // TODO: handle exception
- }
- }
- public static void main(String[] args) {
- // TODO Auto-generated method stub
- Mysql mysql = new Mysql();
- mysql.Adddate();
- }
- }
- 多线程插入版本import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.Statement;
- import java.util.Date;
- /**
- *
- */
- /**
- * @author lileilei
- *Threadmyql.java
- *2017年12月9日
- */
- public class Threadmyql extends Thread {@Override public void run() {
- Date aDate = new Date();
- try {
- Class.forName("com.mysql.jdbc.Driver");
- } catch(Exception e) {
- // TODO: handle exception
- System.out.println("加载驱动失败");
- }
- String url = "jdbc:mysql://localhost:3306/beijing";
- Connection connection;
- try {
- connection = DriverManager.getConnection(url, "root", "liwanlei");
- Statement statement = connection.createStatement();
- String sql = "insert into student (id,name,age,address) values (?,?,?,?)";
- PreparedStatement preparedStatement = connection.prepareStatement(sql);
- for (int i = 1; i < 100000; i++) {
- preparedStatement.setInt(1, i);
- preparedStatement.setString(2, "asdasdasd" + i);
- preparedStatement.setInt(3, i * 333);
- preparedStatement.setString(4, "asdasdasdasdasdasd" + i);
- preparedStatement.executeUpdate();
- }
- preparedStatement.close();
- connection.close();
- Date date = new Date();
- System.out.println((date.getTime() - aDate.getTime()) / 1000);
- System.out.println("插入慕成功");
- } catch(Exception e) {
- // TODO: handle exception
- }
- }
- public static void main(String[] args) {
- for (int i = 1; i <= 10; i++) {
- new Threadmyql().start();
- }
- }
- }
数据关联性小,没有必要做性能,做了一会 发现没有必要
java 操作本地数据库 mysql
execute root oca change ride import 本地 date() mysq
原文:http://www.cnblogs.com/leiziv5/p/8010997.html
来源: http://www.bubuko.com/infodetail-2422135.html