How to display mysql in java

Use java's swing component to draw the table, realize the functions of "add", "delete", "save" and "exit", and connect it to the mysql database.

You can extract the data from the table in the database and display it on the form containing the table, or you can write the modified content in the table into the database table.

I used two classes to implement the above functions, one of which is MyFrame and the other is PutinStorage.

The specific code is as follows (the following codes are complete codes and have been successfully tested):

PutinStorage class:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
 
import javax.swing.JOptionPane;
 
public class PutinStorage {
	// 得到数据库表数据
	public static Vector getRows(){
		String sql_url = "jdbc:mysql://localhost:3306/haha";	//数据库路径（一般都是这样写），test是数据库名称
		String name = "root";		//用户名
		String password = "123456";	//密码
		Connection conn;
		PreparedStatement preparedStatement = null;
 
		Vector rows = null;
		Vector columnHeads = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");		//连接驱动
			conn = DriverManager.getConnection(sql_url, name, password);	//连接数据库
//			if(!conn.isClosed())
//				System.out.println("成功连接数据库");
			preparedStatement = conn.prepareStatement("select * from aa");
			ResultSet result1 = preparedStatement.executeQuery();
			
			if(result1.wasNull())
				JOptionPane.showMessageDialog(null, "结果集中无记录");
			
			rows = new Vector();
			
			ResultSetMetaData rsmd = result1.getMetaData();
					
			while(result1.next()){
				rows.addElement(getNextRow(result1,rsmd));
			}
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			System.out.println("未成功加载驱动。");
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("未成功打开数据库。");
			e.printStackTrace();
		}
		return rows;
	}
	
	// 得到数据库表头
	public static Vector getHead(){
		String sql_url = "jdbc:mysql://localhost:3306/haha";	//数据库路径（一般都是这样写），test是数据库名称
		String name = "root";		//用户名
		String password = "123456";	//密码
		Connection conn;
		PreparedStatement preparedStatement = null;
 
		Vector columnHeads = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");		//连接驱动
			conn = DriverManager.getConnection(sql_url, name, password);	//连接数据库
//			if(!conn.isClosed())
//				System.out.println("成功连接数据库");
			preparedStatement = conn.prepareStatement("select * from aa");
			ResultSet result1 = preparedStatement.executeQuery();
			
			boolean moreRecords = result1.next();
			if(!moreRecords)
				JOptionPane.showMessageDialog(null, "结果集中无记录");
			
			columnHeads = new Vector();
			ResultSetMetaData rsmd = result1.getMetaData();
			for(int i = 1; i <p><strong>MyFrame class : </strong></p><pre class="brush:php;toolbar:false">import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Vector;
 
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
 
import per.tushu.storage.PutinStorage;
 
public class MyFrame extends JFrame{
	
	DefaultTableModel tableModel;		// 默认显示的表格
	JButton add,del,exit,save;		// 各处理按钮
	JTable table;		// 表格
	
	JPanel panelUP;	//增加信息的面板
	
	// 构造函数
	public MyFrame(){
		this.setBounds(300, 200, 600, 450);		// 设置窗体大小
		this.setTitle("测试");		// 设置窗体名称
		this.setLayout(new BorderLayout());	// 设置窗体的布局方式
				
		// 新建各按钮组件
		add = new JButton("增加");
		del = new JButton("删除");
		save = new JButton("保存");
		exit = new JButton("退出");
		
		panelUP = new JPanel();		// 新建按钮组件面板
		panelUP.setLayout(new FlowLayout(FlowLayout.LEFT));	// 设置面板的布局方式
		
		// 将各按钮组件依次添加到面板中
		panelUP.add(add);
		panelUP.add(del);
		panelUP.add(save);
		panelUP.add(exit);
		
		// 取得haha数据库的aa表的各行数据
		Vector rowData = PutinStorage.getRows();
		// 取得haha数据库的aa表的表头数据
		Vector columnNames = PutinStorage.getHead();
		
		
		// 新建表格
		tableModel = new DefaultTableModel(rowData,columnNames);	
		table = new JTable(tableModel);
		
		JScrollPane s = new JScrollPane(table);
		
		// 将面板和表格分别添加到窗体中
		this.add(panelUP,BorderLayout.NORTH);
		this.add(s);
		
		// 事件处理
		MyEvent();
		
		this.setVisible(true);		// 显示窗体
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);		 // 设置窗体可关闭
	}
	
	// 事件处理
	public void MyEvent(){
		
		// 增加
		add.addActionListener(new ActionListener(){
 
			@Override
			public void actionPerformed(ActionEvent arg0) {
				// 增加一行空白区域
				tableModel.addRow(new Vector());
			}
			
		});
		
		// 删除
		del.addActionListener(new ActionListener(){
 
			@Override
			public void actionPerformed(ActionEvent arg0) {
				// TODO Auto-generated method stub
				// 删除指定行
				int rowcount = table.getSelectedRow();
				if(rowcount >= 0){
					tableModel.removeRow(rowcount);
				}
			}
			
		});
		
		/**
		* 保存
		* 我的解决办法是直接将aa表中的全部数据删除，
		* 将表格中的所有内容获取到,
		* 然后将表格数据重新写入aa表
		*/
		save.addActionListener(new ActionListener(){
 
			@Override
			public void actionPerformed(ActionEvent e) {	
				int column = table.getColumnCount();		// 表格列数
				int row = table.getRowCount();		// 表格行数
				
				// value数组存放表格中的所有数据
				String[][] value = new String[row][column];
				
				for(int i = 0; i <p><strong>When executing the above code, the initially displayed form is as follows: </strong></p><p><img src="/static/imghw/default1.png" data-src="https://img.php.cn/upload/image/697/529/372/1558093588142542.png" class="lazy" title="1558093588142542.png" alt="How to display mysql in java"></p><p><strong> Click the Add button and write the content that needs to be added (I added it three times) as shown below: </strong></p><p><img src="/static/imghw/default1.png" data-src="https://img.php.cn/upload/image/488/336/216/1558093605391393.png" class="lazy" title="1558093605391393.png" alt="How to display mysql in java"></p><p><strong>Click the Delete button to delete the specified row (I deleted Lines 2 and 4), as shown below: </strong></p><p><img src="/static/imghw/default1.png" data-src="https://img.php.cn/upload/image/191/581/869/1558093624953964.png" class="lazy" title="1558093624953964.png" alt="How to display mysql in java"></p><p>Click the save button and you will find that the window is also closed. You can re-execute the code and you will find that the table page that appears is the same as the picture above. </p><p>Click the exit button to close the window. </p>

The above is the detailed content of How to display mysql in java. For more information, please follow other related articles on the PHP Chinese website!