为什么少一条数据而且是第一条
package projcet;
import java.sql.*;
import java.sql.DriverManager;
import java.util.Vector;
public class db {
//一个获得连接方法
public Connection getcon(){
Connection con=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("Jdbc:Odbc:xiaohe");
}catch(ClassNotFoundException e){
e.printStackTrace();
} catch(SQLException ee){
ee.printStackTrace();
}
return con;
}
//获得查询是否有此人的信息
/* public boolean selects(String name){
Connection con=this.getcon();
boolean flag=false;
Statement stm=null;
ResultSet rs=null;
String sql="select * from msg where liogname=?";
try{
stm=con.createStatement();
rs=stm.executeQuery(sql);
// if(rs.next()){
// flag=true;
// }
}catch(SQLException e){
e.printStackTrace();
}
// return flag;
}
*/
//获得结果集的方法
public ResultSet huode(){
Connection con=this.getcon();
Statement stm=null;
ResultSet rs=null;
String sql="select * from msg ";
try{
stm = con.createStatement();
rs = stm.executeQuery(sql);
if(rs.next()){
rs.getString(1);
rs.getString(2);
rs.getInt(3);
}
}catch(SQLException e){
e.printStackTrace();
}
return rs;
}
//封状数据库的数据
public Vector fengzhuang(){
Connection con=this.getcon();
ResultSet rs=this.huode();
Vector vd=new Vector();
try{
while (rs.next()) {
Vector vx = new Vector();
vx.add(rs.getString(1));
vx.add(rs.getString(2));
vx.add(rs.getString(3));
vd.add(vx);
}
}catch(Exception e){
e.printStackTrace();
}
return vd;
}
}
package projcet;import java.awt.BorderLayout;
import java.awt.Dimension;import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
import javax.swing.JScrollPane;public class Frame1 extends JFrame {
JPanel contentPane;
BorderLayout borderLayout1 = new BorderLayout();
db d=new db();
Vector date=d.fengzhuang();
Vector name=new Vector();
int n=name.size();
DefaultTableModel model= new DefaultTableModel(date,n);
JTable table = new JTable();
JTableHeader head = table.getTableHeader();
public Frame1() {
try {
setDefaultCloseOperation(EXIT_ON_CLOSE);
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
contentPane = (JPanel) getContentPane();
contentPane.setLayout(borderLayout1);
setSize(new Dimension(400, 300));
setTitle("显示数据");
contentPane.add(table, java.awt.BorderLayout.SOUTH);
contentPane.add(head, java.awt.BorderLayout.NORTH);
contentPane.add(table, java.awt.BorderLayout.CENTER);
name.add("登陆名");
name.add("用户名");
name.add("年龄");
model.setDataVector(date,name);
table.setModel(model);
}
}
package projcet;
import java.sql.*;
import java.sql.DriverManager;
import java.util.Vector;
public class db {
//一个获得连接方法
public Connection getcon(){
Connection con=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("Jdbc:Odbc:xiaohe");
}catch(ClassNotFoundException e){
e.printStackTrace();
} catch(SQLException ee){
ee.printStackTrace();
}
return con;
}
//获得查询是否有此人的信息
/* public boolean selects(String name){
Connection con=this.getcon();
boolean flag=false;
Statement stm=null;
ResultSet rs=null;
String sql="select * from msg where liogname=?";
try{
stm=con.createStatement();
rs=stm.executeQuery(sql);
// if(rs.next()){
// flag=true;
// }
}catch(SQLException e){
e.printStackTrace();
}
// return flag;
}
*/
//获得结果集的方法
public ResultSet huode(){
Connection con=this.getcon();
Statement stm=null;
ResultSet rs=null;
String sql="select * from msg ";
try{
stm = con.createStatement();
rs = stm.executeQuery(sql);
if(rs.next()){
rs.getString(1);
rs.getString(2);
rs.getInt(3);
}
}catch(SQLException e){
e.printStackTrace();
}
return rs;
}
//封状数据库的数据
public Vector fengzhuang(){
Connection con=this.getcon();
ResultSet rs=this.huode();
Vector vd=new Vector();
try{
while (rs.next()) {
Vector vx = new Vector();
vx.add(rs.getString(1));
vx.add(rs.getString(2));
vx.add(rs.getString(3));
vd.add(vx);
}
}catch(Exception e){
e.printStackTrace();
}
return vd;
}
}
package projcet;import java.awt.BorderLayout;
import java.awt.Dimension;import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
import javax.swing.JScrollPane;public class Frame1 extends JFrame {
JPanel contentPane;
BorderLayout borderLayout1 = new BorderLayout();
db d=new db();
Vector date=d.fengzhuang();
Vector name=new Vector();
int n=name.size();
DefaultTableModel model= new DefaultTableModel(date,n);
JTable table = new JTable();
JTableHeader head = table.getTableHeader();
public Frame1() {
try {
setDefaultCloseOperation(EXIT_ON_CLOSE);
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
contentPane = (JPanel) getContentPane();
contentPane.setLayout(borderLayout1);
setSize(new Dimension(400, 300));
setTitle("显示数据");
contentPane.add(table, java.awt.BorderLayout.SOUTH);
contentPane.add(head, java.awt.BorderLayout.NORTH);
contentPane.add(table, java.awt.BorderLayout.CENTER);
name.add("登陆名");
name.add("用户名");
name.add("年龄");
model.setDataVector(date,name);
table.setModel(model);
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货