52,797
社区成员
发帖
与我相关
我的任务
分享
<%@page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>JSP 读取数据库</title>
</head>
<body>
<table border="1" align="center">
<tr>
<th>
UserID
</th>
<th>
UserName
</th>
<th>
Email
</th>
</tr>
<%
String driverClass="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/test";//之前数据库名 test
String user="root";//MySQ 帐号
String password="32147";//MYSQL 密码
Connection conn;
try {
Class.forName(driverClass).newInstance();
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="SELECT * FROM user";//表名 user
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%=rs.getInt("user_id")%></td>
<td><%=rs.getString("user_name")%></td>
<td><%=rs.getString("email")%></td>
</tr>
<%
}
}catch(Exception ex){
ex.printStackTrace();
} %>
</body>
</html>
<%@ page language="java" import="java.util.*" 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>
<head>
<base href="<%=basePath%>">
<title>Login</title>
<link rel="stylesheet" type="text/css" href="js/resources/css/ext-all.css" />
<script type="text/javascript" src="js/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="js/ext-all-debug.js"></script>
<script type="text/javascript">
Ext.onReady(function(){
Ext.onReady(function(){
var my_form = new Ext.FormPanel({
url: 'login.jsp',
renderTo: 'loginPanel',
frame: true,
border: true,
width: 300,
items: [{
xtype: 'textfield',
fieldLabel: 'User Name',
name: 'user_name',
allowBlank: false,
blankText:'姓名不能为空!'
},{
xtype: 'textfield',
inputType: 'password',
fieldLabel: 'Password',
name: 'user_pwd',
allowBlank: false,
blankText:'密码不能为空!'
}],
buttons: [{
text: 'Submit',
handler: function(){
my_form.getForm().submit({
success: function(form,action){
Ext.Msg.alert('Success', '登录成功!');
// document.location="login.jsp"
},
failure: function(form,action){
Ext.Msg.alert('Warning', '账号或密码为空!');
}
});
}
},{
text: 'Reset',
handler: function(){
my_form.getForm().reset();
}
}]
});
});
});
</script>
</head>
<body>
<div id='loginPanel' style='width:300px; margin:50px auto;'></div>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%
String user_name=request.getParameter("user_name");
String user_pwd=request.getParameter("user_pwd");
out.print(user_name);
out.print("<br>");
out.print(user_pwd);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>登录</title>
<style type="text/css">
*
{
margin:0px;
}
html,body
{
height: 100%;
width: 100%;
}
body
{
background:#fafafa;
}
</style>
<!--#include file="/DPOA/ext/head_ext.html"-->
</head>
<script type="text/javascript">
Ext.onReady(function() {
var cp = new Ext.state.CookieProvider();
Ext.state.Manager.setProvider(cp);
var title_logo_html = "<div style='height:70px;font-size:12px;line-height:50px;>" +
"<center>" +
" <table border=0>" +
"<tr>" +
"<td colspan='2'style='border-bottom:2px groove #fafafa'><center><img src='/DPOA/Image/logo.png'/></center></td>" +
"</tr>" +
"<tr>" +
"<td colspan='2' style='font-size:12px;color:#036010;text-align:center'> OFFICE AUTOMATION SYSTEM</td>" +
"</tr>" +
" </table> " +
"</center>" +
"</div>"
var remark = "<div style='color:#999;font-size:12px;'> " +
"<center>" +
" <table border=0 width='100%'>" +
"<tr>" +
"<td>[小提示]</td>" +
"</tr>" +
"<tr>" +
"<td>使用chrome运行更快</td>" +
"</tr>" +
"<tr>" +
"<td>使用回车键可以快速登录</td>" +
"</tr>" +
"<tr>" +
"<td>记住我小助手可以7天内记住账号和密码</td>" +
"</tr>" +
" </table> " +
"</center>" +
"</div>"
var loginForm = new Ext.FormPanel({
labelWidth: 40, // label settings here cascade unless overridden
frame: true,
title: 'DPONLIE',
bodyStyle: 'padding:5px 5px 0',
width: 350,
height: 500,
buttonAlign: "center",
defaults: { width: 230 },
items: [
{
height: 130,
html: title_logo_html
},
{
xtype: 'fieldset',
title: "请输入你的账号和密码",
labelAlign: 'right',
items: [{
xtype: "textfield",
fieldLabel: '账号',
name: 'username',
allowBlank: false
}, {
xtype: "textfield",
inputType: 'password',
fieldLabel: "密码",
name: 'password',
allowBlank: false
}, {
xtype: "panel",
layout: "column",
fieldLabel: "助手",
isFormField: true,
items: [{
columnWidth: .5,
xtype: "checkbox",
boxLabel: "记住我",
inputValue: "true",
name: "remember"
}]
}]
},
{ html: remark }
],
buttons: [{
text: '确定',
handler: login
}, {
text: '退出',
handler: function() {
window.document.location.href = "http://www.dponline.com.cn";
}
}]
});
function login() {
//window.location = '/UehomeServiceOnLine/views/home';
var remember = loginForm.form.findField("remember").getValue();
var username = loginForm.form.findField("username").getValue();
var password = loginForm.form.findField("password").getValue();
if (remember) {
cp.set("remember", remember);
cp.set("username", username);
cp.set("password", password);
}
else {
cp.clear("remember");
cp.clear("username");
cp.clear("password");
}
loginForm.form.submit({
url: '/DPOA/UserManager/LoginAction.aspx',
waitMsg: '正在登录...',
success: function(form, action) {
window.location = '/DPOA/Main.aspx';
},
failure: function(form, action) {
var msg = "";
try {
msg = action.result.msg;
}
catch (e) {
msg = "登陆超时,请检查您的网络" + e.message;
}
Ext.MessageBox.alert('警告', msg);
}
});
}
var remember = cp.get("remember");
if (remember) {
var remember = loginForm.form.findField("remember").checked = remember
var username = loginForm.form.findField("username").setValue(cp.get("username"));
var password = loginForm.form.findField("password").setValue(cp.get("password"));
}
loginForm.render(document.getElementById("login"));
loginForm.form.findField("username").focus();
var map = new Ext.KeyMap(Ext.getBody(), { key: 13, fn: login });
});
</script>
<table style="width:100%;height:100%">
<tr>
<td>
<center>
<div id="login"></div>
</center>
</td>
</tr>
</table>