Membuat Form Login
➢
Setelah
semua menu selesai dibuat tambahkan laporan, proses selanjutnya adalah
pembuatan login aplikasi. Berikut adalah tampilan dari fom login.
<%@page
import="java.util.Calendar"%>
<%@page
import="java.text.SimpleDateFormat"%>
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<%@taglib prefix="c"
uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql"
uri="http://java.sun.com/jsp/jstl/sql"%>
<sql:setDataSource var="dataSource"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/sia"
user="root" password=""
/>
<!DOCTYPE html>
<!DOCTYPE html>
<STYLE TYPE="text/css">
TD
{
font-family: Arial, Helvetica, sans-serif;
font-size: 10pt; text-align: center;
}
.hariSekarang
{
color: #FF0000; background-color: #EEEEEE;
}
.hariLainnya
{
color: #666699; background-color: #EEEEEE;
}
.dayHeading
{
font-size: 9pt; color: #666699;
}
.titleStyle
{
font-size: 14pt; color: #FFFFFF;
background-color: #666699; text-align: center;
font-weight: bold;
}
</STYLE>
<html>
<head>
<script type="text/javascript"
>
function validate()
{
if (document.frm.username.value ==
"")
{
alert("Please enter username");
document.frm.username.focus();
return false;
}
if (document.frm.password.value ==
"")
{
alert("Please enter password");
document.frm.password.focus();
return false;
}
return true;
}
function trim(stringToTrim) {
return stringToTrim.replace(/^\s+|\s+$/g,
"");
}
</script>
<meta http-equiv="Content-Type"
content="text/html; charset=UTF-8">
<title>Sistem Informasi Akuntansi
1.0</title>
<link rel="stylesheet"
type="text/css" href="config/style.css" media="screen"
/>
<script type="text/javascript"
src="config/setting.js"></script>
</head>
<body>
<%-- awal dari halaman web --%>
<div id="wrap">
<div id="header"><%-- awal
header --%>
<img
src="image/logo-universitas-bina-sarana-informatika-ubsi.png"><%--
gambar silahkan massukkan logo BSI --%>
<h1><a>Sistem Informasi
Akuntansi</a></h1>
<h2>Universitas Bina Sarana
Informatika</h2>
<%-- mahasiswa wajib mengganti alamat
kampus msg2 --%>
<h2>Jl. Cilebut Raya No.29,
Bogor</h2>
<%-- mahasiswa wajib mengganti dengan nama
masing2 --%>
<h3>Programmer by. Konsorsium Program
Studi Sistem Informasi Akuntansi</h3>
</div><%-- akhir dari header --%>
<div id="menu"><%-- awal
dari menu atas --%>
<ul>
<marquee
behavior="alternate">Aplikasi ini dikembangkan oleh tim
pemrograman visual akuntansi</marquee>
</ul>
</div><%-- akhir dari menu atas
--%>
<div id="content"><%-- awal
dari isi content --%>
<div class="left"
id="drop-nav"> <%-- awal dari content sebelah kiri web --%>
<h2>Security System</h2>
<ul>
<div id="wrap">
<%
String errmsg = "";
if (request.getParameter("errmsg")
!= null
&&
request.getParameter("errmsg") != "") {
errmsg = "Invalid username and
password";
} else {
errmsg = " ";
}
%>
<form name="frm"
onSubmit="return validate();"
action="checkLogin.jsp"
method="post">
<font size="3" face="comic
sans ms">User Login</font><br>
<input type="text"
name="txtUsername" id="username"
size="10"><br>
<font size="3" face="comic
sans ms">Password</font><br>
<input type="password"
name="txtPassword" id="password"
size="15"><br>
<input type="submit"
name="sSubmit" value="Login" id="login"/>
<form name="frm"
onSubmit="return validate();"
action="checkbatal.jsp"
method="post">
<input type="reset"
name="sSubmit" value="Batal"
id="batal"/><br>
</td></tr>
</form>
</div>
</ul>
<h2>Today</h2>
<ul>
<%--modif href pasce atur aksi--%>
<%--perubahan agar aksi simpan dapat
bekerja--%>
<%!
public String FormatTitle(java.util.Calendar
thisCal) {
SimpleDateFormat formatter = new
java.text.SimpleDateFormat("d MMMMMMMMM yyyy");
return (formatter.format(thisCal.getTime()));
}
Calendar currentCal = Calendar.getInstance();
%>
<TABLE BORDER='0' CELLPADDING='1'
CELLSPACING='2'id="tanggalweb" width="100px"
id="tanggalan">
<TR>
<TD CLASS='titleStyle' COLSPAN='7'>
<%= FormatTitle(currentCal)%>
</TD>
</TR>
<TR>
<TD width=15%
CLASS='dayHeading'>Sen</TD>
<TD width=15%
CLASS='dayHeading'>Sel</TD>
<TD width=15%
CLASS='dayHeading'>Rab</TD>
<TD width=15%
CLASS='dayHeading'>Kam</TD>
<TD width=15%
CLASS='dayHeading'>Jum</TD>
<TD width=15%
CLASS='dayHeading'>Sab</TD>
<TD width=15%
CLASS='dayHeading'>Min</TD>
</TR>
<%
int currentDay =
currentCal.get(currentCal.DAY_OF_MONTH);
int daysInMonth =
currentCal.getActualMaximum(currentCal.DAY_OF_MONTH);
currentCal.set(currentCal.DAY_OF_MONTH, 0);
int dayOfWeek =
currentCal.get(currentCal.DAY_OF_WEEK);
if (dayOfWeek != 1) {
out.println(" <TD COLSPAN=" +
(dayOfWeek - 1) + "> </TD>");
}
for (int day = 1; day <= daysInMonth;
day++) {
if (day == currentDay) {
out.println(" <TD
CLASS='hariSekarang'>" + day + "</TD>");
} else {
out.println(" <TD
CLASS='hariLainnya'>" + day + "</TD>");
}
if (dayOfWeek == 7) {
out.println(" </TR>\n\n
<TR>");
dayOfWeek = 1;
} else {
dayOfWeek++;
}
}
if ((8 - dayOfWeek) != 0) {
out.println(" <TD COLSPAN=" + (8
- dayOfWeek) + "> </TD>");
}
%>
</TABLE>
</ul>
</div> <%-- akhir dari content
sebelah kiri web --%>
<div class="right"> <%-- awal
dari content sebelah kanan web --%>
<table width="100%">
<tr>
<td valign="top"
width="110%">
<H2>SELAMAT DATANG DI WEB PENGOLAHAN
DATA KEUANGAN</H2>
</td>
</tr>
</table>
<div class="footer"> <%--
awal dari content footer web --%>
Support by <a href="http://bsi.ac.id/">Junior
Programmer
Mahasiswa Program Studi Komputerisasi
Akuntansi</a>,
Thanks to Layout menu utama menggunakan CSS
</div><%-- akhir dari content footer
web --%>
</div><%-- akhir dari content sebelah
kanan web --%>
<div style="clear: both;">
</div>
</div>
</div> <%-- akhir dari halaman web
--%>
</body>
2. Buatlah
Form checkLogin.jsp dengan kodingan sebagai berikut:
<%@page
import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.* "%>
<%@page
import="sess.ion.dao.UserDao"%>
<%@page
import="sess.ion.bean.User"%>
<%
UserDao sd = new UserDao();
User s = new User();
String user =
request.getParameter("txtUsername");
String password =
request.getParameter("txtPassword");
s.setUsername(user);
s.setPassword(password);
String hasil = sd.cek(s);
if (hasil == "1") {
out.println(hasil);
String sUserName = s.getUsername() +
s.getPassword();
out.println("Berhasil : " +
sUserName);
session.setAttribute("username",
s.getUsername());
response.sendRedirect("beranda.jsp");
} else {
//out.println(hasil);
//String sUserName = s.getUsername() +
s.getPassword();
//out.println("Gagal : " +
sUserName);
response.sendRedirect("index.jsp?errmsg=error");
}
String userid = (String)
session.getAttribute("username");
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/sia",
"root", "");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select *
from admin where user_name='" + userid + "'");
if (rs.next()) {
session.setAttribute("status",
rs.getString("hak_akses"));
session.setAttribute("nama",
rs.getString("nama_lengkap"));
}
%>
Tidak ada komentar:
Posting Komentar