mysql驱动多次执行问题_java连接mysql出现问题，要连续执行两次才能保存数据。...

java代码没问题，驱动也导入了，问题就是要连续执行两次才能保存数据。importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.S...

java代码没问题，驱动也导入了，问题就是要连续执行两次才能保存数据。

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class TestDB {

public static void main(String[] args) throws SQLException {

String driverName = "com.mysql.jdbc.Driver";

String dbURL = "jdbc:mysql://localhost:3306/blog";

String userName = "root";

String userPwd = "fudewei";

Connection dbConn=null;

try {

Class.forName(driverName);

dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

System.out.println("Connection Successful!");

}

catch (Exception e) {

e.printStackTrace();

}

String sql="update blog set title=?,content=?, cat_id=2 where id=13";

PreparedStatement ps=dbConn.prepareStatement(sql);

ps.setString(1, "cCXcc");

ps.setString(2, "fdfddfd");

int b=ps.executeUpdate();

ps.close();

dbConn.close();

System.out .print(b);

}

}

展开