用JAVA編程的通過SQL連接數(shù)據(jù)庫(kù)的商品庫(kù)存管理系統(tǒng)的源代碼

package com.company.dao;

創(chuàng)新互聯(lián)是一家專注于成都網(wǎng)站建設(shè)、成都做網(wǎng)站與策劃設(shè)計(jì),忻府網(wǎng)站建設(shè)哪家好?創(chuàng)新互聯(lián)做網(wǎng)站,專注于網(wǎng)站建設(shè)十載,網(wǎng)設(shè)計(jì)領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:忻府等地區(qū)。忻府做網(wǎng)站價(jià)格咨詢:18980820575

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class BaseDao {

// 數(shù)據(jù)庫(kù)驅(qū)動(dòng)

String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

//url

String url = "jdbc:sqlserver://數(shù)據(jù)庫(kù)ip:端口號(hào);databaseName=數(shù)據(jù)庫(kù)名;";

//用戶名

String uname = "數(shù)據(jù)庫(kù)用戶名";

//密碼

String pwd = "數(shù)據(jù)庫(kù)密碼";

/**

* 獲得連接對(duì)象

* @return

*/

protected Connection getCon(){

//返回的連接

Connection con = null;

try {

//載入驅(qū)動(dòng)

Class.forName(driver);

//得到連接

con = DriverManager.getConnection(url, uname, pwd);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return con;

}

/**

* 關(guān)閉數(shù)據(jù)庫(kù)

* @param con

* @param stmt

* @param rs

*/

protected void closeDB(Connection con, Statement stmt, ResultSet rs){

if(rs != null){

try {

//關(guān)閉結(jié)果集

rs.close();

rs = null;

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if(stmt != null){

try {

//關(guān)閉語(yǔ)句對(duì)象

stmt.close();

stmt = null;

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if(con != null){

try {

//關(guān)閉連接對(duì)象

con.close();

con = null;

} catch (SQLException e) {

e.printStackTrace();

}

}

}

protected void closeDB(Connection con, PreparedStatement pstmt, ResultSet rs){

if(rs != null){

//關(guān)閉結(jié)果集

try {

rs.close();

rs = null;

} catch (SQLException e) {

e.printStackTrace();

}

}

if(pstmt != null){

try {

pstmt.close();

pstmt = null;

} catch (SQLException e) {

e.printStackTrace();

}

}

if(con != null){

try {

con.close();

con = null;

} catch (SQLException e) {

e.printStackTrace();

}

}

}

這個(gè)是我寫的一個(gè)基本的連接sql2005數(shù)據(jù)庫(kù)的代碼,.! 不知道你能不能用,! 你看一下吧, 連接的時(shí)候需要sqljdbc.jar數(shù)據(jù)庫(kù)驅(qū)動(dòng),!

用JAVA編寫購(gòu)物系統(tǒng)的代碼是什么？（急）

算是最簡(jiǎn)單的吧

package cn.job01;

import java.util.Scanner;

public class Lx07 {

public static void choice() {

System.out.println("登陸菜單 ");

System.out.println("1登陸系統(tǒng)");

System.out.println("2退出");

}

static void choice1() {

System.out.println("購(gòu)物管理系統(tǒng)客戶信息");

System.out.println("1顯示所有客戶信息");

System.out.println("2添加客戶信息");

System.out.println("3修改客戶信息");

System.out.println("4查詢客戶信息");

}

static void choice2() {

System.out.println("購(gòu)物管理系統(tǒng)真情回饋");

System.out.println("1幸運(yùn)大放送");

System.out.println("2幸運(yùn)抽獎(jiǎng)");

System.out.println("3生日問候");

}

public static void main(String[] args) {

choice();

Scanner input = new Scanner(System.in);

System.out.println("請(qǐng)輸入1or2");

int num = input.nextInt();

switch (num) {

case 1:

System.out.println("主菜單");

System.out.println("1客戶信息管理");

System.out.println("2購(gòu)物結(jié)算");

System.out.println("3真情回饋");

System.out.println("4注銷");

break;

}

System.out.println("選擇輸入數(shù)字");

int num1 = input.nextInt();

switch (num1) {

case 1:

choice1();

break;

case 2:

System.out.println("購(gòu)物結(jié)算");

break;

case 3:

choice2();

break;

case 4:

choice();

break;

}

}

}

java用戶管理的代碼中查詢不了是哪出問題了

一)[DLS_DEAD_LOCAL_STORE]

描述： Dead store to 未使用的局部變量

解決方法：局部變量定義后未使用；實(shí)例化對(duì)象后又重新對(duì)該對(duì)象賦值

(二) [ST_WRITE_TO_STATIC_FROM_INSTANCE_METHOD]

描述：Write to static field 通過實(shí)例方法更新靜態(tài)屬性

常見于常量類，直接通過類名.常量名獲取的方式違背了封裝的原則，findbugs不提倡使用，而如果將常量改成靜態(tài)成員變量，又因?yàn)閟pring不支持靜態(tài)注入導(dǎo)致不能實(shí)現(xiàn)，解決方法是非靜態(tài)的setter調(diào)用靜態(tài)的setter方法給靜態(tài)成員變量賦值。

解決方法：

常量類F：

class F{

public static String a = “123”;

}

常量a改為靜態(tài)成員變量，通過F.getA()獲取，且由于spring不支持靜態(tài)注入，改為：

class F{

private static String a;

public static Integer getA() {

return a;

}

public void setA(String a) {

setAValue(a);

}

public static void setAValue(String a) {

F.a = a;

}

}

(三) [BX_UNBOXING_IMMEDIATELY_REBOXED]

描述： Boxed value is unboxed and then immediately reboxed 裝箱的值被拆箱，然后立刻重新裝箱了

常見的是三目運(yùn)算時(shí)，同時(shí)存在基本類型和包裝類型。

解決方法：

Integer a = null;

//...

a = (a == null)?0:a;

此問題在于a不為null時(shí)，會(huì)被拆箱，賦值時(shí)再裝箱。這是自動(dòng)裝箱拆箱的特性，只要運(yùn)算中有不同類型，當(dāng)涉及到類型轉(zhuǎn)換時(shí)，編譯器就會(huì)向下轉(zhuǎn)型，再進(jìn)行運(yùn)算。修改方法，統(tǒng)一類型：

Integer a = null;

//...

a = (a == null)?Integer.valueOf(0):a;

(四) [SE_BAD_FIELD]

描述： Non-transient non-serializable instance field in serializable class在可序列化的類中存在不能序列化或者不能暫存的數(shù)據(jù)

解決方法：

方法1：序列化該對(duì)象

方法2：當(dāng)采用struts2框架開發(fā)，不可避免的此問題會(huì)大量出現(xiàn)，因?yàn)锳ctionSupport實(shí)現(xiàn)了序列化接口，action繼承了此類，而 service沒序列化，所以在action中引用service對(duì)象時(shí)提示此錯(cuò)誤，最簡(jiǎn)單的解決方法是將service對(duì)象聲明成transient， 即service不需要序列化

方法3(未驗(yàn)證)：To avoid java serialization you need to implement writeObject() and readObject() method in your Class and need to throw NotSerializableExceptionfrom those method.(action中實(shí)現(xiàn)這兩個(gè)方法?)

private void writeObject(java.io.ObjectOutputStream stream) throws java.io.IOException {

throw new java.io.NotSerializableException( getClass().getName() );

}

private void readObject(java.io.ObjectInputStream stream) throws java.io.IOException, ClassNotFoundException {

throw new java.io.NotSerializableException( getClass().getName() );

}

(五) [NP_LOAD_OF_KNOWN_NULL_VALUE]

描述： Load of known null value加載已知是null的值

解決方法：已知方法參數(shù)為null是，直接傳遞null而不是參數(shù)名

(六) [REC_CATCH_EXCEPTION]

描述： Exception is caught when Exception is not thrown 過泛地捕獲異?；虿东@異常后未做任何處理

解決方法：異常分類捕獲(至少要打印出此異常對(duì)象)

(七) [NP_NULL_PARAM_DEREF]

描述： Null passed for nonnull parameter 把空值傳給了非空的參數(shù)

解決方法：增加非空判斷

(八) [NP_IMMEDIATE_DEREFERENCE_OF_READLINE]

描述： Immediate dereference of the result of readLine() 立即引用了readLine()的結(jié)果

解決方法：判斷readLine的結(jié)果是否為空

(九) [EI_EXPOSE_REP] 惡意代碼漏洞

描述：may expose internal representation by returning getter方法返回引用類型

eclipse自動(dòng)生成的引用類型(Object、數(shù)組、Date等)的getter、setter方法會(huì)得到或通過對(duì)可變對(duì)象的引用操作而暴露代碼內(nèi)部實(shí)現(xiàn)，解決方法很多，只要返回的或賦值的對(duì)象不是原引用對(duì)象即可。

解決方法：

以Date類型為例：

public Date getHappenTime() {

if(happenTime != null){

return (Date) happenTime.clone();

}

return null;

}

(十) [ EI_EXPOSE_REP2] 惡意代碼漏洞

描述：may expose internal representation by storing an externally mutable object into setter方法返回引用類型

eclipse自動(dòng)生成的引用類型(Object、數(shù)組、Date等)的getter、setter方法會(huì)得到或通過對(duì)可變對(duì)象的引用操作而暴露代碼內(nèi)部實(shí)現(xiàn)，解決方法很多，只要返回的或賦值的對(duì)象不是原引用對(duì)象即可。

解決方法：

以Date類型為例：

public void setHappenTime(Date happenTime) {

if(happenTime != null){

this.happenTime = (Date) happenTime.clone();

}else{

this.happenTime = null;

}

}

親有java語(yǔ)言寫的超市管理系統(tǒng)課程設(shè)計(jì)和源代碼嗎，能給我嗎

package untitled5;

import java.io.*;

import java.net.*;

import java.sql.*;

import java.lang.*;

import javax.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import com.borland.jbcl.layout.*;

public class delbook extends JFrame {

JPanel contentPane;

XYLayout xYLayout1 = new XYLayout();

JLabel jLabel1 = new JLabel();

JLabel jLabel2 = new JLabel();

JLabel jLabel3 = new JLabel();

JTextField jTextField1 = new JTextField();

JLabel jLabel4 = new JLabel();

JTextField jTextField2 = new JTextField();

JLabel jLabel5 = new JLabel();

JTextField jTextField3 = new JTextField();

JLabel jLabel6 = new JLabel();

JTextField jTextField4 = new JTextField();

JButton jButton1 = new JButton();

//Construct the frame

public delbook() {

enableEvents(AWTEvent.WINDOW_EVENT_MASK);

try {

jbInit();

}

catch(Exception e) {

e.printStackTrace();

}

}

//Component initialization

private void jbInit() throws Exception {

contentPane = (JPanel) this.getContentPane();

jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel1.setForeground(Color.red);

jLabel1.setText("超市管理系統(tǒng)");

contentPane.setLayout(xYLayout1);

this.setSize(new Dimension(500,400));

this.setTitle("超市管理系統(tǒng)");

jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30));

jLabel2.setText("業(yè)務(wù)單位信息");

jLabel3.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel3.setText("產(chǎn)品編號(hào)");

jTextField1.setText("");

jLabel4.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel4.setText("公司名稱");

jTextField2.setText("");

jLabel5.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel5.setText("訂單號(hào)碼");

jTextField3.setText("");

jLabel6.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel6.setText("電 話");

jTextField4.setText("");

jButton1.setFont(new java.awt.Font("SansSerif", 0, 25));

jButton1.setText("提交");

jButton1.addActionListener(new delbook_jButton1_actionAdapter(this));

contentPane.add(jLabel1, new XYConstraints(179, 1, 153, 32));

contentPane.add(jLabel2, new XYConstraints(162, 33, -1, -1));

contentPane.add(jLabel3, new XYConstraints(83, 89, -1, -1));

contentPane.add(jTextField1, new XYConstraints(189, 88, 141, 36));

contentPane.add(jTextField2, new XYConstraints(189, 149, 142, 36));

contentPane.add(jLabel4, new XYConstraints(84, 148, -1, -1));

contentPane.add(jTextField3, new XYConstraints(188, 206, 143, 33));

contentPane.add(jLabel5, new XYConstraints(84, 204, -1, -1));

contentPane.add(jLabel6, new XYConstraints(84, 253, -1, -1));

contentPane.add(jTextField4, new XYConstraints(189, 260, 143, 36));

contentPane.add(jButton1, new XYConstraints(197, 318, -1, -1));

}

//Overridden so we can exit when window is closed

protected void processWindowEvent(WindowEvent e) {

super.processWindowEvent(e);

if (e.getID() == WindowEvent.WINDOW_CLOSING) {

System.exit(0);

}

}

void update() {

try {

//定義顯示的字符串

String str1;

String str2;

String str3;

String str4;

str1 = jTextField1.getText();

str2 = jTextField2.getText();

str3 = jTextField3.getText();

str4 = jTextField4.getText();

//裝載jdbc驅(qū)動(dòng)程序

String driverName = "oracle.jdbc.OracleDriver";

Driver driver = (Driver) Class.forName(driverName).newInstance();

//連接數(shù)據(jù)庫(kù)

Connection con = DriverManager.getConnection(

"jdbc:oracle:thin:@thsspc0791:1521:liuyong", "hr", "tongfang");

PreparedStatement pstmt = con.prepareStatement(

" insert Customer1('goodID','Name','PID','tel')values(?,?,?,?)");

pstmt.setString(1, str1);

pstmt.setString(2, str2);

pstmt.setString(1, str3);

pstmt.setString(4, str4);

ResultSet res = pstmt.executeQuery();

pstmt.close();

con.close();

}catch (InstantiationException e) {

System.out.println(e.getMessage());

}catch (IllegalAccessException e) {

System.out.println(e.getMessage());

}catch (ClassNotFoundException e) {

System.out.println(e.getMessage());

}catch (SQLException edd) {

edd.printStackTrace() ;

System.out.println(edd.getMessage());

}

}

void jButton1_actionPerformed(ActionEvent e) {

update();

}

}

class delbook_jButton1_actionAdapter implements java.awt.event.ActionListener {

delbook adaptee;

delbook_jButton1_actionAdapter(delbook adaptee) {

this.adaptee = adaptee;

}

public void actionPerformed(ActionEvent e) {

adaptee.jButton1_actionPerformed(e);

}

}

package untitled5;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import com.borland.jbcl.layout.*;

/**

* pTitle: /p

* pDescription: /p

* pCopyright: Copyright ? 2003/p

* pCompany: /p

* @author not attributable

* @version 1.0

*/

public class retur extends JFrame {

JPanel contentPane;

XYLayout xYLayout1 = new XYLayout();

JLabel jLabel1 = new JLabel();

//Construct the frame

public retur() {

enableEvents(AWTEvent.WINDOW_EVENT_MASK);

try {

jbInit();

}

catch(Exception e) {

e.printStackTrace();

}

}

//Component initialization

private void jbInit() throws Exception {

contentPane = (JPanel) this.getContentPane();

jLabel1.setFont(new java.awt.Font("SansSerif", 0, 20));

jLabel1.setForeground(Color.red);

jLabel1.setText("超市管理系統(tǒng)");

contentPane.setLayout(xYLayout1);

this.setSize(new Dimension(400, 300));

this.setTitle("超市管理系統(tǒng)");

contentPane.add(jLabel1, new XYConstraints(139, 1, 126, 33));

}

//Overridden so we can exit when window is closed

protected void processWindowEvent(WindowEvent e) {

super.processWindowEvent(e);

if (e.getID() == WindowEvent.WINDOW_CLOSING) {

System.exit(0);

}

}

}

package untitled5;

import java.io.*;

import java.net.*;

import java.sql.*;

import java.lang.*;

import javax.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import com.borland.jbcl.layout.*;

import com.borland.dbswing.*;

//貨品信息登記

public class Frame2 extends JFrame {

JPanel contentPane;

JLabel jLabel1 = new JLabel();

XYLayout xYLayout1 = new XYLayout();

JLabel jLabel2 = new JLabel();

JLabel jLabel3 = new JLabel();

JTextField jTextField1 = new JTextField();

JLabel jLabel4 = new JLabel();

JTextField jTextField2 = new JTextField();

JPanel jPanel1 = new JPanel();

XYLayout xYLayout2 = new XYLayout();

JScrollPane jScrollPane1 = new JScrollPane();

JLabel jLabel5 = new JLabel();

JTextField jTextField3 = new JTextField();

//Construct the frame

public Frame2() {

enableEvents(AWTEvent.WINDOW_EVENT_MASK);

try {

jbInit();

}

catch(Exception e) {

e.printStackTrace();

}

}

//Component initialization

private void jbInit() throws Exception {

contentPane = (JPanel) this.getContentPane();

contentPane.setLayout(xYLayout1);

this.setSize(new Dimension(600, 500));

this.setTitle("超市管理系統(tǒng)");

this.addHierarchyBoundsListener(new Frame2_this_hierarchyBoundsAdapter(this));

jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel1.setForeground(Color.red);

jLabel1.setText("超市管理系統(tǒng)");

contentPane.setForeground(Color.black);

jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30));

jLabel2.setText("產(chǎn) 品 信 息 展 示");

// statusBar.setFont(new java.awt.Font("SansSerif", 0, 20));

jLabel3.setFont(new java.awt.Font("SansSerif", 0, 20));

jLabel3.setText("產(chǎn)品名稱");

jTextField1.setText("");

jLabel4.setEnabled(true);

jLabel4.setFont(new java.awt.Font("SansSerif", 0, 20));

jLabel4.setText("產(chǎn)品ID號(hào)");

jTextField2.setText("");

jTextField2.addActionListener(new Frame2_jTextField2_actionAdapter(this));

jPanel1.setLayout(xYLayout2);

jLabel5.setFont(new java.awt.Font("SansSerif", 0, 25));

jLabel5.setForeground(Color.red);

jLabel5.setText("該產(chǎn)品詳細(xì)信息");

jTextField3.setText("");

contentPane.add(jLabel1, new XYConstraints(237, 0, 153, 40));

contentPane.add(jLabel2, new XYConstraints(200, 47, 231, 58));

contentPane.add(jLabel3, new XYConstraints(47, 102, 101, 42));

contentPane.add(jTextField1, new XYConstraints(128, 108, 112, 34));

contentPane.add(jTextField2, new XYConstraints(361, 107, 109, 36));

contentPane.add(jPanel1, new XYConstraints(75, 166, 453, 277));

jPanel1.add(jScrollPane1, new XYConstraints(14, 8, 433, 221));

jScrollPane1.getViewport().add(jTextField3, null);

jPanel1.add(jLabel5, new XYConstraints(112, 240, -1, -1));

contentPane.add(jLabel4, new XYConstraints(278, 111, -1, -1));

}

//Overridden so we can exit when window is closed

protected void processWindowEvent(WindowEvent e) {

super.processWindowEvent(e);

if (e.getID() == WindowEvent.WINDOW_CLOSING) {

System.exit(0);

}

}

void Select() {

try {

String str1, str2;

str1 = jTextField1.getText();

str2 = jTextField2.getText();

新聞名稱：java商戶管理代碼 java商城模板
本文來源：http://jinyejixie.com/article46/ddojjhg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站收錄、自適應(yīng)網(wǎng)站、做網(wǎng)站、品牌網(wǎng)站設(shè)計(jì)、網(wǎng)站改版、全網(wǎng)營(yíng)銷推廣

廣告

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