http://jexp.ru/index.php?action=history&feed=atom&title=Java_Tutorial%2FJSP%2FDatabase
Java Tutorial/JSP/Database - История изменений
2026-04-07T15:08:13Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://jexp.ru/index.php?title=Java_Tutorial/JSP/Database&diff=5024&oldid=prev
Admin: 1 версия
2010-06-01T05:07:24Z
<p>1 версия</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 05:07, 1 июня 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
Admin
http://jexp.ru/index.php?title=Java_Tutorial/JSP/Database&diff=5023&oldid=prev
в 17:44, 31 мая 2010
2010-05-31T17:44:27Z
<p></p>
<p><b>Новая страница</b></p><div>== Accessing the Database Table ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %><br />
<HTML><br />
<HEAD><br />
<TITLE>Accessing the Publishers Database Table</TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Accessing the Publishers Database Table</H1><br />
<% <br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "UserName", "password");<br />
Statement statement = connection.createStatement() ;<br />
ResultSet resultset = statement.executeQuery("select pub_name from Publishers") ; <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>Name</TH><br />
</TR><br />
<% while(resultset.next()){ %><br />
<TR><br />
<TD> <br />
<%= resultset.getString(1)%> <br />
</TD><br />
</TR><br />
<% } %><br />
</TABLE><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Connect to Database in Servlet ==<br />
<br />
<br />
<br />
<br />
<p>Jsp page</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%--<br />
Copyright (c) 2002 by Phil Hanna<br />
All rights reserved.<br />
<br />
You may study, use, modify, and distribute this<br />
software for any purpose provided that this<br />
copyright notice appears in all copies.<br />
<br />
This software is provided without warranty<br />
either expressed or implied.<br />
--%><br />
<%@ page extends="com.jspcr.servlets.NutrientDatabaseServlet" %><br />
<%--<br />
This JSP page subclasses the NutrientDatabaseServlet<br />
parent class, which automatically loads the<br />
database driver and establishes the connection.<br />
--%><br />
<%@ page import="java.io.*,java.sql.*" %><br />
<html><br />
<head><br />
<title>Food Groups</title><br />
</head><br />
<body><br />
<h1>Food Groups</h1><br />
<table border="1" cellpadding="3" cellspacing="0"><br />
<tr><TH>Code</th><TH>Description</th></tr><br />
<%<br />
// Execute a query<br />
Statement stmt = con.createStatement();<br />
String sql = "SELECT * FROM FD_GROUP ORDER BY FDGP_DESC";<br />
ResultSet rs = stmt.executeQuery(sql);<br />
while (rs.next()) {<br />
String code = rs.getString(1);<br />
String desc = rs.getString(2);<br />
%><br />
<tr><br />
<td><%= code %></td><br />
<td><%= desc %></td><br />
</tr><br />
<%<br />
}<br />
<br />
// Close the database objects<br />
rs.close();<br />
stmt.close();<br />
%><br />
</table><br />
</body><br />
</html></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Creating a Table ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<HTML><br />
<HEAD><br />
<TITLE>Creating a Table</TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Creating a Table</H1><br />
<% <br />
Connection connection = null;<br />
try {<br />
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();<br />
connection = DriverManager.getConnection("jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement();<br />
String command = "CREATE TABLE Employees (ID INTEGER, Name CHAR(50));";<br />
statement.executeUpdate(command);<br />
} catch (Exception e) {<br />
out.println("An error occurred.");<br />
}<br />
%><br />
The Employees table was created.<br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Database Table Navigation Based On Form ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %><br />
<HTML><br />
<HEAD><br />
<TITLE>Navigating in a Database Table </TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Navigating in a Database Table </H1><br />
<FORM NAME="form1" ACTION="basic.jsp" METHOD="POST"><br />
<% <br />
int current = 0;<br />
if(request.getParameter("hidden") != null) {<br />
current = Integer.parseInt(request.getParameter("hidden"));<br />
}<br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement();<br />
ResultSet resultset = <br />
statement.executeQuery("select * from Publishers"); <br />
for(int i = 0; i <= current; i++){<br />
resultset.next();<br />
}<br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>ID</TH><br />
<TH>Name</TH><br />
<TH>City</TH><br />
<TH>State</TH><br />
<TH>Country</TH><br />
</TR><br />
<TR><br />
<TD> <%= resultset.getString(1) %> </TD><br />
<TD> <%= resultset.getString(2) %> </TD><br />
<TD> <%= resultset.getString(3) %> </TD><br />
<TD> <%= resultset.getString(4) %> </TD><br />
<TD> <%= resultset.getString(5) %> </TD><br />
</TR><br />
</TABLE><br />
<BR><br />
<INPUT TYPE="HIDDEN" NAME="hidden" VALUE="<%= current %>"><br />
<INPUT TYPE="BUTTON" VALUE="Next Record" ONCLICK="moveNext()"><br />
</FORM><br />
<SCRIPT LANGUAGE="JavaScript"><br />
<!--<br />
function moveNext()<br />
{<br />
var counter = 0<br />
counter = parseInt(document.form1.hidden.value) + 1<br />
document.form1.hidden.value = counter<br />
form1.submit()<br />
} <br />
// --> <br />
</SCRIPT><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Insert data to a table ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<HTML><br />
<HEAD><br />
<TITLE>Filling a Table</TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Filling a Table</H1><br />
<% <br />
Connection connection = null;<br />
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br />
connection = DriverManager.getConnection("jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement();<br />
String command = "INSERT INTO Employees (ID, Name) VALUES (1, "Tom")";<br />
statement.executeUpdate(command);<br />
command = "INSERT INTO Employees (ID, Name) VALUES (2, "Peter")";<br />
statement.executeUpdate(command);<br />
ResultSet resultset = statement.executeQuery("select * from Employees");<br />
while(resultset.next()){ <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>ID</TH><br />
<TH>Name</TH><br />
</TR><br />
<TR><br />
<TD> <%= resultset.getString(1) %> </TD><br />
<TD> <%= resultset.getString(2) %> </TD><br />
</TR><br />
</TABLE><br />
<% <br />
} <br />
%><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Joining Tables ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %><br />
<HTML><br />
<HEAD><br />
<TITLE>Joining Tables</TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Joining Tables</H1><br />
<% <br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement();<br />
String query = "SELECT authors.au_fname, authors.au_lname, titleauthor.title_id " +<br />
"FROM authors INNER JOIN titleauthor ON authors.au_id = titleauthor.au_id";<br />
ResultSet resultset = <br />
statement.executeQuery(query) ; <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>First Name</TH><br />
<TH>Last Name</TH><br />
<TH>Book ID</TH><br />
</TR><br />
<% while(resultset.next()){ %><br />
<TR><br />
<TD> <%= resultset.getString(1) %></TD><br />
<TD> <%= resultset.getString(2) %></TD><br />
<TD> <%= resultset.getString(3) %></TD><br />
</TR><br />
<% } %><br />
</TABLE><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Make Database connection ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %><br />
<HTML><br />
<HEAD><br />
<TITLE>The Publishers Database Table </TITLE><br />
</HEAD><br />
<BODY><br />
<H1>The Publishers Database Table </H1><br />
<% <br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "userName", "password");<br />
Statement statement = connection.createStatement() ;<br />
ResultSet resultset = statement.executeQuery("select * from Publishers") ; <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>ID</TH><br />
<TH>Name</TH><br />
<TH>City</TH><br />
<TH>State</TH><br />
<TH>Country</TH><br />
</TR><br />
<% while(resultset.next()){ %><br />
<TR><br />
<TD> <%= resultset.getString(1) %></td><br />
<TD> <%= resultset.getString(2) %></TD><br />
<TD> <%= resultset.getString(3) %></TD><br />
<TD> <%= resultset.getString(4) %></TD><br />
<TD> <%= resultset.getString(5) %></TD><br />
</TR><br />
<% } %><br />
</TABLE><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Navigate Database Table With Javascript and JSP ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %><br />
<HTML><br />
<HEAD><br />
<TITLE>Navigating in a Database Table </TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Navigating in a Database Table </H1><br />
<FORM NAME="form1" ACTION="basic.jsp" METHOD="POST"><br />
<% <br />
int current = 1;<br />
if(request.getParameter("hidden") != null) {<br />
current = Integer.parseInt(request.getParameter("hidden"));<br />
}<br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement(<br />
ResultSet.TYPE_SCROLL_INSENSITIVE,<br />
ResultSet.CONCUR_READ_ONLY);<br />
ResultSet resultset = statement.executeQuery("select * from Publishers"); <br />
if(current < 1){<br />
current = 1;<br />
}<br />
resultset.last();<br />
int rows = resultset.getRow();<br />
if(current <= rows){<br />
resultset.absolute(current);<br />
} <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>ID</TH><br />
<TH>Name</TH><br />
<TH>City</TH><br />
<TH>State</TH><br />
<TH>Country</TH><br />
</TR><br />
<TR><br />
<TD> <%= resultset.getString(1) %> </TD><br />
<TD> <%= resultset.getString(2) %> </TD><br />
<TD> <%= resultset.getString(3) %> </TD><br />
<TD> <%= resultset.getString(4) %> </TD><br />
<TD> <%= resultset.getString(5) %> </TD><br />
</TR><br />
</TABLE><br />
<BR><br />
<INPUT TYPE="HIDDEN" NAME="hidden" VALUE="<%= current %>"><br />
<INPUT TYPE="BUTTON" VALUE="Next Record" ONCLICK="moveNext()"><br />
<INPUT TYPE="BUTTON" VALUE="Previous Record" ONCLICK="movePrevious()"><br />
</FORM><br />
<SCRIPT LANGUAGE="JavaScript"><br />
<!--<br />
function moveNext()<br />
{<br />
var counter = 0<br />
counter = parseInt(document.form1.hidden.value) + 1<br />
document.form1.hidden.value = counter<br />
form1.submit()<br />
} <br />
function movePrevious()<br />
{<br />
var counter = 0<br />
counter = parseInt(document.form1.hidden.value) - 1<br />
document.form1.hidden.value = counter<br />
form1.submit()<br />
} <br />
// --> <br />
</SCRIPT><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Output data in database as XML ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page contentType="application/xml" import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %><br />
<?xml version="1.0"?><br />
<publishers><br />
<% <br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement() ;<br />
ResultSet resultset = statement.executeQuery("select name, id from Publishers");%><br />
<% <br />
while(resultset.next()){ <br />
%><br />
<publisher><br />
<<%=resultset.getMetaData().getColumnName(1)%>> <br />
<% <br />
String s = resultset.getString(1);<br />
int index = s.indexOf("&");<br />
StringBuffer sb = new StringBuffer(s);<br />
if(index > 0){<br />
sb.replace(index, index + 1, "and");<br />
}<br />
out.println(sb);<br />
%> <br />
</<%=resultset.getMetaData().getColumnName(1)%>> <br />
<<%=resultset.getMetaData().getColumnName(2)%>> <br />
<%= resultset.getString(2) %><br />
</<%=resultset.getMetaData().getColumnName(2)%>> <br />
</publisher><br />
<% <br />
} <br />
%><br />
</publishers></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Output ResultSet ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %><br />
<HTML><br />
<HEAD><br />
<TITLE>Selecting Publishers From a Database</TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Selecting Publishers From a Database</H1><br />
<% <br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "userName", "password");<br />
Statement statement = connection.createStatement() ;<br />
ResultSet resultset = statement.executeQuery("select * from Publishers where city = "Boston"") ; <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH>ID</TH><br />
<TH>Name</TH><br />
<TH>City</TH><br />
<TH>State</TH><br />
<TH>Country</TH><br />
</TR><br />
<% while(resultset.next()){ %><br />
<TR><br />
<TD> <%= resultset.getString(1) %></td><br />
<TD> <%= resultset.getString(2) %></TD><br />
<TD> <%= resultset.getString(3) %></TD><br />
<TD> <%= resultset.getString(4) %></TD><br />
<TD> <%= resultset.getString(5) %></TD><br />
</TR><br />
<% } %><br />
</TABLE><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
== Retrieve data in Database based on form input ==<br />
<br />
<br />
<br />
<br />
<p>index.jsp</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<HTML><br />
<HEAD><br />
<TITLE>Database Lookup</TITLE><br />
</HEAD><br />
<br />
<BODY><br />
<H1>Database Lookup</H1><br />
<FORM ACTION="basic.jsp" METHOD="POST"><br />
Please enter the ID of the publisher you want to find:<br />
<BR><br />
<INPUT TYPE="TEXT" NAME="id"><br />
<BR><br />
<INPUT TYPE="SUBMIT" value="Submit"><br />
</FORM><br />
</BODY><br />
<HTML></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Using Table Metadata ==<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<%@ page import="java.sql.*" %><br />
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %><br />
<HTML><br />
<HEAD><br />
<TITLE>Using Table Metadata</TITLE><br />
</HEAD><br />
<BODY><br />
<H1>Using Table Metadata</H1><br />
<% <br />
Connection connection = DriverManager.getConnection(<br />
"jdbc:odbc:data", "YourName", "password");<br />
Statement statement = connection.createStatement() ;<br />
ResultSet resultset = statement.executeQuery("select * from Publishers") ; <br />
%><br />
<TABLE BORDER="1"><br />
<TR><br />
<TH><%= resultset.getMetaData().getColumnName(1)%></TH><br />
<TH><%= resultset.getMetaData().getColumnName(2)%></TH><br />
<TH><%= resultset.getMetaData().getColumnName(3)%></TH><br />
<TH><%= resultset.getMetaData().getColumnName(4)%></TH><br />
<TH><%= resultset.getMetaData().getColumnName(5)%></TH><br />
</TR><br />
<% while(resultset.next()){ %><br />
<TR><br />
<TD> <%= resultset.getString(1) %></td><br />
<TD> <%= resultset.getString(2) %></TD><br />
<TD> <%= resultset.getString(3) %></TD><br />
<TD> <%= resultset.getString(4) %></TD><br />
<TD> <%= resultset.getString(5) %></TD><br />
</TR><br />
<% } %><br />
</TABLE><br />
</BODY><br />
</HTML></source><br />
<br />
<br />
<!-- end source code --></div>