problemas al editar y eliminar
Publicado por thinlizzy (2 intervenciones) el 11/07/2017 15:21:39
Tengo un problema quizás sea simple pero no puedo lograr editar un articulo, me muestra dato null (imagen adjunta)
CODIGO EDITAR:
CODIGO DAO:
OJALAAlguien me pueda guiar en este error
CODIGO EDITAR:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="Bean.UserBean"%>
<%@ page import="net.roseindia.dao.UserDao"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>EDITAR USUARIO n</title>
</head>
<body>
<%
UserBean user = new UserBean();
%>
<%
UserDao dao = new UserDao();
%>
<form method="POST" action='UserHandler' name="frmEditUser">
<input type="hidden" name="action" value="edit" /> <%
String uid = request.getParameter("id");
if (!((uid) == null)) {
int id = Integer.parseInt(uid);
user = dao.getUserById(id);
%>
<table>
<tr>
<td>ID MEDICAMENTO</td>
<td><input type="text" name="id" readonly="readonly"
value="<%=user.getId()%>"></td>
</tr>
<tr>
<td>DESCRIPCION</td>
<td><input type="text" name="descripcion" value="<%=user.getfName()%>"/></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="ACTUALIZAR" /></td>
</tr>
</table>
<%
} elseout.println("ID NO ENCONTRADO!!!");
%>
</form>
</body>
</html>
CODIGO DAO:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
package net.roseindia.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import Bean.UserBean;import net.roseindia.dbconnection.ConnectionProvider;
public class UserDao {private Connection conn;
public UserDao() {
conn = ConnectionProvider.getConnection();
}public void addUser(UserBean userBean) {
try {String sql = "INSERT INTO medicamento(id, descripcion)" +
" VALUES (?, ? )";PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, userBean.getId());
ps.setString(2, userBean.getfName());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} }public void removeUser(int userId) {
try {String sql = "DELETE FROM descripcion WHERE id=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, userId);
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} }public void editUser(UserBean userBean) {
try {String sql = "UPDATE medicamento SET descripcion=?" +
" WHERE id=?"; PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, userBean.getfName());
ps.setInt(3, userBean.getId());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} }public List getAllUsers() {
List users = new ArrayList();
try {String sql = "SELECT * FROM medicamento";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
UserBean userBean = new UserBean();
userBean.setId(rs.getInt("id"));
userBean.setfName(rs.getString("descripcion"));
users.add(userBean);
}} catch (SQLException e) {
e.printStackTrace();
}return users;
}public UserBean getUserById(int userId) {
UserBean userBean = new UserBean();
try {String sql = "SELECT * FROM WHERE id=?";
PreparedStatement ps = conn.
prepareStatement(sql);
ps.setInt(1, userId);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
userBean.setId(rs.getInt("id"));
userBean.setfName(rs.getString("descripcion"));
}} catch (SQLException e) {
e.printStackTrace();
}return userBean;
}}OJALAAlguien me pueda guiar en este error
Valora esta pregunta
0
