更换数据库,应用程序跨平台 两个问题的解决——JDBC
JDBC——JDBC标准API(java.sql,javax.sql),JDBC驱动程序
======================================================
要取得数据库联机: 注册Driver操作对象 取得Connection操作对象 关闭Connection操作对象
Class.forName(“com.mysql.jdbc.Driver”);
Connection conn = DriverManager.getConnection(jdbcUrl,username,password);
======================================================= Statement stmt = conn.createStatement();
int i = stmt.executeUpdate(“INSERT INTO t_message VALUES(1,’justin’,”+“‘justin@mail.com’,’message…’)”);
ResultSet result = stmt.executeQuery(“SELECT * FROM t_message”); result.getString(“name”),result.getInt(“id”)
stmt.execute(sql) ResultSet rs = stmt.getResultSet(); int updated = stmt.getUpdateCount();