| | |
| | | public static void update(String sql) { |
| | | try { |
| | | int ColumnCount; |
| | | //int RowCount; |
| | | String driver = "com.mysql.jdbc.Driver"; |
| | | String url = sqlConnect; //换成要连接的数据库信息 |
| | | //换成要连接的数据库信息 |
| | | String url = sqlConnect; |
| | | String user = username; |
| | | String password = FtpConfig.password; |
| | | Class.forName ( driver ); |
| | |
| | | Connection conn = (Connection) DriverManager.getConnection ( url, user, password ); |
| | | if (!conn.isClosed ()) { |
| | | System.out.println ( "数据库连接成功:" ); |
| | | String sqls = sql; //sql |
| | | //sql |
| | | String sqls = sql; |
| | | PreparedStatement ps = conn.prepareStatement ( sqls ); |
| | | ps.executeUpdate(); |
| | | ps.close (); |