package com.Myhome.model;
import java.util.Vector;
import javax.swing.JFrame;
import javax.swing.JScrollBar;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.sql.*;
public class one extends JFrame{
//rowData用来存放行数据
//columnNumes用来存放列名
Vector<String> rowData, columnNumes;
JTable jt=null;
JScrollPane jsp=null;
//定义操作数据库需要的松溪
PreparedStatement ps =null;
Connection ct =null;
ResultSet rs =null;
private Throwable e;
public static void main(String[] args) {
one one = new one();
}
//构造函数
public one(){
columnNumes = new Vector();
//设置列名
columnNumes.add("姓名");
columnNumes.add("性别");
columnNumes.add("年龄");
columnNumes.add("电话号码");
rowData = new Vector();
//rowData可以存放多行数据
//从数据库中读取数据
try {
//1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=sqdb1","dd","");
ps=ct.prepareStatement("select * form ZhuHu");
rs=ps.executeQuery();
while(rs.next()){
//rowData可以存放多行数据
Vector<Comparable> hang= new Vector<Comparable>();
hang.add(rs.getString(1));
hang.add(rs.getString(2));
hang.add(rs.getInt(3));
hang.add(rs.getString(4));
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}finally {
//关闭资源
try {
if(rs != null) rs.close();
if(ps !=null) ps.close();
if(ct !=null) ct.close();
} catch (Exception e2) {
e.printStackTrace();
// TODO: handle exception
}
}
//初始化JTable
jt = new JTable(rowData,columnNumes);
jsp = new JScrollPane();
//把JSP放在JFrame
this.add(jsp);
this.setSize(400, 300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
}