I am currently trying to make an update application (Java based) that the user can go through and view the existing database entries (MySQL) and edit them if need be… I was wondering how to get the information for a specific entry (ie 12-1589 which is an example of what the ID or primary key would be) and fill in the text boxes with all of the information from said entry…. I may just need to walk away from the computer for a bit because i may be over-thinking it, but I don’t know…<\/p>\n
mainly i am unsure with the exact code that you would use to move to that entry and retrieve the data from just that entry…. I know how to step trough a database one entry at a time, but i would rather just jump to a specific row based off of an id number (such as above 12-1589) if at all possible….<\/p>\n
I just tried this and i recieved an error…. The error was: “Unknown column ’12-1859′ in ‘where clause'”<\/p>\n
con = DriverManager.getConnection(host, uName, uPass);\nstmt = con.createStatement(); \nString sql = \"SELECT * FROM Load_Sheet WHERE Load_Number = 12-1859 limit 1\";\nrs = stmt.executeQuery(sql);\nString BC = rs.getString(\"BC\");\n<\/code><\/pre>\nIf anyone could give me a hand with that is going wrong i would appreciate it…<\/p>\n
I just started getting another error along with the other one… it is : “illegal operation on empty result set”<\/p>\n
Though the result sets are not empty so my guess is, is that i am missing a step somewhere….<\/p>\n
\n- \n
What you need is a simple WHERE<\/code> statement if i understood correctly your question.<\/p>\nSELECT * FROM table_name WHERE entry_col = \"12-1589\" LIMIT 1\n<\/code><\/pre>\nLIMIT 1<\/code> is only added so that the MySql<\/code> query only returns a single row.<\/p>\n<\/li>\n<\/ol>\nOriginally posted 2013-12-02 21:18:19. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
I am currently trying to make an update application (Java based) that the user can go through and view the existing database entries (MySQL) and edit them if need be… I was wondering how to get the information for a specific entry (ie 12-1589 which is an example of what the ID or primary key […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1920","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1920","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1920"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1920\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}