针对MySQL数据库的数据增、删、改和查操作,大家可以使用Java中的JDBC API来实现。在Java程序中,JDBC API主要包括以下几个接口和类:
java.sql.Driver java.sql.Connection java.sql.Statement java.sql.PreparedStatement java.sql.ResultSet
Java Application Architecture(JAA)提供了一种简单、易用的方法来执行对MySQL数据库的增、删、改和查操作。下面大家来看一下如何使用JAA对MySQL进行数据操作。
增加数据
try { String sql = "INSERT INTO student (name, age) VALUES (?, ?)"; Connection conn = JAA.getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, "Jack"); pstmt.setInt(2, 20); pstmt.addBatch(); pstmt.executeBatch(); conn.commit(); JAA.closeConnection(); } catch(SQLException e) { e.printStackTrace(); }
删除数据
try { String sql = "DELETE FROM student WHERE id=?"; Connection conn = JAA.getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setInt(1, 3); pstmt.executeUpdate(); conn.commit(); JAA.closeConnection(); } catch(SQLException e) { e.printStackTrace(); }
修改数据
try { String sql = "UPDATE student SET name=?, age=? WHERE id=?"; Connection conn = JAA.getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, "Tom"); pstmt.setInt(2, 22); pstmt.setInt(3, 2); pstmt.executeUpdate(); conn.commit(); JAA.closeConnection(); } catch(SQLException e) { e.printStackTrace(); }
查询数据
try { String sql = "SELECT * FROM student WHERE age >?"; Connection conn = JAA.getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setInt(1, 20); ResultSet rs = pstmt.executeQuery(); while(rs.next()) { System.out.println(rs.getInt("id") + " " + rs.getString("name") + " " + rs.getInt("age")); } JAA.closeConnection(); } catch(SQLException e) { e.printStackTrace(); }
以上就是使用JAA对MySQL进行数据操作的过程。大家可以看到,使用JAA实现数据操作非常简单,能够提高程序的开发效率。