package com.baidu.mysql;
import java.sql.*;
public class MysqlJdbc {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("success loading mysql driver");
}
catch (Exception e){
System.out.println("error loading mysql driver!");
e.printStackTrace();
}
ResultSet rs;
try {
Connection connect=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test",
"root", "123456");
//插入100条数据
int num=100;
PreparedStatement Statement=connect.prepareStatement("insert into user values(?,?)");
for (int i = 0; i < num; i++) {
Statement.setString(1, "chongshi"+i);
Statement.setString(2, "bo"+i);
Statement.executeUpdate();
}
System.out.println("sucess connect mysql server");
Statement stmt=connect.createStatement();
rs = stmt.executeQuery("select * from user");
while (rs.next()){
System.out.println(rs.getString("name"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//驱动需要导入