数据库如何用java写超市购物程序？

要使用Java编写超市购物程序，您需要使用Java数据库编程技术来连接到您的数据库并执行相关的数据库 *** 作。在Java中，您可以使用JDBC（Java数据库连接）API来连接到数据库并执行SQL语句。例如，您可以使用JDBC API来执行以下 *** 作：

创建数据库连接

执行增删改查（CRUD） *** 作

提交或回滚事务

执行存储过程和函数

查询数据库元数据

此外，您还可以使用Java的面向对象编程技术来封装数据库 *** 作，以便更方便地在您的程序中使用。例如，您可以创建一个类来表示超市商品，并定义一些方法来执行商品的增删改查 *** 作。这样，您就可以在程序中通过调用这些方法来简单地完成对数据库的 *** 作，而不需要编写复杂的SQL语句。

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("超市管理系统")

contentPane.setLayout(xYLayout1)

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

this.setTitle("超市管理系统")

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

jLabel2.setText("业务单位信息")

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

jLabel3.setText("产品编号")

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("订单号码")

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驱动程序

String driverName = "oracle.jdbc.OracleDriver"

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

//连接数据库

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.*

/**

* <p>Title: </p>

* <p>Description: </p>

* <p>Copyright: Copyright © 2003</p>

* <p>Company: </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("超市管理系统")

contentPane.setLayout(xYLayout1)

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

this.setTitle("超市管理系统")

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("超市管理系统")

this.addHierarchyBoundsListener(new Frame2_this_hierarchyBoundsAdapter(this))

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

jLabel1.setForeground(Color.red)

jLabel1.setText("超市管理系统")

contentPane.setForeground(Color.black)

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

jLabel2.setText("产 品 信 息 展 示")

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

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

jLabel3.setText("产品名称")

jTextField1.setText("")

jLabel4.setEnabled(true)

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

jLabel4.setText("产品ID号")

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("该产品详细信息")

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()

---