今天看到下面这种连接数据库的写法,简单有用,特共享此段代码(如下):
- try
- {
- Connectionconn=DriverManager.getConnection(
- "jdbc:mysql://localhost:3306/bbs","bbs","bbs");
- //获取此Connection对象的当前自动提交模式
- booleanautoCommit=conn.getAutoCommit();
- //将此连接的自动提交模式设置为false状态
- conn.setAutoCommit(false);
- PreparedStatementpreStmt=conn.prepareStatement(
- "insertintoarticlevalues(1,?,?)");
- preStmt.setString(1,"articleTitle");
- preStmt.setString(2,"articleValue");
- preStmt.execute();
- Statementstmt=conn.createStatement();
- stmt.execute("updateauthorsetname='Tom'whereid=1");
- conn.commit();
- conn.setAutoCommit(autoCommit);
- }catch(SQLExceptione)
- {
- e.printStackTrace();
- }
愿斌斌的这段代码对您有用!