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