Attachment 849099 Details for Bug 1051349 – script_to_connect_db

script_to_connect_db

mysql.jsp (text/plain), 1.25 KB, created by Meng Bo on 2014-01-13 01:54:11 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Meng Bo

Created: 2014-01-13 01:54:11 UTC

Size: 1.25 KB

patch

obsolete

><%@ page contentType="text/plain" language="java" import="java.sql.*" %>
><%@ page import="javax.naming.*" %>
><%@ page import="java.io.*"  %>
><%@ page import="java.util.*"  %>
><%@ page import="java.text.*"  %>
><%@ page import="javax.naming.*" %>
><%@ page import="javax.sql.*" %>
><%
>String version = request.getParameter("version");
>InitialContext ctx = new InitialContext();
>DataSource ds = (DataSource) ctx.lookup("java:jboss/datasources/MysqlDS");
>Connection connection=ds.getConnection();
>Statement statement = connection.createStatement();
>statement.executeUpdate("CREATE TABLE IF NOT EXISTS factory(id INT UNSIGNED NOT NULL, data TEXT, PRIMARY KEY(id));");
>statement.executeUpdate("COMMIT;");
>ResultSet rscount = statement.executeQuery("SELECT COUNT(*) FROM factory;");
>if(rscount.next()) {
>    if(Integer.parseInt(rscount.getString(1)) == 0) {
>        statement.executeUpdate("INSERT INTO factory VALUES(1, '1');");
>    }
>}
>if(version != null) {
>    statement.executeUpdate("UPDATE factory SET data=" + version + " WHERE id=1;");
>    out.print("The mysql factory is modified");
>}
>else {
>    ResultSet rs = statement.executeQuery("SELECT * FROM factory;");
>    if(rs.next()) {
>        out.print("version " + rs.getString(2));
>    }
>}
>statement.close();
>connection.close();
>%>

Actions: View

Attachments on bug 1051349: 848263 | 849099