- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class Test {
- public static void main(String[] args) {
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- String databaseName = "phildatabase";// 已经在MySQL数据库中创建好的数据库。
- String userName = "root";// MySQL默认的root账户名
- String password = "";// 默认的root账户密码为空
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + databaseName, userName, password);
- Statement stmt = conn.createStatement();
- String sql = "CREATE TABLE person(uid varchar(32),name char(32))";
- // 创建数据库中的表,
- int result = stmt.executeUpdate(sql);
- if (result != -1) {
- System.out.println("创建数据表成功");
- sql = "INSERT INTO person(uid,name) VALUES('1','somebody1')";
- result = stmt.executeUpdate(sql);
- sql = "INSERT INTO person(uid,name) VALUES('2','somebody2')";
- result = stmt.executeUpdate(sql);
- sql = "SELECT * FROM person";
- ResultSet rs = stmt.executeQuery(sql);
- System.out.println("uid\t姓名");
- while (rs.next()) {
- System.out.println(rs.getString(1) + "\t" + rs.getString(2));
- }
- }
- conn.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
代码运行输出结果如图: