14 June 2016

Kết nối databse đến mysql workbench trong Java Connection with mysql workbench using jdbc

Database Connection
Java 2016
package com.sample.soap.service;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBUtils {
 private static Connection connection = null;
 static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
 static final String DB_URL = "jdbc:mysql://localhost:3306/tutorial";
 static final String DB_USER = "root";
 static final String DB_PASS = "123456";

 public static Connection getConnection() {
  if (connection != null) {
   return connection;
  } else {
   try {
    Class.forName(JDBC_DRIVER);
    connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
   } catch (ClassNotFoundException e) {
    // TODO: handle exception
    e.printStackTrace();
   } catch (SQLException e) {
    // TODO: handle exception
    e.printStackTrace();
   }
   return connection;
  }
 }
}
Nếu thấy 1 dòng thông báo như trên hình thì kết nối thành công
Ảnh minh họa trên có 3 lần kết nối nên hiển thị 3 dòng



Related Posts:

  • NumberClient NumberServer MVC: Model View Controller Design Patterns - MVC package network.sample; import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.net.Socket; import java.util.Sca… Read More
  • TCPServer TCPClient Display: Gui a Nhan97 Gui b Nhan98 Gui c Nhan99 Gui d Nhan100 Gui e Nhan101 Gui f Nhan102 Gui g Nhan103..... package network.sample; import java.io.IOException; import java.io.InputStream; import java.io.Out… Read More
  • Ví dụ Servlet tính tổngServlet in java Enter number for loop  = sum TCPServer.java package network.sample; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.net.ServerSocket; import java.net… Read More
  • UDPServer UDPClient Converting String to Int in Java? Integer x = Integer.valueOf(str); // or int y = Integer.parseInt(str); int foo = Integer.parseInt("1234"); UDPServer UDPClient Servlet package demo5; import java.net.DatagramPacket; i… Read More
  • StringClient StringServer package network.sample; import java.io.DataInputStream; import java.io.DataOutputStream; import java.io.IOException; import java.net.Socket; public class StringClient { public static void main(String args[]) { try { … Read More

0 nhận xét:

Post a Comment

 

BACK TO TOP

Xuống cuối trang