baza na pewno istnieje! poniewaz łącze sie z nia za pomoca servletów, (troche inny przykład ale za pomoca tego servleta łącze sie z bazą)to jest ich kod:
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class materialy2 extends HttpServlet {
private static final long serialVersionUID = 1L;
public materialy2() {
super();
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws IOException, ClassNotFoundException{
materialy m = new materialy();
PrintWriter out = response.getWriter();
m.connection();
out.println(m.get());
m.close();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
processRequest(request, response);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
processRequest(request, response);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
import java.sql.*;
public class materialy {
private String url;
private String usrname;
private String pass;
private Connection conn;
private Statement stmt;
private ResultSet rset;
//konstruktor klasy poloczenie
public materialy(){
this.url = "jdbc:postgresql://localhost/pjojekt";
this.usrname = "postgres";
this.pass = "13757";
}
//poloczenie do bazy
public void connection() throws ClassNotFoundException{
try {
Class.forName( "org.postgresql.Driver" );
Driver d = new org.postgresql.Driver();
DriverManager.registerDriver(d);
conn = DriverManager.getConnection(this.url,this.usrname, this.pass);
if (conn != null)
System.out.println("Connecting!");
else
System.out.println("We should never get here.");
}catch(Exception ex){
ex.printStackTrace();
}
}
public String get(){
StringBuffer sb = new StringBuffer();
try {
if(conn!=null){
stmt = conn.createStatement();
rset = stmt.executeQuery("select * FROM materialy");
sb.append("<center><table border ='1'>");
sb.append("<center>Przeglad materialow<tr><center><td>Id_mat</td><td><center>Nazwa_materialu</center></td><td>Cena</td></center></tr>");
while(rset.next()){
sb.append("<tr><td>"+rset.getObject(1)+"</td><td>"+rset.getObject(2)+"</td><td>"+rset.getObject(3)+"</td></tr>");
System.out.println(rset.getObject(1)+ " \t"+rset.getObject(2)+"\t"+rset.getObject(3)+"\t");
}
rset.close();
sb.append("</table></center>");
}
}
catch(SQLException ex){
ex.printStackTrace();
}
return sb.toString();
}
public void close (){
try{
if(conn!=null){
this.conn.close();
}
}
catch(SQLException ex){
ex.printStackTrace();
}
}
}