DBMS project

最新推荐文章于 2021-06-17 15:58:57 发布
最新推荐文章于 2021-06-17 15:58:57 发布
阅读量600 收藏
点赞数
分类专栏： java 源码 文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lycorislqy/article/details/41439079
版权
java 同时被 2 个专栏收录
17 篇文章 0 订阅
订阅专栏
源码
5 篇文章 0 订阅
订阅专栏

带界面的数据库数据查询

package panel;
import java.awt.Component;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Frame;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.GridLayout;
import java.awt.Label;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.Vector;
import java.sql.*;

import javax.swing.*;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import javax.swing.table.TableColumnModel;
import javax.swing.table.TableModel;

public class panelSQL extends JFrame {

	String[] coloumnNames ; 
	Object[][] data; 
	static int C_Width = 900;
	static ArrayList<String> paper_name = new ArrayList<String>();
	static ArrayList<String> year = new ArrayList<String>();
	static ArrayList<String> conference_name = new ArrayList<String>();
	static ArrayList<String> paper_author = new ArrayList<String>();
	static ArrayList<String> location = new ArrayList<String>();
	static ArrayList<String> affiliation =  new ArrayList<String>();
	static ArrayList<String> pc_name = new ArrayList<String>();
	static ArrayList<String> pc_affiliation = new ArrayList<String>();
	static ArrayList<String> pc_conference = new ArrayList<String>();

	static String Search_In_Table;
	static int count_radio1=0,count_radio2 = 0,count_radio3 =0;
	//单选按钮
    JRadioButton radio1 = new JRadioButton("Author"); // paper_name,paper_author, year, conference_name, conference location  
    JRadioButton radio2 = new JRadioButton("PC member"); //name, affiliation, and conference name. 
    JRadioButton radio3 = new JRadioButton("Affiliation");  // paper name, paper's authors, year, conference name, and conference location.

	
	private static JTable table;
	private static DefaultTableModel model; 
	public panelSQL()
	{
		Container contentPane=this.getContentPane();
		/* 创建一个面板对象,指定布局管理器为GridLayout,1行2列.Jpanel的默认版面管理为FlowLayout */
		final JPanel jPanel1=new JPanel(new FlowLayout(FlowLayout.CENTER,20,20));

		//利用String数组建立JComboBox
		String[] jcomboBoxContain={"DEFAULT","sigmod 2012","sigmod 2013","sigmod 2014"};
		final JComboBox jComboBox1=new JComboBox(jcomboBoxContain);
	
		//jComboBox1.addItem("其他"); //在列表框选项的最后再添加一个"其他"选项
		//设置jList1对象的带标题边框
		jComboBox1.setBorder(BorderFactory.createTitledBorder("conference:   "));
		
		
		//文本框
		final TextField text1 = new TextField();
		text1.setColumns(20);

		//Table
		coloumnNames = null;
		model = new DefaultTableModel(data, coloumnNames);
		table = new JTable(model);
		//JTable table = new JTable(new TbModel());
		table.setPreferredScrollableViewportSize(new Dimension(C_Width-50, 400));
		final JScrollPane pane = new JScrollPane(table);
		
	
	    ButtonGroup group = new ButtonGroup();
	    group.add(radio1);
	    group.add(radio2);
	    group.add(radio3);
		//按钮
		JButton jButton = new JButton("  search  "); // 按钮
		
		jButton.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				if(radio1.isSelected()){
					Search_In_Table = "author";
					
					DefaultTableModel tableModel = (DefaultTableModel) table.getModel();	
					//删除原有的表头
					if(tableModel.getColumnCount()!=0)
					{
//						System.out.println("已经有\t "+tableModel.getColumnCount()+" 列了");
						int columncount = tableModel.getColumnCount()-1;
						while(columncount>=0)
						{
							TableColumnModel columnModel = table.getColumnModel();
							TableColumn tableColumn = columnModel.getColumn(columncount);
							columnModel.removeColumn(tableColumn);
							tableModel.setColumnCount(columncount);
							columncount = tableModel.getColumnCount()-1;
							
						}
//						System.out.println("已经有\t "+tableModel.getColumnCount()+" 列了");
							
					}

					tableModel.addColumn("paper name");
					tableModel.addColumn("paper's author");
					tableModel.addColumn("year");
					tableModel.addColumn("conference name");
					tableModel.addColumn("conference location");							
					
					
					
					//System.out.println("before delete\t"+ tableModel.getRowCount());
					tableModel.setRowCount(0);//删除原有数据
					paper_name.clear();
					year.clear();
					conference_name.clear();
					paper_author.clear();
					location.clear();
					tableModel.fireTableDataChanged();
					//System.out.println("after delete\t"+ tableModel.getRowCount());

					//第一次进这个表的时候会更改表的表头
					count_radio1++;
					
					String msg = text1.getText();
					//paper_name,paper_author, year, conference_name
					String petName = (String) jComboBox1.getSelectedItem();
					//System.out.println(petName);
					String query = null;
					if(petName.equals("sigmod 2012"))
					{
						System.out.println(petName);
						query ="select paper_name, author_name, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id "
								+ "and conference_id = 2012 ";
						if(msg!= null)
						{
							String test = "and author.author_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}

						query = String.format("%s %s",query, "group by author.paper_id");
						System.out.println(query);
					}
					else if(petName.equals("sigmod 2013"))
					{
						query ="select paper_name, author_name, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id "
								+ "and conference_id = 2013 ";
								//+ "group by author.paper_id";
						if(msg!= null)
						{
							String test = "and author.author_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
								//+ "group by author.paper_id";
						query = String.format("%s %s",query, "group by author.paper_id");
					}
					else if(petName.equals("sigmod 2014"))
					{
						query ="select paper_name, author_name, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id "
								+ "and conference_id = 2014 ";
								//+ "group by author.paper_id";
						if(msg!= null)
						{
							String test = "and author.author_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
								//+ "group by author.paper_id";
						query = String.format("%s %s",query, "group by author.paper_id");
					}
					else
					{
						query ="select paper_name, author_name, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id ";
								//+ "group by author.paper_id";
						if(msg!= null)
						{
							String test = "and author.author_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
								//+ "group by author.paper_id";
						query = String.format("%s %s",query, "group by author.paper_id");
					}

						try {
							SQLsearch(query);
						} catch (SQLException e1) {
							// TODO Auto-generated catch block
							e1.printStackTrace();
						}

						//String[] coloumnNames = {"paper name", "paper's author","year", "conference name","conference location"}; 
						data = new Object[paper_name.size()][5];

						for(int i=0; i< paper_name.size();i++)
						{
							String[] arr = new String[5];
							arr[0] = paper_name.get(i);
							arr[1] = paper_author.get(i);
							arr[2] = year.get(i);
							arr[3] = conference_name.get(i);
							arr[4] = location.get(i);
							tableModel.addRow(arr);
									
						}
						TableColumn column=null;
					    for (int i=0;i<5;i++){
					        column=table.getColumnModel().getColumn(i);
					        if (i == 0) column.setPreferredWidth(250);
					        else if(i == 2) column.setPreferredWidth(70);
					        else if(i == 3) column.setPreferredWidth(130);
					        else
					        column.setPreferredWidth(200);
					      }
					    
						table.invalidate();
						//model.fireTableStructureChanged();


				}
				if(radio2.isSelected()){
					Search_In_Table = "pc";
					DefaultTableModel tableModel = (DefaultTableModel) table.getModel();
					//删除原有的表头
					if(tableModel.getColumnCount()!=0)
					{
//						System.out.println("已经有\t "+tableModel.getColumnCount()+" 列了");
						int columncount = tableModel.getColumnCount()-1;
						while(columncount>=0)
						{
							TableColumnModel columnModel = table.getColumnModel();
							TableColumn tableColumn = columnModel.getColumn(columncount);
							columnModel.removeColumn(tableColumn);
							tableModel.setColumnCount(columncount);
							columncount = tableModel.getColumnCount()-1;
							
						}
							
					}

					tableModel.addColumn("name");
					tableModel.addColumn("affiliation");
					tableModel.addColumn("conference name");

					tableModel.setRowCount(0);//删除原有数据
					pc_name.clear();
					pc_affiliation.clear();
					pc_conference.clear();
					tableModel.fireTableDataChanged();

					//第一次进这个表的时候会更改表的表头
					count_radio2++;
					
					String msg = text1.getText();
					//paper_name,paper_author, year, conference_name
					String petName = (String) jComboBox1.getSelectedItem();
					//System.out.println(petName);
					String query = null;
					if(petName.equals("sigmod 2012"))
					{
						System.out.println(petName);
						query ="select distinct member_name,affilinaty, conference_name "
								+ "from pc,conference ";
						if(msg!= null)
						{
							String test = "where conference.conference_id = 2012 and member_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
					}
					else if(petName.equals("sigmod 2013"))
					{
						query ="select distinct member_name,affilinaty, conference_name "
								+ "from pc,conference ";
						if(msg!= null)
						{
							String test = "where conference.conference_id = 2013 and member_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
					}
					else if(petName.equals("sigmod 2014"))
					{
						query ="select distinct member_name,affilinaty, conference_name "
								+ "from pc,conference ";
						if(msg!= null)
						{
							String test = "where conference.conference_id = 2014 and member_name like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
					}
					else
					{
						query ="select distinct member_name,affilinaty, conference_name "
								+ "from pc,conference ";
						if(msg!= null)
						{
							String test = "where  member_name like '%";
							String test1 ="%'";
							//System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							//System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							
						}
						System.out.println("2:\t"+query);
					}

						try {
							//连接mysql进行查询
							SQLsearch(query);
						} catch (SQLException e1) {
							// TODO Auto-generated catch block
							e1.printStackTrace();
						}
						
						int cols =tableModel.getColumnCount();
						System.out.println("现在表里面的列数为\t"+cols);

						for(int i=0; i< pc_name.size();i++)
						{
							String[] arr = new String[cols];
							arr[0] = pc_name.get(i);
							arr[1] = pc_affiliation.get(i);
							arr[2] = pc_conference.get(i);
							tableModel.addRow(arr);
									
						}
						//设置表每一列的宽度
						TableColumn column=null;
					    for (int i=0;i<cols;i++){
					        column=table.getColumnModel().getColumn(i);
					        if (i == 0) column.setPreferredWidth(250);
					        else
					        column.setPreferredWidth(200);
					      }
						
						table.invalidate();
						//model.fireTableStructureChanged();
				}
				if(radio3.isSelected()){
					//
					//
					Search_In_Table = "affiliation";
					
					DefaultTableModel tableModel = (DefaultTableModel) table.getModel();
					
					//删除原有的表头
					if(tableModel.getColumnCount()!=0)
					{
//						System.out.println("已经有\t "+tableModel.getColumnCount()+" 列了");
						int columncount = tableModel.getColumnCount()-1;
						while(columncount>=0)
						{
							TableColumnModel columnModel = table.getColumnModel();
							TableColumn tableColumn = columnModel.getColumn(columncount);
							columnModel.removeColumn(tableColumn);
							tableModel.setColumnCount(columncount);
							columncount = tableModel.getColumnCount()-1;
							
						}
//						System.out.println("已经有\t "+tableModel.getColumnCount()+" 列了");
							
					}
						tableModel.addColumn("paper name");
						tableModel.addColumn("paper's author");
						tableModel.addColumn("affiliation");
						tableModel.addColumn("year");
						tableModel.addColumn("conference name");
						tableModel.addColumn("conference location");	
					
					
					tableModel.setRowCount(0);//删除原有数据
					paper_name.clear();
					year.clear();
					conference_name.clear();
					paper_author.clear();
					location.clear();
					affiliation.clear();
					tableModel.fireTableDataChanged();

					//第一次进这个表的时候会更改表的表头
					count_radio3++;
					
					String msg = text1.getText();
					//paper_name,paper_author, year, conference_name
					String petName = (String) jComboBox1.getSelectedItem();
					//System.out.println(petName);
					String query = null;
					if(petName.equals("sigmod 2012"))
					{
						System.out.println(petName);
						query ="select paper_name, author_name,affilinaty, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id "
								+ "and conference_id = 2012 ";
						if(msg!= null)
						{
							String test = "and author.affilinaty like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}

						query = String.format("%s %s",query, "group by author.paper_id");
					}
					else if(petName.equals("sigmod 2013"))
					{
						query ="select paper_name, author_name,affilinaty, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id "
								+ "and conference_id = 2013 ";
								//+ "group by author.paper_id";
						if(msg!= null)
						{
							String test = "and author.affilinaty like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
								//+ "group by author.paper_id";
						query = String.format("%s %s",query, "group by author.paper_id");
					}
					else if(petName.equals("sigmod 2014"))
					{
						query ="select paper_name, author_name,affilinaty, conference, conference_name,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id "
								+ "and conference_id = 2014 ";
								//+ "group by author.paper_id";
						if(msg!= null)
						{
							String test = "and author.affilinaty like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
								//+ "group by author.paper_id";
						query = String.format("%s %s",query, "group by author.paper_id");
					}
					else
					{
						query ="select paper_name, author_name, affilinaty, conference, conference_name ,location "
								+ "from author, paper,conference "
								+ "where paper.conference = conference.conference_id and author.paper_id = paper.paper_id ";
								//+ "group by author.paper_id";
						if(msg!= null)
						{
							String test = "and author.affilinaty like '%";
							String test1 ="%'";
							System.out.println("msg:\t"+msg);
							test = String.format("%s%s%s",test,msg,test1);
							System.out.println("test:\t"+test);

							query=String.format("%s %s", query,test);
//							System.out.println("2:\t"+query);
						}
								//+ "group by author.paper_id";
						query = String.format("%s %s",query, "group by author.paper_id");
					}

						try {
							SQLsearch(query);
						} catch (SQLException e1) {
							// TODO Auto-generated catch block
							e1.printStackTrace();
						}

						//String[] coloumnNames = {"paper name", "paper's author","year", "conference name","conference location"}; 
						data = new Object[paper_name.size()][6];

						for(int i=0; i< paper_name.size();i++)
						{
							String[] arr = new String[6];
							arr[0] = paper_name.get(i);
							arr[1] = paper_author.get(i);
							arr[2] = affiliation.get(i);
							arr[3] = year.get(i);
							arr[4] = conference_name.get(i);
							arr[5] = location.get(i);
							tableModel.addRow(arr);
									
						}
						
						TableColumn column=null;
					    for (int i=0;i<6;i++){
					        column=table.getColumnModel().getColumn(i);
					        if (i == 0) column.setPreferredWidth(250);
					        else if(i == 3) column.setPreferredWidth(70);
					        else if(i == 4) column.setPreferredWidth(130);
					        else
					        column.setPreferredWidth(200);
					      }
						table.invalidate();
						//model.fireTableStructureChanged();
				}
			}
			
		}
		);



		Label label1 = new Label("key word:");
		
		

		jPanel1.add(jComboBox1);
		
		jPanel1.add(label1);
		jPanel1.add(text1);
		//jPanel1.add(jButton1);

		//单选
		jPanel1.add(radio1);  
		jPanel1.add(radio2);  
		jPanel1.add(radio3);
		//buttom
		jPanel1.add(jButton);
		//table
		jPanel1.add(pane);
		//
		//添加面板至父容器
		//contentPane.setLayout(new GridLayout(3,1));
		contentPane.add(jPanel1);
		//frame.pack();
		//设置本窗体的标题
		this.setTitle("search");
		//设置本窗体显示的初始大小
		this.setSize(C_Width,700);
		//设置本窗体初始可见
		this.setVisible(true);
		 
		// this.setVisible(true);
	}


	public static void main( String args[]) throws SQLException  {
		panelSQL pane = new panelSQL();
		//pane.SQLsearch();

	}


	private void SQLsearch(String query) throws SQLException{
		// TODO Auto-generated method stub
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}catch(ClassNotFoundException e)
		{
			e.printStackTrace();
		}
		
		Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sigmod","root","1926");
		java.sql.Statement stmt = conn.createStatement();
		java.sql.ResultSet rs = null;
		rs=stmt.executeQuery(query);
		

		//int i =0 ;
		// paper_name,paper_author, year, conference_name
		if(Search_In_Table.equals("pc"))
		{
			while(rs.next()){
				//Object[] raw = {rs.getString("paper_name"),rs.getString("author_name"),rs.getString("conference"),rs.getString("conference_name")};
				//System.out.println(rs.getString("member_name")+"\t"+rs.getString("affilinaty")+"\t"+rs.getString("conference_name") );
				pc_name.add(rs.getString("member_name"));
				pc_affiliation.add(rs.getString("affilinaty"));
				pc_conference.add(rs.getString("conference_name"));	

				   }
			
		}else
		{
			while(rs.next()){
			  //Object[] raw = {rs.getString("paper_name"),rs.getString("author_name"),rs.getString("conference"),rs.getString("conference_name")};
			  paper_name.add(rs.getString("paper_name"));
			  paper_author.add(rs.getString("author_name"));
			  year.add(rs.getString("conference"));
			  conference_name.add(rs.getString("conference_name"));
			  location.add(rs.getString("location"));
			  if(Search_In_Table.equals("affiliation"))
			  {
				  affiliation.add(rs.getString("affilinaty"));
			  }
			    //System.out.print("<Information>\n");
			    //System.out.println();
			   // i++;
			   }
		}



		
		rs.close();
		stmt.close();
		conn.close();
		
	}



}


Lycoris_
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
数据库管理系统（DBMS）理解及实现
yumengkk的专栏
09-19 3961
身份不同要对DBMS有不同的认识：       用户（处于逻辑层、视图层）：数据库管理系统（DBMS）的主要目的：为用户提供虚拟视图，隐藏数据存储和维护的物理细节，主要体现出方便和高效的特征。       1、方便：即提供一致、灵活的操作手段，解决查询问题——对应的结构部件为
DBMS-project:DBMS项目
04-15
DBIS项目 使用Java和MySQL的图书馆管理系统 小型项目 课程：CS 257 由开发 Bikash Kumar [ ] Piyush Kalkute 环境与要求 编程语言：带有Swing的JAVA MySQL连接器：MySQL JConnector 5.1.40（JDBC驱动程序） IDE：NetBeans 8.1 MySQL版本：5.5.4 MySQL工作台：6.3.6 + dfsg-0ubuntu1 在Ubuntu（16.04 LTS）中创建 关于文件 / SQL：包含导出的数据库架构+数据 / src / mainlibrary：包含JAVA源代码 / MySQL连接器：包含JDBC / MySQL JConnnector 指示 使用链接克隆项目或下载zip 在NetBeans中导入Java项目 在NetBeans 8.1中克隆项目 NetBeans
DBMS项目
02-24
这是一个电子商务网站，可以在其中发布广告并与其他卖家联系
dbms-project:DBMS项目阶段1
05-24
该网站是为DBMS课程第1阶段开发的
DBMS:数据库管理系统项目
06-27
数据库管理系统 数据库管理系统项目
DBMS的工作流程
bluespeedinfo的博客
04-10 3258
数据库系统基本概念差不多介绍了这么多，那么DBMS是如何工作的呢？数据库的数据又是如何存取的呢？深圳IT外包  http://www.lankuai.infoDBMS的工作过程如下：（1）应用程序通过相应的数据操纵语言向DBMS发出数据操作请求，并提交诸如记录类姓名和要读取的记录的关键字值等必要的参数，控制转入DBMS.（2）DBMS对应用程序中的数据操作进行分析，通过子模式/模式的映像、模式/存...
dbms project
beyondkim
06-17 37
DBMS_Project DBMS_Project 具体内容如下： 1, 需求分析 ​ 画出数据流图 2, 概念结构设计 3, 逻辑结构设计 4, 物理结构设计 5, 数据库行为设计及实现
DBMS-Project
03-31
新建一个名为DBMS_Project文件夹，然后在终端上运行以下命令 git clone https://github.com/muditsinghal/DBMS-Project.git cd DBMS-Project python -m venv venv venv\Scripts\activate pip install -r ...
dbms_project
03-26
在IT行业中，数据库管理系统（DBMS）是存储和管理数据的核心工具，而“dbms_project”这个项目显然与数据库管理系统的开发或应用有关。在这个项目中，Python编程语言被用作主要的实现工具，这表明可能涉及到使用...
DBMS_PROJECT
04-11
在DBMS_PROJECT-main这个压缩包文件中，我们可以期待找到项目的主要源代码、文档和其他资源。通常，这样的文件结构可能包括以下部分： 1. **源代码**：这部分可能包含用各种编程语言（如SQL、Java、Python或PHP）...
DBMS_Project
04-08
人脸识别 使用python和mysql进行人脸识别。 使用情况 环境 使用Anaconda创建虚拟环境。 conda create -n face python=3.x conda activate face pip install -r requirements.txt MySQL安装 ... # create database ...
自己做的简单的DBMS
07-07
DBMS，自己做的，只能实现简单的增删改查
数据库管理系统（DBMS）的概述
qq_41426442的博客
03-12 1449
数据库管理系统（DBMS）的概述数据库1 数据库的概念（了解）1.1 什么是数据库对数据进行管理的仓库DBMS:database  manage system仓库（database）  =   若干个表（table）1.2 常见的数据库MySQL、Oracle（神喻、神谕）、SqlServer(微软专用)、DB2、1.3 理解数据库库：多个表表：多个字段（列）字段：属性列：表的结构行：一条数据（在...
Amazon OA2准备——Round Robin Java实现
我是程序媛
10-16 6704
顺利的过了Amazon的OA1，所以开始准备OA2了。在Leetcode上面刷了一些题。不过很多题目leetcode上也没有。也有一道把O变成X的题目的示例输入我怎么都输入不进去，所以干脆放弃了。时间要紧。 所以第一道写了一亩三分地里面最近出现的比较多的Round Robin。给出几个Process的request  time和duration求average waiting time。
Amazon OA2准备——LRU cache
我是程序媛
10-18 6247
这道题目可以在leetcode找到 https://leetcode.com/problems/lru-cache/ ＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ Amazon OA中的题面是： 给一个array, 给一个cache max size, 输出miss count.
Amazon OA2准备——bst找最小路径
我是程序媛
10-18 4387
这道题我实际遇见了，还真是bst 题目中给的两个样例是..... 二叉查找树（英语：Binary Search Tree），也称二叉搜索树、有序二叉树（英语：ordered binary tree），排序二叉树（英语：sorted binary tree），是指一棵空树或者具有下列性质的二叉树： 若任意节点的左子树不空，则左子树上所有结点的值均小于或等于它的根结点的值；任意节点的右子树不空，则
两个数组求和为一个固定数值的所有组合java实现
我是程序媛
10-10 4090
如标题上说的，输入为a : {1,2,3,4}, b: {1,2,3,4} 输出为 {1,4}，{2,3}，{3,2}，{4,1} 输入数据没有重复，没有负数。不过这里我给出的解并不高效率。要考虑怎么样降低复杂度。当数字的个数很多的时候，这样的一个程序没有办法解决目标问题。 package quinn; import java.util.HashMap; public clas
Amazon OA1准备——去元音
我是程序媛
10-18 3728
这个和GrayCode是从一亩三分地比较早的地方翻出来的。感觉和现在OA1的程度差不多。如果遇上也就是运气好了吧。 题目很直白，就是一段字符，去除其中的元音（a,e,i,o,u） 给出实现 private static String removeV(String string) { // TODO Auto-generated method stub StringBuffer sb
【精美PPT课件】《关系数据库管理系统》课件第1－3章.ppt
06-05
数据库管理系统（DBMS）是实现这一目标的关键工具，它提供了一种方法来创建、维护和操作数据库。 数据模型是数据库设计的基础，它描述了数据如何被结构化和理解。根据课件，数据模型主要分为两大类：基于对象的逻辑...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值