when trying to get data from specified column from table. getting the titled error. but when selecting all column it runs fine.
my table data like below.
| area | jobcode |
| ——– | ——– |
| 101 | le21m540 |
| 101 | le21m540 |
java program
<code>public String getAllSelection(String s)
{
List<String> values = new ArrayList<>();
try {
String sql="select jobcode from new_permit where submited_by=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,s);
java.sql.ResultSet rs = ps.executeQuery();
while(rs.next())
{
int i=rs.getInt(1);
values.add(Integer.toString(i));
values.add(rs.getString(2));
values.add(rs.getString(3));
values.add(rs.getString(4));
values.add(rs.getString(5));
values.add(rs.getString(6));
values.add(rs.getString(7));
values.add(rs.getString(8));
values.add(rs.getString(9));
values.add(rs.getString(10));
values.add(rs.getString(11));
values.add(rs.getString(12));
}
}
catch(Exception e)
{
e.printStackTrace();
}
return values.toString();
}
</code>
<code>public String getAllSelection(String s)
{
List<String> values = new ArrayList<>();
try {
String sql="select jobcode from new_permit where submited_by=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,s);
java.sql.ResultSet rs = ps.executeQuery();
while(rs.next())
{
int i=rs.getInt(1);
values.add(Integer.toString(i));
values.add(rs.getString(2));
values.add(rs.getString(3));
values.add(rs.getString(4));
values.add(rs.getString(5));
values.add(rs.getString(6));
values.add(rs.getString(7));
values.add(rs.getString(8));
values.add(rs.getString(9));
values.add(rs.getString(10));
values.add(rs.getString(11));
values.add(rs.getString(12));
}
}
catch(Exception e)
{
e.printStackTrace();
}
return values.toString();
}
</code>
public String getAllSelection(String s)
{
List<String> values = new ArrayList<>();
try {
String sql="select jobcode from new_permit where submited_by=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,s);
java.sql.ResultSet rs = ps.executeQuery();
while(rs.next())
{
int i=rs.getInt(1);
values.add(Integer.toString(i));
values.add(rs.getString(2));
values.add(rs.getString(3));
values.add(rs.getString(4));
values.add(rs.getString(5));
values.add(rs.getString(6));
values.add(rs.getString(7));
values.add(rs.getString(8));
values.add(rs.getString(9));
values.add(rs.getString(10));
values.add(rs.getString(11));
values.add(rs.getString(12));
}
}
catch(Exception e)
{
e.printStackTrace();
}
return values.toString();
}
<code>@WebServlet("/ApprovalData")
public class ApprovalData extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// TODO Auto-generated method stub
try {
HttpSession session=req.getSession();
String user=req.getParameter("user");
NewPermitDao dao=new NewPermitDao(DBConnect.getConn());
String list=dao.getAllSelection(user);
System.out.println(list);
}
catch(Exception e) {
e.printStackTrace();
}
}
}
</code>
<code>@WebServlet("/ApprovalData")
public class ApprovalData extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// TODO Auto-generated method stub
try {
HttpSession session=req.getSession();
String user=req.getParameter("user");
NewPermitDao dao=new NewPermitDao(DBConnect.getConn());
String list=dao.getAllSelection(user);
System.out.println(list);
}
catch(Exception e) {
e.printStackTrace();
}
}
}
</code>
@WebServlet("/ApprovalData")
public class ApprovalData extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// TODO Auto-generated method stub
try {
HttpSession session=req.getSession();
String user=req.getParameter("user");
NewPermitDao dao=new NewPermitDao(DBConnect.getConn());
String list=dao.getAllSelection(user);
System.out.println(list);
}
catch(Exception e) {
e.printStackTrace();
}
}
}
New contributor
Aditya Anand is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.