I do not want to insert INSERT in the table
so I have 2 this code is And it gives me errors about queries: Error: Your query contains an error JTextField < / Code> s and I want to add variables that I add to the
JTextfield s int table but in condition that they are not present in the table
try {connection conn = DriverManager.getConnection ("jdbc: mysql: // localhost: 3306 /" + db, "root", "123456"); Stmt = conn.createStatement (); + "Where is not present (select * from router)" + + "Choose from edge edge =" + + jTextField1.getText () + "'' router. And edge 0 = '' + jTextField2.getText () + "')"); } Hold (SQLException pre) {Logger.getLogger (bdd.class.getName ()). Log (Level.SEVERE, null, ex); }
SEVERE: null
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: there is an error in your SQL syntax; Check the manual related to your MySQL server version for the correct syntax to use from the 'where not available (select * from the router) where the edge is the edge, and' edge '= 2' / div>
try {connection conn = DriverManager.getConnection ("Jdbc: mysql: // Localhost: 3306 / "+ db," root "," 123456 "); Stmt = conn.createStatement (); Stmt.executeUpdate ("enter router (edge01, edge02) \ n" + "edge edge, choose edge 0 & lt; in some unique fields & gt; (router from" & lt; some unique Field & gt; Select where edge edge = '' + jTextField1.getText () + "'and edge02 =' + jTextField2.getText) +" ') "}} Grip (before preclosure) {logger.get logger (bdd .class.getName ()). Logs (level .SESEE, ANNEL, X);}
No comments:
Post a Comment