用JAVA对数据库信息进行增加、删除、修改、查看怎么写谁能帮忙，能的加QQ1505209873我把我写好的代码发给

这个不是简单的数据库 数据的添加 删除 修改 和查看吗

这个是一个家具买卖页面所涉及的 曾删改查都有了，详细内容看代码

package Dao

import java.sql.Connection

import java.sql.PreparedStatement

import java.sql.ResultSet

import java.util.ArrayList

import java.util.List

import Entity.JIAJU

public class JiaJu {

public JIAJU selectExe(int shouhinId) {

JIAJU jia = new JIAJU()

try {

Connection con = ConnectionManager.getConnection()

String sql = "select * from jiaju where shouhinId=?"

PreparedStatement ps = con.prepareStatement(sql)

ps.setInt(1, shouhinId)

ResultSet rs = ps.executeQuery()

if (rs != null) {

while (rs.next()) {

jia.setShouhinId(rs.getInt("shouhinId"))

jia.setShouhinName(rs.getString("shouhinName"))

jia.setShouhinColor(rs.getString("shouhinColor"))

jia.setShouhinPrice(rs.getInt("shouhinPrice"))

jia.setShouhinPai(rs.getString("shouhinPai"))

jia.setShouhinShi(rs.getString("shouhinShi"))

// list.add(jia)

}

}

} catch (Exception e) {

e.printStackTrace()

}

return jia

}

public void insertJia(JIAJU jia) {

try {

Connection con = ConnectionManager.getConnection()

String sql = "insert into jiaju values(?,?,?,?,?)"

PreparedStatement ps = con.prepareStatement(sql)

ps.setString(1, jia.getShouhinName())

ps.setString(2, jia.getShouhinColor())

ps.setInt(3, jia.getShouhinPrice())

ps.setString(4, jia.getShouhinPai())

ps.setString(5, jia.getShouhinShi())

ps.executeUpdate()

} catch (Exception e) {

e.printStackTrace()

}

}

public List selectJia() {

List list = new ArrayList()

try {

Connection con = ConnectionManager.getConnection()

String sql = "select * from jiaju "

PreparedStatement ps = con.prepareStatement(sql)

ResultSet rs = ps.executeQuery()

if (rs != null) {

while (rs.next()) {

JIAJU jia = new JIAJU()

jia.setShouhinId(rs.getInt("shouhinId"))

jia.setShouhinName(rs.getString("shouhinName"))

jia.setShouhinColor(rs.getString("shouhinColor"))

jia.setShouhinPrice(rs.getInt("shouhinPrice"))

jia.setShouhinPai(rs.getString("shouhinPai"))

jia.setShouhinShi(rs.getString("shouhinShi"))

list.add(jia)

}

}

} catch (Exception e) {

e.printStackTrace()

}

return list

}

public JIAJU selectbuy(int shouhinId) {

JIAJU jia = new JIAJU()

try {

Connection con = ConnectionManager.getConnection()

String sql = "select * from jiaju where shouhinId=?"

PreparedStatement ps = con.prepareStatement(sql)

ps.setInt(1, shouhinId)

ResultSet rs = ps.executeQuery()

if (rs != null) {

while (rs.next()) {

jia.setShouhinId(rs.getInt("shouhinId"))

jia.setShouhinName(rs.getString("shouhinName"))

jia.setShouhinColor(rs.getString("shouhinColor"))

jia.setShouhinPrice(rs.getInt("shouhinPrice"))

jia.setShouhinPai(rs.getString("shouhinPai"))

jia.setShouhinShi(rs.getString("shouhinShi"))

}

}

} catch (Exception e) {

e.printStackTrace()

}

return jia

}

public void updateLou(JIAJU jia){

try{

Connection con = ConnectionManager.getConnection()

String sql = "update jiaju set shouhinPrice=? where shouhinId=?"

PreparedStatement ps = con.prepareStatement(sql)

ps.setInt(1,jia.getShouhinPrice())

ps.setInt(2, jia.getShouhinId())

ps.executeUpdate()

}catch(Exception e){

e.printStackTrace()

}

}

public void deleteLou(JIAJU jia){

try{

Connection con = ConnectionManager.getConnection()

String sql = "delete from jiaju where shouhinId=?"

PreparedStatement ps = con.prepareStatement(sql)

ps.setInt(1, jia.getShouhinId())

ps.executeUpdate()

}catch(Exception e){

e.printStackTrace()

}

}

}

import java.awt.Color

import java.awt.Font

import java.awt.Frame

import java.awt.Label

import java.awt.TextField

import java.awt.Window

import java.awt.event.ActionEvent

import java.awt.event.ActionListener

import java.awt.event.WindowAdapter

import java.awt.event.WindowEvent

import java.sql.SQLException

import javax.swing.JButton

public class Stmessege {

Font font = new Font("楷体", Font.BOLD, 18)

private Frame m = new Frame("登陆成功界面")

protected Window f

public Stmessege() {

m.addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent evt) {

m.setVisible(false)

m.dispose()

System.exit(0)

}

})

m.setSize(460, 360)

m.setBackground(Color.green)

m.setLayout(null)

m.setLocationRelativeTo(null)

Label l0 = new Label("管理员信息")

Font font1 = new Font("楷体", Font.BOLD, 32)

l0.setForeground(Color.blue)

l0.setSize(180, 50)

l0.setLocation(150, 30)

l0.setFont(font1)

final Label l1 = new Label("姓名：")

l1.setSize(60, 20)

l1.setLocation(10, 100)

l1.setFont(font)

TextField tf1 = new TextField("黄朋")

tf1.setForeground(Color.blue)

tf1.setBackground(Color.white)

tf1.setSize(50, 20)

tf1.setLocation(70, 100)

final Label l2 = new Label("学号：")

l2.setSize(60, 20)

l2.setLocation(140, 100)

l2.setFont(font)

TextField tf2 = new TextField("111265")

tf2.setForeground(Color.blue)

tf2.setBackground(Color.white)

tf2.setSize(60, 20)

tf2.setLocation(190, 100)

final Label l3 = new Label("性别：")

l3.setSize(60, 20)

l3.setLocation(280, 100)

l3.setFont(font)

TextField tf3 = new TextField("男")

tf3.setForeground(Color.blue)

tf3.setBackground(Color.white)

tf3.setSize(40, 20)

tf3.setLocation(360, 100)

final Label l4 = new Label("班级：")

l4.setSize(60, 20)

l4.setLocation(10, 170)

l4.setFont(font)

TextField tf4 = new TextField("611231")

tf4.setForeground(Color.blue)

tf4.setBackground(Color.white)

tf4.setSize(60, 20)

tf4.setLocation(67, 170)

final Label l5 = new Label("系别：")

l5.setSize(60, 20)

l5.setLocation(140, 170)

l5.setFont(font)

TextField tf5 = new TextField("计算机工程系")

tf5.setForeground(Color.blue)

tf5.setBackground(Color.white)

tf5.setSize(80, 20)

tf5.setLocation(200, 170)

final Label l6 = new Label("成绩：")

l6.setSize(60, 20)

l6.setLocation(280, 170)

l6.setFont(font)

TextField tf6 = new TextField("95")

tf6.setForeground(Color.blue)

tf6.setBackground(Color.white)

tf6.setSize(40, 20)

tf6.setLocation(360, 170)

final Label l7 = new Label("专业：")

l7.setSize(60, 20)

l7.setLocation(10, 230)

l7.setFont(font)

TextField tf7 = new TextField("软件技术")

tf7.setForeground(Color.blue)

tf7.setBackground(Color.white)

tf7.setSize(60, 20)

tf7.setLocation(70, 230)

JButton btn1 = new JButton("添加")

btn1.setForeground(Color.blue)

btn1.setSize(80, 38)

btn1.setLocation(35, 300)

btn1.setFont(font)

btn1.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

new 插入()

m.setVisible(true)

}

})

JButton btn2 = new JButton("查询学生学籍信息")

btn2.setForeground(Color.blue)

btn2.setSize(200, 38)

btn2.setLocation(135, 300)

btn2.setFont(font)

btn2.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Stmessege1 f

try {

f = new Stmessege1()

f.Stmessege11()

m.setVisible(true)

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace()

} catch (ClassNotFoundException e1) {

// TODO Auto-generated catch block

e1.printStackTrace()

}

}

})

JButton btn3 = new JButton("删除")

btn3.setForeground(Color.blue)

btn3.setSize(80, 38)

btn3.setLocation(350, 300)

btn3.setFont(font)

btn3.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

new 删除()

//f.setVisible(false)

m.setVisible(true)

}

})

JButton btn4 = new JButton("更新")

btn4.setForeground(Color.blue)

btn4.setSize(80, 38)

btn4.setLocation(200, 230)

btn4.setFont(font)

btn4.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

new 更新()

m.setVisible(true)

}

})

m.add(l0)

m.add(l1)

m.add(tf1)

m.add(l2)

m.add(tf2)

m.add(l3)

m.add(tf3)

m.add(l4)

m.add(tf4)

m.add(l5)

m.add(tf5)

m.add(l6)

m.add(tf6)

m.add(l7)

m.add(tf7)

m.add(btn1)

m.add(btn2)

m.add(btn3)

m.add(btn4)

m.setVisible(true)

}

public static void main(String[] args) {

new Stmessege()

}

}

可以仿照我的做一下，希望采纳，我才一级哦

---