Swing增删改查刷新jdbc&&mysql

Swing增删改查刷新jdbc&&mysql

mysql-----》表

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.5.15 : Database - teacher
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`teacher` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `teacher`;

/*Table structure for table `teacher` */

DROP TABLE IF EXISTS `teacher`;

CREATE TABLE `teacher` (
  `teaid` int(10) NOT NULL AUTO_INCREMENT,
  `classID` varchar(10) NOT NULL,
  `teaname` varchar(20) NOT NULL,
  `sex` varchar(2) NOT NULL,
  `knowledge` varchar(20) DEFAULT NULL,
  `knowlevel` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`teaid`),
  KEY `teaid` (`teaid`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

/*Data for the table `teacher` */

insert  into `teacher`(`teaid`,`classID`,`teaname`,`sex`,`knowledge`,`knowlevel`) values (38,'0101','是','男','初级教师','初级'),(39,'0101','','男','初级教师','初级'),(40,'0101','','男','初级教师','初级'),(41,'0101','','男','初级教师','初级');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

建立DBUtil，entity,main1包
在DBUtil包中放DBConn类
包结构如下图：

package DBUtil;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBConn {
      // 连接数据库类，关闭数据库类
	// 连接数据库数据库四要素
 private static String Driver="com.mysql.jdbc.Driver";  // 驱动
 private static String url="jdbc:mysql://127.0.0.1:3306/teacher?useUnicode=true&characterEncoding=UTF-8";     // 连接地址  设置为utf8格式
 private static String userName="root";// 数据库用户名
 private static String password="123456";// 数据库密码
 // 加载驱动
 static {
   
	 try {
   
		Class.forName(Driver);
	} catch (Exception e) {
   
		// TODO: handle exception
		e.printStackTrace();
	}
 }
 // 开始连接
 public static Connection getConnection(){
   
	 Connection connection=null;
	 try {
   
		connection=DriverManager.getConnection(url,userName,password);
	} catch (SQLException e) {
   
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	 return connection;
 }
 // 关闭连接
 public static void close(Connection conn,PreparedStatement ptmt,ResultSet rs){
   
	 try {
   
		if (conn!=null) {
   
			conn.close();
		}
		if (ptmt!=null) {
   
			ptmt.close();
		}
		if(rs!=null){
   
			rs.close();
		}
	} catch (Exception e) {
   
		// TODO: handle exception
	e.printStackTrace();
	}
 }
 public void close(Connection con,PreparedStatement ptmt){
   
	 close(con,ptmt,null);
 }
 public void close(Connection con){
   
	 close(con,null,null);
 }

 
}

DBUtil类

/**
 * 
 */
package DBUtil;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.swing.JOptionPane;

import entity.Teacher;
import main1.Add1;

/**
 * @author sq
 * @date 2020年6月24日
 * @Desription: TODO
 */
public class DBUtil {
   
private static Connection conn=null;
private static PreparedStatement ps=null;
private static ResultSet rs= null;
private static final CallableStatement cs=null;




public static void Delete(Teacher t){
   
	conn =DBConn.getConnection(); // 打通数据库
	int row = Add1.table.getSelectedRow();
	 if (row==-1) {
   
		JOptionPane.showMessageDialog(null, "删除前请选择一行");
	}else{
   
		String sql ="delete from teacher where teaid=?";
		try {
   
			ps=conn.prepareStatement(sql);
			int zhi=Integer.parseInt(Add1.dm.getValueAt(row, 0)+"");
			ps.setInt(1, zhi);
			ps.executeUpdate();
			JOptionPane.showMessageDialog(null, "删除成功");
			for (int i = 0; i < Add1.dm.getRowCount();) {
   
				Add1.dm.removeRow(0);
			}
		}
			
			catch(Exception ex