Olah pessoal boa tarde... estou tentando montar uma estrutura para mostrar o resultado de uma pesquisa de modo que ao aparecere na tela o usuario possa alterar os valores se quiser.... Por exemplo uma tabela onde cada li…

JTable… http://java.sun.com/docs/books/tutorial/uiswing/components/table.html

Essa eh dificil...resultado de query em tabela

2 Respostas

FelipeSS_2PJ 20 de abr. de 2004

Cara posso te dizer como colocar na tabela , para editar e uma outra história

Vector lin= new Vector&#40;&#41;;
		Vector colun= new Vector&#40;&#41;;
		Vector dod= new Vector&#40;&#41;;	
		
	 String agenda="Select * from Principal";
	 
		try&#123;		
	con=c.getConect&#40;&#41;;
	LogB lb= new LogB&#40;&#41;;
	Statement st=con.createStatement&#40;&#41;;
	ResultSet rs=st.executeQuery&#40;agenda&#41;;
	ResultSetMetaData rsmd= rs.getMetaData&#40;&#41;;
	for&#40;int col=1;col&lt;=rsmd.getColumnCount&#40;&#41;;col++&#41;
		colun.add&#40;rsmd.getColumnName&#40;col&#41;&#41;;
		while&#40;rs.next&#40;&#41;&#41;&#123;
		dod.addElement&#40;Integer.toString&#40;rs.getInt&#40;1&#41;&#41;&#41;;
		dod.addElement&#40;rs.getString&#40;2&#41;&#41;;
		dod.addElement&#40;Integer.toString&#40;rs.getInt&#40;3&#41;&#41;&#41;;
		dod.addElement&#40;Integer.toString&#40;rs.getInt&#40;4&#41;&#41;&#41;;
		dod.addElement&#40;Integer.toString&#40;rs.getInt&#40;5&#41;&#41;&#41;;
		dod.addElement&#40;rs.getString&#40;6&#41;&#41;;
		dod.addElement&#40;rs.getString&#40;7&#41;&#41;;
		dod.addElement&#40;Integer.toString&#40;rs.getInt&#40;8&#41;&#41;&#41;;
		dod.addElement&#40;rs.getString&#40;9&#41;&#41;;
		
		
		lin.addElement&#40;dod&#41;;
		dod= new Vector&#40;&#41;;
		&#125;
			&#125;
		catch&#40;SQLException e&#41;&#123;
		JOptionPane.showMessageDialog&#40;null,"Erro"+e.getMessage&#40;&#41;,"Erro no Banco de dados",2&#41;;
			&#125;	
		finally&#123;
			c.desconnect&#40;&#41;;
			System.out.println&#40;"Conexão fechada em agenda&#40;&#41;"&#41;;
			&#125;
			tb=new JTable&#40;lin,colun&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;0&#41;.setPreferredWidth&#40;15&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;1&#41;.setPreferredWidth&#40;80&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;2&#41;.setPreferredWidth&#40;70&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;5&#41;.setPreferredWidth&#40;110&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;8&#41;.setPreferredWidth&#40;150&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;8&#41;.setHeaderValue&#40;"Endereço"&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;9&#41;.setMaxWidth&#40;0&#41;;
			tb.getColumnModel&#40;&#41;.getColumn&#40;10&#41;.setMaxWidth&#40;0&#41;;
			tb.getCellRenderer&#40;1,1&#41;;


			
			jsp=new JScrollPane&#40;tb&#41;;
			
			System.out.println&#40;""+tb.getRowCount&#40;&#41;+""&#41;;

Pode se usar vetor como ArrayList

2 Respostas

Topicos relacionados