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{
if (rs.next()) {
Vector vx = new Vector();
vx.addElement(rs.getString(1));
vx.addElement(rs.getString(2));
vx.addElement(rs.getInt(3));
vd.addElement(vx);
}
}catch(SQLException 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;public class Frame1 extends JFrame {
JPanel contentPane;
BorderLayout borderLayout1 = new BorderLayout();
db d=new db();
Vector date=d.fengzhuang();
Vector name=new Vector();
DefaultTableModel model= new DefaultTableModel(date,name);
JTable table = new JTable(model);
//JTableHeader head=tabel.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("Frame Title");
contentPane.add(table, java.awt.BorderLayout.CENTER);
contentPane.add(table, java.awt.BorderLayout.NORTH);
//给他设置一个表头
name.addElement("a");
name.addElement("b");
name.addElement("c");
int row=table.getEditingRow();
int culumn=table.getColumnCount();
String na=(String)table.getValueAt(row,culumn);
}
}
package projcet;import java.awt.Toolkit;
import javax.swing.SwingUtilities;
import javax.swing.UIManager;
import java.awt.Dimension;//一个运行类
public class Application1 {
boolean packFrame = false; /**
* Construct and show the application.
*/
public Application1() {
Frame1 frame = new Frame1();
// Validate frames that have preset sizes
// Pack frames that have useful preferred size info, e.g. from their layout
if (packFrame) {
frame.pack();
} else {
frame.validate();
} // Center the window
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = frame.getSize();
if (frameSize.height > screenSize.height) {
frameSize.height = screenSize.height;
}
if (frameSize.width > screenSize.width) {
frameSize.width = screenSize.width;
}
frame.setLocation((screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
frame.setVisible(true);
} /**
* Application entry point.
*
* @param args String[]
*/
public static void main(String[] args) {
SwingUtilities.invokeLater(new Runnable() {
public void run() {
try {
UIManager.setLookAndFeel(UIManager.
getSystemLookAndFeelClassName());
} catch (Exception exception) {
exception.printStackTrace();
} new Application1();
}
});
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货