myeclipse中添加Oracle数据库
1、打开Myeclipse后点击如图右上方进入MyEclipse Database Explorer视图
2、在如图空白处鼠标右击后点选new进入Create a new connection driver界面
3、在Driver template:中下拉选中Oracle(Thin driver);
在Driver name中填写你希望的名称；
在Connection URL中将@后面的<server>[:<1521>]:<database_name>改成localhost:1521:orcl,这里需要注意的是database_name要改成数据库的SID，orcl为Oracle的数据库的自带实例。
在User name中填写实例中的案例，这里我填写scott；
在password中填写scott的密码，我的是123，所以就写上123；
在Driver JARs中单击右侧的add JARS添加Oracle的驱动ojdbc6.jar,这个驱动在你Oracle的安装目录下\product\11.2.0\dbhome_1\jdbc\lib中可以找到；
4、设置好后点击Test Driver，若出现该画面则表示你连接成功了。
5、点击OK，在点击Finish，你的Myeclipse就添加成功了Oracle的连接了。
1、测试代码：新建一个web项目，在项目中新建一个Servlet代码如下：
package com.city.j2ee.ch02;
import java.io.IOException;
import java.sql.*;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.PrintWriter;
public class ShowEmployeeList extends HttpServlet {
private Connection cn=null;
public void init(ServletConfig config) throws ServletException {
// TODO Auto-generated method stub
super.init(config);
String driver=config.getInitParameter("driver");
String url=config.getInitParameter("url");
String user=config.getInitParameter("user");
String password=config.getInitParameter("password");
try{
Class.forName(driver);
cn=DriverManager.getConnection(url,user,password);
}catch(Exception e)
{
System.out.println("Init Error:"+e.getMessage());
}
}
/**
* @see Servlet#destroy()
*/
public void destroy() {
// TODO Auto-generated method stub
super.destroy();
try{
if(cn!=null&&(!cn.isClosed()))
{
cn.close();
cn=null;
}
}catch(Exception e) {
System.out.println("Destroy Error:"+e.getMessage());
}
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out =response.getWriter();
out.println("<HTML>");
out.println("<HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println("<BODY>");
try{
String sql="select ename,job,sal,hiredate from emp";
PreparedStatement ps=cn.prepareStatement(sql);
ResultSet rs=ps.executeQuery();
out.print("<h1>员工列表</h1>");
out.print("<table border='1'>");
out.print("<tr>");
out.print("<td>姓名</td><td>职位</td><td>工资</td><td>加入公司日期</td>");
out.print("</tr>");
while(rs.next()){
out.print("<tr>");
out.println("<td>"+ rs.getString("ENAME")+"</td>");
out.println("<td>"+ rs.getString("JOB")+"</td>");
out.println("<td>"+ rs.getString("sal")+"</td>");
out.println("<td>"+ rs.getString("hiredate")+"</td>");
out.println("</tr>");
}
rs.close();
ps.close();
out.print("</table>");
}catch(Exception e) {
out.println("<h2>处理请求发生错误："+e.getMessage()+"</h2>");
}
out.println("</BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request,response);
}
}
然后在Web Root下的WEB-INF下的web.xml中配置servlet，代码如下：
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>ShowEmployeeList</servlet-name>
<servlet-class>com.city.j2ee.ch02.ShowEmployeeList</servlet-class>
<init-param>
<param-name>driver</param-name>
<param-value>oracle.jdbc.driver.OracleDriver</param-value>
</init-param>
<init-param>
<param-name>url</param-name>
<param-value>jdbc:oracle:thin:@localhost:1521:orcl</param-value>
</init-param>
<init-param>
<param-name>user</param-name>
<param-value>scott</param-value>
</init-param>
<init-param>
<param-name>password</param-name>
<param-value>123</param-value>
</init-param>
</servlet>
2、运行效果如下：
