package main;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Vector;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
public class DisplayPerson extends javax.swing.JFrame {
/** Creates new form display */
public DisplayPerson() {
createTableModel();
}
private void createTableModel() {
JTable JTableView = new JTable();
jScrollPane1 = new javax.swing.JScrollPane();
DefaultTableModel JTableModel = new DefaultTableModel(200,2);
JTableModel.addColumn("PersonId");
JTableModel.addColumn("age");
JTableView.setModel(JTableModel);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
JTableView.setModel(new javax.swing.table.DefaultTableModel(
new Object[][] { }, new String[] { "PersonId",
"age"}));
jScrollPane1.setViewportView(JTableView);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(
getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(layout.createParallelGroup(
javax.swing.GroupLayout.Alignment.LEADING).addGroup(
layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1,
javax.swing.GroupLayout.PREFERRED_SIZE, 375,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(13, Short.MAX_VALUE)));
layout.setVerticalGroup(layout.createParallelGroup(
javax.swing.GroupLayout.Alignment.LEADING).addGroup(
layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1,
javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)));
pack();
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
String dbURL = "jdbc:sqlserver://127.0.0.1:1433; DatabaseName=student";
String userName = "root";
String userPwd = "123";
Connection dbConn;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
Statement st = dbConn.createStatement();
ResultSet rs = st.executeQuery("select * from Person");
while (rs.next())
{
Vector<Integer> vcRows = new Vector<Integer>();
vcRows.addElement(rs.getInt(1));
vcRows.addElement(rs.getInt(2));
// JTableModel.addRow(rs.getInt(1)); //error
// JTableModel.addRow(rs.getString(2)); //error
JTableModel.addRow(vcRows); //添加一行记录到表格模板中
}
//5.关闭连接
rs.close();
st.close();
dbConn.close();
// DBConnection.closeStmtAndCon(); //关闭相关连接
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new DisplayPerson().setVisible(true);
}
});
}
//GEN-BEGIN:variables
// Variables declaration - do not modify
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable JTableView;
// End of variables declaration//GEN-END:variables
}