在myeclispe中使用JDBC直接访问oracle数据库

来源：互联网发布：汕头店铺美工培训编辑：程序博客网时间：2024/04/28 03:45

1.新建项目

2.文件名称重构

3.修改编码方式，将pageEncoding修改为GB18030，以支持中文。

4.添加Oracle访问类库，只需要ojdbc5.jar一个就可以了。

\\vmware-host\Shared Folders\F\待处理20130611\小软件\JAVA类库\spring类库\ojdbc5.jar

5.重新部署web程序

6.先将自动启动的tomcat服务器停止。

D:\ZhaohyInstalledSoftware\Apache Software Foundation\Tomcat 6.0\bin

7.在myeclipse中启动服务器

程序启动，使用网址测试：

http://localhost:8090/Spring_2300_Registration_1/register.jsp

8.表脚本。

-- Create table

createtable myuser

(

id numbernotnull,

username varchar2(20)notnull,

passwordvarchar2(20)notnull

)

;

-- Create/Recreate primary, unique and foreign key constraints

altertable myuser

addconstraint idpkprimarykey (ID);

9.代码文件：

<%@ pagelanguage="java"import="java.util.*"pageEncoding="GB18030"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<basehref="<%=basePath%>">

<metahttp-equiv="pragma"content="no-cache">

<metahttp-equiv="cache-control"content="no-cache">

<metahttp-equiv="expires"content="0">

<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">

<metahttp-equiv="description"content="This is my page">

<!--

-->

</head>

<body>

<formmethod="post"action="registerDeal.jsp">

用户名:<inputtype="text"name="username">

密码：<inputtype="password"name="password">

确认密码：<inputtype="password"name="password2">

<inputtype="submit"value="提交">

</form>

</body>

</html>

registerDeal.jsp

<%@ pagelanguage="java"import="java.util.*,java.sql.*"pageEncoding="GB18030"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

String username=request.getParameter("username");

String password=request.getParameter("password");

String password2=request.getParameter("password2");

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCLLEAR","888888","666666");

String sqlQuery="select count(*) from myuser where username = ?";

PreparedStatement psQuery=conn.prepareStatement(sqlQuery);

psQuery.setString(1,username);

ResultSet rs=psQuery.executeQuery();

rs.next();

int count=rs.getInt(1);

if(count >0){

response.sendRedirect("registerFail.jsp");

psQuery.close();

return;

}

String sql="insert into myuser (id, username, password) values (?, ?, ?)";

PreparedStatement ps=conn.prepareStatement(sql);

ps.setInt(1,1);

ps.setString(2,username);

ps.setString(3,password);

ps.executeUpdate();

ps.close();

conn.close();

response.sendRedirect("registerSuccess.jsp");

registerFail.jsp

<%@ pagelanguage="java"import="java.util.*"pageEncoding="GB18030"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<basehref="<%=basePath%>">

<title>My JSP 'index.jsp' starting page</title>

<metahttp-equiv="pragma"content="no-cache">

<metahttp-equiv="cache-control"content="no-cache">

<metahttp-equiv="expires"content="0">

<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">

<metahttp-equiv="description"content="This is my page">

<!--

-->

</head>

<body>

注册失败

</body>

</html>

registerSuccess.jsp

<%@ pagelanguage="java"import="java.util.*"pageEncoding="GB18030"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPEHTMLPUBLIC"-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<basehref="<%=basePath%>">

<title>My JSP 'index.jsp' starting page</title>

<metahttp-equiv="pragma"content="no-cache">

<metahttp-equiv="cache-control"content="no-cache">

<metahttp-equiv="expires"content="0">

<metahttp-equiv="keywords"content="keyword1,keyword2,keyword3">

<metahttp-equiv="description"content="This is my page">

<!--

-->

</head>

<body>

注册成功！

</body>

</html>