Imam ovde jedan banalan pocetnicki primer, pa mogu da ti dam kod kako je nesto najelementarnije uradjeno.
klasa koja pravi konekciju za bazu:
Code:
package paket1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Konekcija {
public static Connection getConnection() {
Connection connection = null;
try {
// Load the JDBC driver
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
// Create a connection to the database
String serverName = "127.0.0.1";
String portNumber = "1521";
String sid = "mydatabase";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
String username = "username";
String password = "password";
connection = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
// Could not find the database driver
} catch (SQLException e) {
// Could not connect to the database
}
return connection;
}
public static void closeConnection(Connection connection) {
try {
if (connection != null) {
connection.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
kod klase koja izvlaci podatke iz baze
Code:
package paket1;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
public class Baza {
public ArrayList getData(){
ArrayList rezultat = new ArrayList();
Connection conn = null;
try{
conn = Konekcija.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM korisnik");
int i = 0;
while (rs.next()) {
Korisnik kors = new Korisnik();
String userName = rs.getString("korisnickoime");
String firstName = rs.getString("ime");
String lastName = rs.getString("prezime");
kors.setUsername(userName);
kors.setName(firstName);
kors.setLastName(lastName);
rezultat.add(i, kors);
i++;
}
}catch (Exception e) {
e.printStackTrace();
} finally {
Konekcija.closeConnection(conn);
}
return rezultat;
}
klasa koja se koristi za prenos podataka (Java Bean)
Code:
package paket1;
public class Korisnik {
private String username;
private String name;
private String lastName;
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
}
i na kraju jedna JSP strana:
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<h1>Tripovanje ubacivanje </h1>
<table border="1">
<%
paket1.Baza baza = new paket1.Baza();
java.util.ArrayList rezultat = baza.getData();
java.util.Iterator it = rezultat.iterator();
while(it.hasNext()){
paket1.Korisnik kor = (paket1.Korisnik)it.next();
%>
<tr>
<td>
<%=kor.getUsername()%>
</td>
<td>
<%=kor.getName()%>
</td>
<td>
<%=kor.getLastName()%>
</td>
</tr>
<% } %>
</table>
</body>
</html>
ovo je jedan najobicniji primer i ima dosta stvari koje mogu mnogo bolje da se urade kao i stvari koje se nikada ne rade kao ja sto sam ovde dao, na primer se tezi tome da JSP sadrzi samo HTML i JSP kod a ne JAVA kod kao sto sam ja prilozio. Inace posto si pocetnik nisam hteo da ti dam neki primer sa nekim framework-om (Struts, Spring...) jer je komplikovanije i ne moze da stane u jedan post... Tako da ces to morati sama dalje.
Jim je vec dao link sa postovima na ovu temu i tamo ces da vidis sta sve treba da bi to radilo...
Pozdrav