Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import javax.swing.*;
- public class mysqlconnect {
- Connection conn = null;
- public static Connection ConnectDb() {
- try{
- Class.forName("com.mysql.jdbc.Driver");
- Connection conn = DriverManager.getConnection("jdbc:mysql://server_name/database_name","user_name","user_password");
- return conn;
- }catch (Exception e) {
- JOptionPane.showMessageDialog(null, "Cant connect to db");
- return null;
- }
- }
- }
- SET SESSION wait_timeout = 999999;//or anything you want
- SHOW VARIABLES LIKE 'wait_timeout';
- SHOW VARIABLES LIKE 'connect_timeout';
- SET GLOBAL connect_timeout=60;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement