package ch06.dao;
import java.sql.*;
public class baseDao {
public static final String DRIVER="net.sourceforge.jtds.jdbc.Driver";public static final String URL="jdbc:jtds:sqlserver://localhost:1433/restrant";public static final String NAME="sa";public static final String PW="";
public static Connection con(){ Connection connection=null; try{ Class.forName(DRIVER); connection=DriverManager.getConnection(URL,NAME,PW); }catch(Exception e) { e.printStackTrace(); } return connection;}public static void closeAll(PreparedStatement pstmt,Connection con,ResultSet rs){
try { if (pstmt!=null) { pstmt.close(); } if (con!=null) { con.close(); } if (rs!=null) { rs.close(); } } catch (Exception e) { e.printStackTrace(); } }}