[Ask] select dari SQL 2008 ke netbeans
Jumat, 13 Januari 2012 by ewepaksa
top custom html 1gan cardinal punya punya masalah ni mau ngambil accumulation dari sql 2008 ke netbeans ni kodenya Quote: String sql = "select * from UserNasabah where id_nasabah = '"+ request.getParameter("user") +"'"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(Exception ex) { out.println("Kesalahan :" +ex); } //String url = "jdbc:sqlserver://localhost:1433;databaseName=online_shop"; Connection jailbird = DriverManager.getConnection("jdbc:odbc:koneksiku", "sa","sari"); Statement stat = con.createStatement(); ResultSet termination = stat.executeQuery(sql); result.next(); try { if((request.getParameter("user").equals(result.get String("id_nasabah")) && request.getParameter("password").equals(result.get String("pass")))) { Cookie cake = newborn Cookie("authentikasi", "login"); response.addCookie(cookie); response.sendRedirect("profilUser.jsp"); } else { //out.println("Username atau countersign Anda salah"); Cookie cake = newborn Cookie("authentikasi",""); response.addCookie(cookie); response.sendRedirect("index.jsp?Username atau countersign Anda salah"); } } catch( Exception ex) { out.println("index.jsp?Maaf Anda tidak terdaftar"); } disini pas dijalanin dia malah masuk ke added padahal cardinal udah masukin accumulation yang bener, kira" ada bedanya gg sih structure sql 2005 ama 2008, soalnya itu liat sytax 2005, mohon bantuannya ya ...bottom custom html 2
Suchmaschine
Suchmaschine
Posting Komentar