java登录界面与mysql_求用java编登录页面，可以连接MySql 数据库

展开全部

第一62616964757a686964616fe59b9ee7ad9431333335336534步：创建一个查询过程，因为在登录时要根据用户名查询用户密码

此步要用到pl/sql编程知识，代码如下：

create or replace procedure sel_user(uname in varchar2,pass out varchar2) is

begin

select users.password into pass from users where users.username=uname and rownum = 1;

end;

第二步：编写登录页面(login.java)(采用纯java+servlet编写)

//login.java如下

package cn.hnu;

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;

public class testhtml extends HttpServlet {

@Override

protected void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

resp.setContentType("text/html;charset=gbk");

try {

PrintWriter pw = resp.getWriter();

pw.println("");

pw.println("

");

pw.println("

");

pw.println("用户登录");

pw.println("

");

pw.println("");

pw.println("

");

pw.println("

用户登录

");

pw.println("

---

");

pw.println("

");

pw.println("用户名：
");

pw.println("密&nbsp&nbsp码：
");

pw.println("");

pw.println("");

pw.println("

");

pw.println("");

pw.println("");

} catch (Exception e) {

e.printStackTrace();

// TODO: handle exception

}

}

@Override

protected void doPost(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

this.doGet(req, resp);

}

}

第三步：编程成功登录页面(wel.java) //wel.java如下，它主要用于用户正常登录后显示信息给用户

package cn.hnu;

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;

import javax.servlet.http.HttpSession;

public class Wel extends HttpServlet {

@Override

protected void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

//防止用户非法登录

HttpSession hs = req.getSession();

String s = (String)hs.getAttribute("pass");

if(s == null){

resp.sendRedirect("login");

}

PrintWriter pw = resp.getWriter();

pw.write("welcome,hello");

}

@Override

protected void doPost(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

this.doGet(req, resp);

}

}

第四步：编写login处理页面(loginCl.java)

package cn.hnu;

import java.io.IOException;

import java.sql.*;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

public class loginCl extends HttpServlet {

@Override

protected void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

String u = req.getParameter("userName");

String p = req.getParameter("password");

//查询数据库

String pa=null;

Connection ct = null;

CallableStatement cs = null;

try {

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

ct = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle",

"scott", "tiger");

cs = ct.prepareCall("{call sel_user(?,?)}");

cs.setString(1, u);

cs.registerOutParameter(2, oracle.jdbc.OracleTypes.VARCHAR);

cs.execute();

pa = cs.getString(2);

System.out.println("u=" + u + " p=" + pa);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

try {

if (cs != null) {

cs.close();

}

if (ct != null) {

ct.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//验证用户信息是否合法

if (p.equals(pa)) {

HttpSession hs = req.getSession(true);//防止用户非法登录

hs.setAttribute("pass", "OK");

resp.sendRedirect("wel");

} else {

resp.sendRedirect("login");

}

}

@Override

protected void doPost(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

this.doGet(req, resp);

}

}

亲，sql可以换成MySQL

这个没关系的，别的都可以照搬来用

追答

亲，给个好评擦

采纳一下把

已赞过

已踩过<

你对这个回答的评价是？

评论

收起