JDBC开发模式
一】代码模块———Demo.java
public class Demo { private static Connection connection; private static Statement statement; private static ResultSet rs; public static void main(String[] args) { connection = JDBCUtils.getConnection(); try { statement = connection.createStatement(); rs = statement.executeQuery(SqlMapping.QEURY_ALL); while (rs.next()) { System.out.println(rs.getInt("id") + " : " + rs.getString("name") + " : " + rs.getString("gender") + " : " + rs.getString("salary")); } } catch (SQLException e) { e.printStackTrace(); } JDBCUtils.closeStream(rs, statement, connection); }
二】工具模块———JdbcUtil.java
public class JDBCUtils { private static Properties properties; //得到数据库驱动 static { InputStream inputStream = JDBCUtils.class.getClassLoader().getResourceAsStream("com/suse/jdbc/db.properties"); properties = new Properties(); try { properties.load(inputStream); Class.forName(properties.getProperty("driver")); } catch (IOException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } } //得到数据库连接 public static Connection getConnection(){ Connection connection = null; try { connection = DriverManager.getConnection(properties.getProperty("url"), properties); } catch (SQLException e) { e.printStackTrace(); } return connection; } //关闭流 public static void closeStream( ResultSet rs, Statement stmt, Connection conn) { if (null != rs) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (null != stmt) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (null != conn) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
三】配置文件模块———db.properties
driver = com.mysql.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/mydb
user = root
password = root
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。