利用Java+sqlserver 实现对数据库的操作

sql 脚本

use master
go
if exists(select * from sysdatabases where name='bank')
drop database bank
go
create database bank
go
use bank
go
if exists(select * from sysobjects where name='userinfo')
drop table userinfo
go
create table userinfo
(
uname varchar(12) ,
upwd varchar(12),
utype varchar(2)
)
go
if exists (select * from sysobjects where name='bankmoney')
drop table bankmoney
go
create table bankmoney
(
uname varchar(12),
nowmoney money
)
go
java 脚本
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
public class Tabletest extends JFrame {
private DefaultTableModel dtm;
private ResultSetMetaData rsmd;
private JScrollPane jp;
private JTable jt;
private ResultSet rs;
private JButton jb1,jb2;
private JPanel jpan;
public Tabletest()
{
ResultSet rs;
Statement st;
Conn con=new Conn();
String sql="select uname as 用户名,upwd as 密码,utype as 类型 from userinfo";
try {
st=con.getConn().createStatement();
rs=st.executeQuery(sql);
Vector  v=new Vector();
dtm=new DefaultTableModel(v,0);
rsmd=rs.getMetaData();
int index=rsmd.getColumnCount();
for(int i=1;i<=index;i++)
{
v.addElement(rsmd.getColumnName(i));
}
while(rs.next())
{
Vector v1=new  Vector();
for(int i=1;i<=index;i++)
{
v1.addElement(rs.getString(i));
}
dtm.addRow(v1);
}
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
jb2=new JButton("信息");
jb1=new JButton("确定");
jpan=new JPanel();
jpan.add(jb2);
jpan.add(jb1);
jt=new JTable(  dtm);
jp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
this.add(jpan,"North");
this.add(jp,"Center");
this.setVisible(true);
this.pack();
this.setLocation(400, 300);
this.setResizable(false);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public static void main(String[] args)
{
new Tabletest();
}
}