/*
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
/**
* @author cw
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
public class ProcedureExample1 extends JFrame {
private Statement stam;
private Connection con;
private ResultSet resultSet;
private ResultSetMetaData rsMetaData;
public JButton BTy;
public JLabel lb1;
public JButton btsave;
public JTable table;
public ProcedureExample1()
{
super("关于存储过程");
String url="jdbc:jtds:sqlserver://192.168.254.222:1433/currentdb";;
String user="sa";
String passWord="";
try{
/* Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://hxdz05:1433;databaseName=currentdb",user,password);
*/
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
con= DriverManager.getConnection(
url, user, password );
}
catch(ClassNotFoundException cnfex){
System.err.println("装载JdBC驱动程序失败！");
cnfex.printStackTrace();
System.exit(1);
}
catch(SQLException sqlex){
System.err.println("无法连接数据库");
sqlex.printStackTrace();
System.exit(1);
}
catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//catch()
//String test="select * from vendorcom";
bty=new JButton("审核");
btsave=new JButton("保存");
lb1=new JLabel("实例程序显示",SwingConstants.CENTER);
bty.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
getTable();
}
});
JPanel toppanel =new JPanel();
toppanel.setBackground(Color.white);
toppanel.setBorder(BorderFactory.createBevelBorder(0));
toppanel.setLayout(new BorderLayout());
toppanel.add(lb1,BorderLayout.CENTER);
toppanel.setSize(440,100);
JPanel rightpanel=new JPanel();
rightpanel.setBackground(Color.white);
rightpanel.setBorder(BorderFactory.createBevelBorder(0));
rightpanel.setLayout(new FlowLayout());
rightpanel.add(bty);
rightpanel.add(btsave);
rightpanel.setLocation(20,300);
/*rightpanel.setLayout(null);
rightpanel.setBounds(new Rectangle(465,))
rightpanel.add(btsave,BorderLayout.CENTER);
*/
table=new JTable();
table.setSize(440,240);
Container c=getContentPane();
c.setLayout(new BorderLayout());
c.add(toppanel,BorderLayout.NORTH);
c.add(rightpanel,BorderLayout.EAST);
c.add(new JScrollPane(table),BorderLayout.CENTER);
table.getAutoCreateColumnsFromModel();
//c.add(table.getTableHeader(),BorderLayout.NORTH);
//getTable();
setSize(500,300);
setVisible(true);
}
private void getTable()
{
try{
String test="select * from vendorcom";
stam=con.createStatement();
resultSet =stam.executeQuery(test);
//输出结果的方法
displayResultSet(resultSet);
}
catch(SQLException e)
{
e.printStackTrace();
}
}
private void displayResultSet(ResultSet rs)throws SQLException
{
boolean moreRecords=rs.next();
if(!moreRecords){
JOptionPane.showMessageDialog(this,"没有所查的记录","结果",JOptionPane.INFORMATION_MESSAGE);
}
Vector columnHeads=new Vector();
Vector rows=new Vector();
try{ //rsmd.getColumnCount()
ResultSetMetaData rsmd=rs.getMetaData();
for(int i=1;i<=5;i++)
columnHeads.addElement(rsmd.getColumnName(i));
do{
rows.addElement(getNextRow(rs,rsmd));
}
while(rs.next());
table=new JTable(rows,columnHeads);
table.setLocation(440,240);
table.getAutoCreateColumnsFromModel();
JScrollPane Scroll=new JScrollPane(table);
Container c=getContentPane();
//c.remove(1);
c.add(Scroll,BorderLayout.CENTER);
c.validate();
}
catch(SQLException sqlex){
sqlex.printStackTrace();
}
}
private Vector getNextRow(ResultSet rs,ResultSetMetaData rsmd)throws SQLException{
Vector currentRow=new Vector();
for(int i=1;i<=5;i++)
currentRow.addElement(rs.getString(i));
return currentRow;
}
public void shutDown()
{
try{
con.close();
}
catch(SQLException sqlex){
System.err.println("不能断开连接");
sqlex.printStackTrace();
}
}
public static void main(String[] args) {
/* try
{
UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
}
catch (Exception e){}
* */
ProcedureExample1 pd=new ProcedureExample1();
pd.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
});
}
}