conntest.java

servlet实现网上书店查询

package com.ghy;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnTest {
	
public static Connection getConnByJdbc ()
{
  Connection conn = null ;
  String url = "jdbc:oracle:thin@localhost:1521:gao" ;
  String username = "gaohongyu" ;
  String password = "gaohongyu" ;
  try {
	Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
} catch (InstantiationException e1) {
	// TODO Auto-generated catch block
	e1.printStackTrace();
} catch (IllegalAccessException e1) {
	// TODO Auto-generated catch block
	e1.printStackTrace();
} catch (ClassNotFoundException e1) {
	// TODO Auto-generated catch block
	e1.printStackTrace();
}
  try {
	conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
  return conn;
  
}
}