ORACLE+Myeclipse+jsp实现简单登录功能
Oracle数据库表的建立:
create table Log(
un char(20),
pd char(25)
)
tablespace users;
Oracle在Myeclipse中的配置:
1.导jar包:
右键项目名,build path→configure build path→Libraries→Add External JARs..→D:\app\asus\product\11.2.0\dbhome_1\jdbc\lib(也就是你的Oracle安装路径\product......)→选择ojdbc*.jar(*为自己文件里的jar包版本号)→OK
就可以看到项目里jar包导入,显示在Referenced Libraries目录下。
2.打开Myeclipse Database Explorer进行Oracle数据库连接配置。
右键反手一个new→Driver template选择Oracle(Thin driver)→Driver name:OracleDriver→Connection URL:jdbc:oracle:thin:@localhost:1521:<database_name>(<database_name>用要连接的数据库名代替)→User name: 用来登录数据库的用户名→Password:对应密码→Add JARs(路径和导包的时候一样,选一样版本的)→Driver classname:这里是Add JARs后自动生成的,注意Class.forName()必须对应到这里→Test DriverSave→显示Database connection successfully established就表示连接成功。(可以Save password方便下次test)
3.编写连接代码,祝好运。
Logincheck.jsp
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<%
String driverName="oracle.jdbc.OracleDriver";
String dbURL="jdbc:oracle:thin:@localhost:1521:test";
String userName="system";
String userPwd="1234";
Connection conn = null;
ResultSet rs = null;
%>
<%
boolean flag=false;
String user = request.getParameter("usern");
String pass = request.getParameter("passw");
try{
Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:test", "system", "1234");
String sql="select * from Log where UN=' "+user+" ' and PD=' "+pass+" ' ";
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(rs.next()){
flag=true;
}else{
flag=false;
}
rs.close();
stmt.close();
conn.close();
}catch(Exception err){
System.out.println("error");
}
if(flag){
%>
<jsp:forward page="suc.jsp"/>
<%
}else{
%>
<jsp:forward page="error.jsp"/>
<%
}
%>
</body>
</html>
Login.jsp(只截取主要部分)
<body>
<form action="Logincheck.jsp" method="post">
<table align="center">
<tr> <td>用户名: <input type="text" name="usern" /></td> </tr>
<tr> <td>密码: <input type="password" name="passw" /><a href="find.jsp">忘记密码?</a> </td></tr>
</table>
</form>
</body>