一個關于過程原碼

2019-11-18 15:19:23

字體：大中小

來源：轉載

供稿：網友

/*
*
* 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 (Illegal accessException 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);
}
});

}
}

上一篇：一個關于JAVA繪制仿真立體餅圖的程序源碼,供大家參考

下一篇：一個記事本的源程序