package junit.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class dbTest {
private static String driver = "com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://47.90.45.161:3306/nntislot?characterEncoding=utf-8";
private static String username = "gsmcdev";
private static String password = "Agsmc999*";
static{
try {
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn=null;
try {
conn=DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void close(ResultSet rs,Statement st,Connection conn){
try {
if(rs!=null){
rs.close();
}
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
public static void close(PreparedStatement pst,Connection conn){
close(null,pst,conn);
}
public static void main(String[] args) {
Connection conn = dbTest.getConnection();
if(conn!=null){
System.out.println(conn);
}else {
System.out.println("NO");
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class dbTest {
private static String driver = "com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://47.90.45.161:3306/nntislot?characterEncoding=utf-8";
private static String username = "gsmcdev";
private static String password = "Agsmc999*";
static{
try {
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn=null;
try {
conn=DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void close(ResultSet rs,Statement st,Connection conn){
try {
if(rs!=null){
rs.close();
}
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
public static void close(PreparedStatement pst,Connection conn){
close(null,pst,conn);
}
public static void main(String[] args) {
Connection conn = dbTest.getConnection();
if(conn!=null){
System.out.println(conn);
}else {
System.out.println("NO");
}
}
}