JDBC操作步骤

JDBC操作步骤

1.加入MySQL架包（jar包拷贝到工程中，导入jar到工程中 add as library）

2.导入驱动

try {
	Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
	e.printStackTrace();
}

3.获取数据库连接对象

Connection conn = null;

String url = "jdbc:mysql://192.168.54.138:3306/datamanager;
String user = "root";
String pwd = "123456";

try {
	conn = DriverManager.getConnection(url,user,pwd);
} catch (SQLException e) {
	e.printStackTrace();
}

4.执行sql语句

try {
  conn = DriverManager.getConnection(url,user,pwd);

  //数据库语句
  String sql = "insert into user values(null,?,?,?)";
  //获取PreparedStatement对象
  ps = conn.prepareStatement(sql);
  //填入？的参数
  ps.setString(1,"jack");
  ps.setString(2,"123456");
  ps.setString(3,"2020-11-11");

  //执行增删改相关操作，返回几行受影响
  int m = ps.executeUpdate();

} catch (SQLException e) {
	e.printStackTrace();
}

5.关闭数据库

try {
  if (ps != null) {
  	ps.close();
  }
} catch (SQLException e) {
	e.printStackTrace();
}

try {
  if (conn != null) {
  	conn.close();
  }
} catch (SQLException e) {
	e.printStackTrace();
}

6.完整代码

public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        Connection conn = null;

        String url = "jdbc:mysql://192.168.54.138:3306/datamanager;
        String user = "root";
        String pwd = "123456";

        PreparedStatement ps = null;

        try {
            conn = DriverManager.getConnection(url,user,pwd);

            //数据库语句
            String sql = "insert into user values(null,?,?,?)";
            //获取PreparedStatement对象
            ps = conn.prepareStatement(sql);
            //填入？的参数
            ps.setString(1,"jack");
            ps.setString(2,"123456");
            ps.setString(3,"2020-11-11");

            //执行增删改相关操作，返回几行受影响
            int m = ps.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (ps != null) {
                    ps.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }

            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

7.读取操作

public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        Connection conn = null;

        String url = "jdbc:mysql://192.168.54.138:3306/datamanager;
        String user = "root";
        String pwd = "123456";

        PreparedStatement ps = null;
        ResultSet rs = null;

        try {
            conn = DriverManager.getConnection(url, user, pwd);

            String sql = "select id,username,password,registime from user";
            ps = conn.prepareStatement(sql);

            rs = ps.executeQuery();

            while (rs.next()) {
                int id = rs.getInt("id");
                String username = rs.getString("username");
                String password = rs.getString("password");
                String time = rs.getString("registime");

                System.out.println(id + "--" + username + "--" + password + "--" + time);

            }


        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                if (ps != null) {
                    ps.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }

            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }