在Myeclipse下servlet和oracle配置和连接

在Myeclipse下servlet和oracle配置和连接
1.导入的包servlet-api.jar和ojdbc6.jar
2.必要代码:Jdbc连接代码、TestHtml页面，TestOracle代码，web.xml配置文件
3.建立一个数据库myUser表，
******************************************
1.连接Jdbc的代码
package eduask;

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

public class MyJdbcTools {
/**用户名*/
static String user="scott";
/**密码*/
static String password="tiger";
/**驱动*/
static String driverName="oracle.jdbc.driver.OracleDriver";
static String url="jdbc:Oracle:thin:@localhost:1521/orcl";

/** 获取一个连接 */
public static Connection getConnection() {
Connection c = null;
try {
Class.forName(driverName);// 加载驱动
c = DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return c;

}

/** 关闭数据库 */
public static void close(Connection c) {
if (c != null) {
try {
if (!c.isClosed()) {// 如果没有关闭
c.close();
}
} catch (SQLException e) {
e.printStackTrace();
}

}
}

}
2.TestHtml的代码（显示网页的代码）
1.package eduask;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
//测试在网页显示HTML代码;
public class TestHtml extends HttpServlet{
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
PrintWriter out=resp.getWriter();
out.println("<form action=/myWeb/TestOracle method=get>");
out.println("id:<input name=id type=text></br>");
out.println("name:<input name=name type=text></br>");
out.println("<input type=submit value=submit ></br>");
out.println("</form>");
}
}
3.TestOracle的代码（获得网页的代码，放入到数据库中。）
package eduask;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class TestOracle extends HttpServlet{
@Override  protected void service(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
//            PrintWriter out=res.getWriter();
//            out.write("RequestURI:"+req.getRequestURI()+"\n");
//            out.write("RequestURL:"+req.getRequestURL().toString()+"\n");
//            out.write("username:"+req.getParameter("username")+"\n");
//            out.write("password:"+req.getParameter("password")+"\n");
String id=req.getParameter("id");
String name=req.getParameter("name");
Connection conn=null;
PreparedStatement ps=null;
try {
conn=MyJdbcTools.getConnection();
String sql="insert into myUser(id,name)values(?,?)";
ps=conn.prepareStatement(sql);
ps.setString(1, id);
ps.setString(2,name);
ps.execute();
} catch (Exception e) {
e.getStackTrace();
}
}

}
2.web.xml文件的配置
<!--提交html网页 -->
<servlet>
<servlet-name>TestHtml</servlet-name>
<servlet-class>eduask.TestHtml</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>TestHtml</servlet-name>
<url-pattern>/TestHtml</url-pattern>
</servlet-mapping>

<servlet>
<servlet-name>TestOracle</servlet-name>
<servlet-class>eduask.TestOracle</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>TestOracle</servlet-name>
<url-pattern>/TestOracle</url-pattern>
</servlet-mapping>