databaseconn.java

jsp考勤

 package util;

import java.sql.*;


public class DatabaseConn {
public static synchronized Connection getConnection() 
{
String driver;
String db;
String username;
String password;
Connection conn=null;

try {
driver="oracle.jdbc.driver.OracleDriver";
db="jdbc:oracle:thin:@//127.0.0.1:1521/orcl"; //test??嵼ODBC拞?抲揑柤徧
username="system";
password="orcl"; 
Class.forName(driver);
return DriverManager.getConnection(db,username,password);
}
catch(SQLException e) {
System.out.println("SQLException:" + e);
}
catch(Exception e) {
System.out.println("Exception:"+e.getMessage());
}
return conn;
}
}