package com.ddbs.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Statement;

import javax.print.DocFlavor.STRING;

public class DbConn {

public Connection getConn(){

try {

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/bookshop?useUnicode=true&characterEncoding=utf-8";

String username = "root";

String password = "cpprootmysql";

return DriverManager.getConnection(url,username,password);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

public void close(Statement sta,Connection conn){

try {

sta.close();

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

public void close(PreparedStatement sta,Connection conn){

try {

sta.close();

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}