Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <%@page import="java.sql.Connection, java.sql.PreparedStatement" %>
- <%@page import="java.sql.SQLException,java.sql.DriverManager" %>
- <html>
- <head>
- <title>JSP Page</title>
- </head>
- <body>
- <%!
- Connection baglanti=null;
- PreparedStatement ifade=null;
- boolean oto;
- String tcNo,ogrNo,ogrAd,ogrSoyad,bolum,ogrAdres;
- int sinif;
- %>
- <%
- try{
- tcNo=request.getParameter("tcno");
- ogrNo=request.getParameter("ogrno");
- ogrAd=request.getParameter("ad");
- ogrSoyad=request.getParameter("soyad");
- bolum=request.getParameter("bolum");
- try{
- Class.forName("org.postgresql.Driver");
- }catch(ClassNotFoundException e){
- out.println("Jdbc driveri yukelenemedi");
- }
- try{
- sinif=Integer.valueOf(request.getParameter("sinif"));
- }catch(Exception e){
- out.println("Sinif integer deger olmali");
- }
- ogrAdres=request.getParameter("adres");
- baglanti=DriverManager.getConnection("jdbc:postgresql://127.0.1:5432/postgres", "postgres", "ethemsulan");
- oto=baglanti.getAutoCommit();
- baglanti.setAutoCommit(false);
- ifade=baglanti.prepareStatement("insert into ogrencikayit(otc,ono,oad,osoyad,obolum,osinif,oadres) values(?,?,?,?,?,?,?) ");
- ifade.setString(1, tcNo);
- ifade.setString(2, ogrNo);
- ifade.setString(3, ogrAd);
- ifade.setString(4, ogrSoyad);
- ifade.setString(5, bolum);
- ifade.setInt(6, sinif);
- ifade.setString(7, ogrAdres);
- ifade.executeUpdate();
- baglanti.commit();
- }catch(SQLException e){
- baglanti.rollback();
- out.println("sql hatasi");
- }finally{
- ifade.close();
- baglanti.close();
- baglanti.setAutoCommit(oto);
- out.println("kayit basariyla gerceklesti");
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement