javaWeb中mysql数据库连接的两种方式

package com.db.cn;

import java.sql.Connection;

import java.sql.DriverManager;

public class DB {

private static String driver = "com.mysql.jdbc.Driver";

private static String url = "jdbc:mysql://localhost:3306/itrzx";

private static String user = "root";

private static String pwd = "root";

public static Connection getConnection(){

Connection conn=null;

try {

Class.forName(driver);

conn=DriverManager.getConnection(url, user, pwd);

} catch (Exception e) {

e.printStackTrace();

// TODO: handle exception

}

return conn;

}

}

 driver=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3308/news

user=root

pass=root

package com.news.db;

import java.io.IOException;

import java.io.InputStream;

import java.util.Properties;

public class PropertiesDB {

  public static String getValue(String key){

  Properties prop=new Properties();

  InputStream in=new PropertiesDB().getClass().getResourceAsStream("/news.properties");

  try {

prop.load(in);

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

  return prop.getProperty(key);

  }

}

 package com.news.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DB {

public Connection getConn()throws Exception{

Class.forName(PropertiesDB.getValue("driver"));

Connection conn=DriverManager.getConnection(PropertiesDB.getValue("url"), PropertiesDB.getValue("user"), PropertiesDB.getValue("pass"));

return conn;

}

public void CloseConn(Connection conn){

if(conn!=null){

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public static void main(String[] args) {

DB db=new DB();

try {

db.getConn();

System.out.println("数据库连接成功!");

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("连接失败！");

}

}

}