Package DAO;
Import java.sql.*;
public class Basedao {
Oracle
private static final String dirver= "Oracle.jdbc.driver.OracleDriver";
private static final String url= "Jdbc:oracle:thin: @localhost: 1521:xe";
private static final String name= "admin";
private static final String pass= "123";
Sql server
private static final String dirver= "Com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String url= "Jdbc:sqlserver://localhost:1433;databasename=tbldb";
private static final String name= "sa";
private static final String pass= "sa";
Mysql
private static final String dirver= "Com.mysql.jdbc.Driver";
private static final String url= "Jdbc:mysql://127.0.0.1:3306/school";
private static final String name= "root";
private static final String pass= "123456";
Public Connection getcconnection ()
{
Connection Conn=null;
try {
Class.forName (Dirver);
Conn=drivermanager.getconnection (Url,name,pass);
catch (Exception e) {
E.printstacktrace ();
}
Return conn;
}
public void Closall (Connection conn,preparedstatement ps,resultset rs)
{
try {
if (NULL!=RS)
Rs.close ();
if (NULL!=PS)
Ps.close ();
if (null!=conn)
Conn.close ();
catch (Exception e) {
E.printstacktrace ();
}
}
public int executeupdate (String sql,string parms[])
{
Connection Conn=null;
PreparedStatement Ps=null;
int result=-1;
try {
Conn=getcconnection ();
Ps=conn.preparestatement (SQL);
if (null!=parms) {
for (int i=0;i<parms.length;i++) {
Ps.setstring (I+1,parms[i]);
}
}
Result=ps.executeupdate ();
Execute ();
catch (Exception e) {
System.out.println (E.getmessage ());
}finally{
Closall (conn, PS, NULL);
}
return result;
}
public static void Main (string[] args) throws Exception
{
Basedao b=new Basedao ();
Connection con=b.getcconnection ();
System.out.println (con.isclosed ());
}
}