Pagi dunsanak,..
Mohon bantuan dunsanak.. entah apa yang salah dalam script program ini????????
disini saya menggunakan javaNetBean 7.3 dan database xampp mysql,..
Gambar
1. Tampilan data user.
Gambar
2. Form edit(update) data user.
Scrip
program :
<%--
Form Update--%>
<%
String username =
request.getParameter("username");
String password =
request.getParameter("password");
String level=
request.getParameter("level");
String nama =
request.getParameter("nama");
String email =
request.getParameter("email");
String paraAksi=
request.getParameter("Aksi");
if (
username==null || password==null || level==null || nama==null || email==null )
out.println("Data Tidak
Lengkap...<BR>");
%>
<%@page import="java.util.*"
%>
<body>
<form
action="simpan-user.jsp" method="post"
name="frmuser">
<center>
<h4>Edit User</h4>
<table border="0"
align="center">
<tr>
<td>Username</td><td>:</td>
<td><input
type="text" name="username" id="username"
value="<%=username%>"></td>
</tr>
<tr>
<td>Password
</td><td>:</td>
<td><input
type="text" name="password" id="password"
value="<%=password%>"></td>
</tr>
<tr>
<td>Level</td><td>:</td>
<td><input
type="text" name="level" id="level"
value="<%=level%>"></td>
</tr>
<tr>
<td>Nama
</td><td>:</td>
<td><input
type="text" name="nama" id="nama"
value="<%=nama%>"></td>
</tr>
<tr>
<td>Email</td><td>:</td>
<td><input
type="text" name="email" id="email"
value="<%=email%>"></td>
</tr>
<tr>
<td
colspan="3" align="center">
<input
type="submit" name="Aksi" value="Update"/>
<input
type="reset" name="reset" value="Batal"/>
<input type=button
value="Back" onCLick="history.back()">
</td>
</tr>
</table>
</center>
</form>
Gambar
3. Proses simpan (eror).
Scrip
program:
<%@page language="java"
import="java.sql.*" %>
<%
String no_user = request.getParameter("no_user");
String username = request.getParameter("username");
String password = request.getParameter("password");
String level= request.getParameter("level");
String nama = request.getParameter("nama");
String email = request.getParameter("email");
String paraAksi= request.getParameter("Aksi");
//set no_user
int i=0,akhir=0;
String strNoUser="USR";
Class.forName("com.mysql.jdbc.Driver");
Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbstokdarah","root","");
Statement smtU = con.createStatement();
ResultSet rs = smtU.executeQuery("SELECT * FROM user");
if(rs.last()){
int lebarNoUser =
rs.getString("no_user").length();
String
a=String.valueOf(rs.getString("no_user").substring(3,lebarNoUser));
akhir = Integer.parseInt(a);
}
if (akhir==0){
no_user=strNoUser+"1";
}else{
for(i=1; i<=akhir; i++){
Statement smtCari =
con.createStatement();
ResultSet rsCari =
smtCari.executeQuery("SELECT * FROM user WHERE
no_user='USR"+i+"'");
if(!rsCari.next()){
//jika tidak ketemu maka
disimpulkan sedang tidak dipakai(alias tersedia)
no_user=String.valueOf(strNoUser+i);
break;
}else {
no_user=String.valueOf(strNoUser+(i+1));
}
out.println("halo, i
ke:"+i+" dan no_user ke:"+no_user);
}
}
out.println("hai, i
ke:"+i+" dan no_user ke:"+no_user);
if (no_user==null)
out.println("Data Tidak Lengkap... <BR>");
else
{
try
{
Statement
smt=con.createStatement();
if
(paraAksi.equals("Simpan")==true)
{
smt.executeUpdate("insert
into user ( no_user, username, password, level, nama, email ) values" +
"('"+no_user+"','"+username+"',
'"+password+"','"+level+"',
'"+nama+"','"+email+"')");
response.sendRedirect("data-admin-user.jsp?");
}
else
{
smt.executeUpdate("update
user set username='"+username+"',
password='"+password+"', level='"+level+"',
nama='"+nama+"', email='"+email+"'");
response.sendRedirect("data-admin-user.jsp?");
}
}
catch (Exception e1) {
out.println(e1);
}
}
%>
-----------------------------------------------------------------------------------------
...dan berikut databasenya, tabel user :
Gambar 4. Database tabel user
Gambar 5. Struktur database tabel user
Tidak ada komentar:
Posting Komentar