摘要:
stmt.executeUpdate(insertStatement, statement.RETURN_GENERATED_KEYS);ResultSet rs = stmt.getGeneratedKeys();if(rs.next()){ int key = rs.getInt(1);} 阅读全文
摘要:
大对象LOB(BLOB二进制大对象 CLOB字符型大对象)获取LOBPreparedStatement stat = conn.prepareStatement("SELECT cover FROM bookcover WHERE ISBN=?");stat.set(1,isbn);ResultSet rs= stat.executeQuery();if(rs.next()){ Blob coverBlob= rs.getBlob(); Image ccoverImage= ImageIO.read(coverBlob.getInputStream()); //如果获取了C 阅读全文
摘要:
预编译语句String sqlQuery="SELECT * FROM books where books.name=? and books.isbn=?";PreparedStatement sqlQueryStat = conn.prepareStatement(sqlQuery);sqlQueryStat.setString(1,name);sqlQueryStat.setString(2,isbn);//位置1表示第一个?,第二个参数表示赋予宿主变量的值ResultSet rs = sqlQueryStat.executeQuery();只有查询及变量时,才应该使用 阅读全文
摘要:
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class insertToTable_2 {public static final String userName = "root";public static final String password = "123456";public static final String url = "jdbc:my 阅读全文