这是conn.jsp的代码
<%@ page language="java" import="java.util.*" pageEncoding="gbk" import="java.sql.*"%><html>
<head>
<title>Login</title>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String pxf="jdbc:odbc:pxf";
Connection conn=DriverManager.getConnection(pxf); %>
</body>
</html>代码是这样的
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ include file="conn.jsp" %><% String user="";
String password="";
user=request.getParameter("user");
password=request.getParameter("password");
Statement stmt = conn.createStatement();
// String sql = "select * from 用户";
String str = "select * from 用户 where user='"+user+"' and password='"+password+"'" ;
ResultSet rs = stmt.executeQuery(str);
if(!rs.next()) {
out.print("<script>alert('用户名或密码不正确,请重新输入!!!'); window.history.go(-1);</script>");
}
else {
session.setAttribute("user",""+rs.getString("user")+"");
response.sendRedirect("Login.jsp");
}
rs.close();
stmt.close();
%>
怎是会出错
<%@ page language="java" import="java.util.*" pageEncoding="gbk" import="java.sql.*"%><html>
<head>
<title>Login</title>
</head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String pxf="jdbc:odbc:pxf";
Connection conn=DriverManager.getConnection(pxf); %>
</body>
</html>代码是这样的
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ include file="conn.jsp" %><% String user="";
String password="";
user=request.getParameter("user");
password=request.getParameter("password");
Statement stmt = conn.createStatement();
// String sql = "select * from 用户";
String str = "select * from 用户 where user='"+user+"' and password='"+password+"'" ;
ResultSet rs = stmt.executeQuery(str);
if(!rs.next()) {
out.print("<script>alert('用户名或密码不正确,请重新输入!!!'); window.history.go(-1);</script>");
}
else {
session.setAttribute("user",""+rs.getString("user")+"");
response.sendRedirect("Login.jsp");
}
rs.close();
stmt.close();
%>
怎是会出错
解决方案 »
- 求jsp页面中text框的值
- 为什么第二天我的tomcat需要重启???
- fileupload文件上传,获取表单域字段值乱码问题
- 求一个操作sql的javabean
- 请问诸位大侠:如何在下面的语句中加入自己的参数,服务器端的servlet通过doGet接收参数?谢谢
- 用jsp实现数据库的导出导入
- 如果表单类型设为ENCTYPE="multipart/form-data",就不能用request.getParameter()方法了吗?为什么?
- HTML页面如何实现计数器功能!在线等!.....
- 急求!webservice连接超时
- 导出excel怎么设置列的单元格样式
- 关于数据库分页~~大家帮帮啊
- Firefox的问题!
看看这个!希望能帮上你!
http://blog.csdn.net/ray_1981/archive/2007/10/22/1836278.aspx
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String pxf="jdbc:odbc:pxf";
Connection conn=DriverManager.getConnection(pxf); % >
</body >上边这段代码有误,Connection conn=DriverManager.getConnection(url,username,password);当然如果你配置好了数据源,也可以不用username,password,数据源配好了吗?