網(wǎng)上書(shū)店連接SQL Server 2005的java代碼怎么寫(xiě)？

連接數(shù)據(jù)庫(kù)的典型步驟

公司主營(yíng)業(yè)務(wù)：網(wǎng)站制作、成都做網(wǎng)站、移動(dòng)網(wǎng)站開(kāi)發(fā)等業(yè)務(wù)。幫助企業(yè)客戶(hù)真正實(shí)現(xiàn)互聯(lián)網(wǎng)宣傳，提高企業(yè)的競(jìng)爭(zhēng)能力。成都創(chuàng)新互聯(lián)是一支青春激揚(yáng)、勤奮敬業(yè)、活力青春激揚(yáng)、勤奮敬業(yè)、活力澎湃、和諧高效的團(tuán)隊(duì)。公司秉承以“開(kāi)放、自由、嚴(yán)謹(jǐn)、自律”為核心的企業(yè)文化，感謝他們對(duì)我們的高要求，感謝他們從不同領(lǐng)域給我們帶來(lái)的挑戰(zhàn)，讓我們激情的團(tuán)隊(duì)有機(jī)會(huì)用頭腦與智慧不斷的給客戶(hù)帶來(lái)驚喜。成都創(chuàng)新互聯(lián)推出洞頭免費(fèi)做網(wǎng)站回饋大家。

第一步：加載正確的數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序

第二步，定義所要連接數(shù)據(jù)庫(kù)的地址

String ODBCURL＝“jdbc:odbc:dbName”;

String oracleURL= "jdbc:oracle:thin:@host:port:dbName“;

String mysqlURL= "jdbc:mysql:// host:port/dbName“;

String sqlURL＝“jdbc:microsoft:sqlserver://host:1433;DatabaseName=dbName”;

第三步，建立與數(shù)據(jù)庫(kù)的連接

DriverManager.getConnection(oracleURL,

username,

password);

第四步，創(chuàng)建語(yǔ)句對(duì)象

Statement statement = connection.createStatement();

第五步，聲明SQL語(yǔ)句，并將該語(yǔ)句通過(guò)Statement對(duì)象提交給服務(wù)器進(jìn)行執(zhí)行。

Stringsql= “SELECT * FROM ONTACT_TABLE”;

ResultSet resultSet=statement.executeQuery(sql);

該語(yǔ)句將sql命令提交給數(shù)據(jù)庫(kù)服務(wù)器進(jìn)行執(zhí)行，并將執(zhí)行結(jié)果存儲(chǔ)在ResultSet對(duì)象中進(jìn)行執(zhí)行。

Statement接口主要有如下三個(gè)方法：

1. ResultSet executeQuery(String sql)

用于執(zhí)行查詢(xún)語(yǔ)句，返回 ResultSet結(jié)果集（一個(gè)二維表）

2. int executeUpdate(String sql)

用于執(zhí)行添加、刪除或修改操作，返回被更新記錄的條數(shù)

3. boolean execute(String sql)

執(zhí)行參數(shù)部分的SQL語(yǔ)句；

當(dāng)SQL語(yǔ)句的執(zhí)行結(jié)果是一個(gè)ResultSet結(jié)果集時(shí)，本方法返回true；并可以通過(guò)Statement?getResultSet()方法得到返回的結(jié)果集

當(dāng)SQL語(yǔ)句執(zhí)行后沒(méi)有返回的結(jié)果集時(shí)，該方法返回false

第六步：對(duì)查詢(xún)結(jié)果進(jìn)行分析

while(resultSet.next()){

name =resultSet.getString(1);

phone =resultSet.getString(2);

System.out.println(name+","+phone);

}

第七步，關(guān)閉打開(kāi)的資源

resultSet.close();

statement.close();

connection.close();

將打開(kāi)的資源關(guān)閉。

注意：資源關(guān)閉的順序和打開(kāi)的順序恰恰相反。

求Java語(yǔ)言為書(shū)城設(shè)計(jì)一個(gè)簡(jiǎn)單購(gòu)物車(chē)類(lèi)。

public class ShoppingCart {//購(gòu)物車(chē)類(lèi)

private Producted prod;//商品類(lèi)，存放商品信息

private int num;//商品數(shù)量

public Producted getProd() {

return prod;

}

public void setProd(Producted prod) {

this.prod = prod;

}

public int getNum() {

return num;

}

public void setNum(int num) {

this.num = num;

}

}

public class Producted {//商品類(lèi)

private String prodName;//商品名稱(chēng)

private Double marketPrice;//市場(chǎng)價(jià)

private Double sellPrice;//本店價(jià)

private Double save;//優(yōu)惠

private Short points;//積分

public String getProdName() {

return prodName;

}

public void setProdName(String prodName) {

this.prodName = prodName;

}

public Double getMarketPrice() {

return marketPrice;

}

public void setMarketPrice(Double marketPrice) {

this.marketPrice = marketPrice;

}

public Double getSellPrice() {

return sellPrice;

}

public void setSellPrice(Double sellPrice) {

this.sellPrice = sellPrice;

}

public Double getSave() {

return save;

}

public void setSave(Double save) {

this.save = save;

}

public Short getPoints() {

return points;

}

public void setPoints(Short points) {

this.points = points;

}

}

有用請(qǐng)采納

用java編寫(xiě)一個(gè)電子書(shū)店程序

懸賞什么的不值錢(qián)的,沒(méi)人愿意花時(shí)間做這個(gè)的,推薦CSDN網(wǎng)站自己找找類(lèi)似的,然后改改,如果改的能力都沒(méi)有的話(huà),那也就沒(méi)辦法了

某網(wǎng)上書(shū)城可以查詢(xún)、刪除書(shū)籍，現(xiàn)要求使用JSP實(shí)現(xiàn)該功能

簡(jiǎn)單的增刪改查功能

package?EBookDao;

import?java.sql.Connection;

import?java.sql.PreparedStatement;

import?java.sql.ResultSet;

import?java.sql.SQLException;

import?java.util.ArrayList;

import?java.util.List;

import?DBUtil.DBUtil;

import?DBUtil.EBook;

/*

*查詢(xún)書(shū)集信息

*?

*?*/

public?class?EBookCZ?{

public?ListEBook?find()?{

Connection?conn?=?null;

PreparedStatement?ps?=?null;

ResultSet?rs?=?null;

ListEBook?list?=?new?ArrayListEBook();

try?{

conn?=?DBUtil.getConnection();

String?sql?=?"SELECT?*?FROM?ebook";

ps?=?conn.prepareStatement(sql);

rs?=?ps.executeQuery();

while?(rs.next())?{

EBook?eBook?=?new?EBook();

eBook.setId(rs.getInt("ID"));

eBook.setBname(rs.getString("bname"));

eBook.setPrice(rs.getString("price"));

list.add(eBook);

System.out.println(rs.getInt("ID")+rs.getString("bname")+rs.getString("price"));

}

}?catch?(SQLException?sqle)?{

sqle.printStackTrace();

}?finally?{

DBUtil.close(conn,?ps,?rs);

}

return?list;

}

/*

?*通過(guò)id刪除書(shū)集信息

?*?

?*?*/

public?static?EBook?DelById(int?id)?{

Connection?conn?=?null;

PreparedStatement?ps?=?null;

ResultSet?rs?=?null;

EBook?book?=?null;

try?{

conn?=?DBUtil.getConnection();

String?sql?=?"delete?ebook?";

sql?+=?"WHERE?ID=??";

ps?=?conn.prepareStatement(sql);

ps.setInt(1,?id);

rs?=?ps.executeQuery();

if?(rs.next())?{

book?=?new?EBook();

book.setId(rs.getInt("ID"));

book.setBname(rs.getString("bname"));

book.setPrice(rs.getString("price"));

}

}?catch?(SQLException?sqle)?{

sqle.printStackTrace();

}?finally?{

DBUtil.close(conn,?ps,?rs);

}

return?book;

}

}

package?EBookServlet;

import?java.io.IOException;

import?java.io.PrintWriter;

import?java.util.List;

import?javax.servlet.ServletException;

import?javax.servlet.http.HttpServlet;

import?javax.servlet.http.HttpServletRequest;

import?javax.servlet.http.HttpServletResponse;

import?DBUtil.EBook;

import?EBookDao.EBookCZ;

public?class?EBookServlet?extends?HttpServlet?{

/**

?*?

?*/

private?static?final?long?serialVersionUID?=?1L;

/**

?*?Constructor?of?the?object.

?*/

public?EBookServlet()?{

super();

}

/**

?*?Destruction?of?the?servlet.?br

?*/

public?void?destroy()?{

super.destroy();?//?Just?puts?"destroy"?string?in?log

//?Put?your?code?here

}

/**

?*?The?doGet?method?of?the?servlet.?br

?*?

?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?get.

?*?

?*?@param?request

?*????????????the?request?send?by?the?client?to?the?server

?*?@param?response

?*????????????the?response?send?by?the?server?to?the?client

?*?@throws?ServletException

?*?????????????if?an?error?occurred

?*?@throws?IOException

?*?????????????if?an?error?occurred

?*/

public?void?doGet(HttpServletRequest?request,?HttpServletResponse?response)

throws?ServletException,?IOException?{

this.doPost(request,?response);

}

/**

?*?The?doPost?method?of?the?servlet.?br

?*?

?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to

?*?post.

?*?

?*?@param?request

?*????????????the?request?send?by?the?client?to?the?server

?*?@param?response

?*????????????the?response?send?by?the?server?to?the?client

?*?@throws?ServletException

?*?????????????if?an?error?occurred

?*?@throws?IOException

?*?????????????if?an?error?occurred

?*/

public?void?doPost(HttpServletRequest?request,?HttpServletResponse?response)

throws?ServletException,?IOException?{

response.setContentType("text/html;charset=utf-8");

PrintWriter?out?=?response.getWriter();

String?method?=?request.getParameter("method");

String?url?=?"";

EBookCZ?bookCZ=new?EBookCZ();

?if?(method?!=?null??method.equals("find"))?{

?System.out.println("find做完了");

??url?=?"EBookMNG.jsp";

??ListEBook?list?=?bookCZ.find();

??request.setAttribute("list",?list);

}?else?if?(method?!=?null??method.equals("findById"))?{

?System.out.println("findbyid做完了");

??url?=?"OK.jsp";

??int?id?=?Integer.parseInt(request.getParameter("id"));

??EBook?book?=?EBookCZ.DelById(id);

??request.setAttribute("book",?book);

}

request.getRequestDispatcher(url).forward(request,?response);

out.flush();

out.close();

}

/**

?*?Initialization?of?the?servlet.?br

?*?

?*?@throws?ServletException

?*?????????????if?an?error?occurs

?*/

public?void?init()?throws?ServletException?{

//?Put?your?code?here

}

}

本文名稱(chēng)：網(wǎng)上書(shū)城的java代碼 網(wǎng)上書(shū)店java代碼
轉(zhuǎn)載來(lái)于：http://chinadenli.net/article20/hgcejo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供電子商務(wù)、搜索引擎優(yōu)化、域名注冊(cè)、外貿(mào)網(wǎng)站建設(shè)、網(wǎng)站營(yíng)銷(xiāo)、

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話(huà)：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)