1. Location:
  2. / Computer learning >> Computer læring >> Kendskab til programmering >> Programmeringssprog >> java >>

lox database adgang

, denne forelæsning antager, du har en god forståelse for, hvordan jdbc anvendelse fungerer.før behandlingen med adgang til databaser via en lox, være sikker på, at du har en ordentlig jdbc miljø har sammen med en database. for flere detaljer om, hvordan man får adgang til databasen med jdbc og dens miljø arrangement, du kan gå igennem vores jdbc tutor. til at begynde med grundlæggende koncept, lad os skabe en enkelt tabel og skabe flere registreringer i tabel som følger: skabe tabel, at skabe de ansatte, tabel i - database, anvendes følgende trin:, trin 1:, åbne, kommando omgående, og at ændre montering fortegnelse som følger:, c) > c) > cd - filer. mysql. bin c) program filer. mysql. bin > trin 2:, login til database, som følger, c: \\ program filer. mysql. bin > mysql - rod - p indtast kodeord: jeg spørger ikke igen. mysql >, trin 3:, skaber den tabel, arbejdsgivere, in ,TEST, database as follows:, mysql> use TEST; mysql> create table Employees ( id int not null, age int not null, first varchar (255), last varchar (255) ); Query OK, 0 rows affected (0.08 sec) mysql> ,Create Data Records,Finally you create few records in Employee table as follows:, mysql> INSERT INTO Employees VALUES (100, 18, 'Zara', 'Ali'); Query OK, 1 row affected (0.05 sec) mysql> INSERT INTO Employees VALUES (101, 25, 'Mahnaz', 'Fatma'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employees VALUES (102, 30, 'Zaid', 'Khan'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employees VALUES (103, 28, 'Sumit', 'Mittal'); Query OK, 1 row affected (0.00 sec) mysql> ,SELECT Operation:,Following example shows how we can execute SQL SELECT statement using JTSL in JSP programming:, <%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html> <head> <title>SELECT Operation</title> </head> <body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees; </sql:query> <table border="1" width="100%"> <tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th> </tr> <c:forEach var="row" items="${result.rows}"> <tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td> </tr> </c:forEach> </table> </body> </html> ,Now try to access above JSP, which should display the following result:, Emp ID First Name Last Name Age 100 Zara Ali 18 101 Mahnaz Fatma 25 102 Zaid Khan 30 103 Sumit Mittal 28 ,INSERT Operation:,Following example shows how we can execute SQL INSERT statement using JTSL in JSP programming:, <%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html> <head> <title>JINSERT Operation</title> </head> <body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <sql:update dataSource="${snapshot}" var="result"> INSERT INTO Employees VALUES (104, 2, 'Nuha', 'Ali'); </sql:update> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees; </sql:query> <table border="1" width="100%"> <tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th> </tr> <c:forEach var="row" items="${result.rows}"> <tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td> </tr> </c:forEach> </table> </body> </html> ,Now try to access above JSP, which should display the following result:, Emp ID First Name Last Name Age 100 Zara Ali 18 101 Mahnaz Fatma 25 102 Zaid Khan 30 103 Sumit Mittal 28 104 Nuha Ali 2 ,DELETE Operation:,Following example shows how we can execute SQL DELETE statement using JTSL in JSP programming:, <%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html> <head> <title>DELETE Operation</title> </head> <body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123" /> < c: der var = "empid" værdi = 103 "/> < sql: ajourføring datasource =" $(billede) »var = "greven" > slette fra arbejdstagere, hvor id =?<sql:param value="${empId}" /> </sql:update> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees; </sql:query> <table border="1" width="100%"> <tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th> </tr> <c:forEach var="row" items="${result.rows}"> <tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> <td><c:out value="${row.age}"/></td> </tr> </c:forEach> </table> </body> </html> ,Now try to access above JSP, which should display the following result:, Emp ID First Name Last Name Age 100 Zara Ali 18 101 Mahnaz Fatma 25 102 Zaid Khan 30 ,UPDATE Operation:,Following example shows how we can execute SQL UPDATE statement using JTSL in JSP programming:, <%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html> <head> <title>DELETE Operation</title> </head> <body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <c:set var="empId" value="102"/> <sql:update dataSource="${snapshot}" var="count"> UPDATE Employees SET last = 'Ali' <sql:param value="${empId}" /> </sql:update> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees; </sql:query> <table border="1" width="100%"> <tr> <th>Emp ID</th> <th>First Name</th> <th>Last Name</th> <th>Age</th> </tr> <c:forEach var="row" items="${result.rows}"> <tr> <td><c:out value="${row.id}"/></td> <td><c:out value="${row.first}"/></td> <td><c:out value="${row.last}"/></td> < td > < c: værdi = "$(ro. alder}" /> < /td > < /tr > < /c: for hvert > < /tabel > < /organ > < /html >, nu forsøger at få adgang til over lox, som skal være forsynet med følgende resultat:, emp id fornavn efternavn alder 100 zara ali 18 101 mahnaz fatma 25 102 zaid ali.



Previous:
Next Page: