/**
* 从数据库里面取出数据信息
*/
package com.database.input;
import java.sql.*;
import java.awt.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
public class inputData extends JFrame{
PreparedStatement ps = null;
Connection ct = null;
ResultSet rs = null;
Vector rowData, columnNames;
JTable jt = null;
JScrollPane jsp = null;
public static void main(String[] args) {
// TODO Auto-generated method stub
System.out.println("hello world1!");
inputData myData = new inputData();
}
public inputData()
{
columnNames = new Vector();
columnNames.add("学号");
columnNames.add("名字");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("籍贯");
columnNames.add("系别");
//行数据
rowData = new Vector();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //当引入包之后 还显示找不到驱动其实是这句的问题
ct = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=MyData","sa","smile@heart"); //还有这个连接也是重点
ps = ct.prepareStatement("select * from student");
rs = ps.executeQuery();
while(rs.next()){
Vector data = new Vector();
data.add(rs.getString(1));
data.add(rs.getString(2));
data.add(rs.getString(3));
data.add(rs.getInt(4));
data.add(rs.getString(5));
data.add(rs.getString(6));
rowData.add(data);
}
}catch(Exception e){
e.printStackTrace();
} finally{
try{
if(rs != null){
ct.close();
}
if(ps != null){
ps.close();
}
if(ct != null){
ct.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
jt = new JTable(rowData,columnNames);
jsp = new JScrollPane(jt);
this.add(jsp);
this.setSize(400, 300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
}
* 从数据库里面取出数据信息
*/
package com.database.input;
import java.sql.*;
import java.awt.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
public class inputData extends JFrame{
PreparedStatement ps = null;
Connection ct = null;
ResultSet rs = null;
Vector rowData, columnNames;
JTable jt = null;
JScrollPane jsp = null;
public static void main(String[] args) {
// TODO Auto-generated method stub
System.out.println("hello world1!");
inputData myData = new inputData();
}
public inputData()
{
columnNames = new Vector();
columnNames.add("学号");
columnNames.add("名字");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("籍贯");
columnNames.add("系别");
//行数据
rowData = new Vector();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //当引入包之后 还显示找不到驱动其实是这句的问题
ct = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=MyData","sa","smile@heart"); //还有这个连接也是重点
ps = ct.prepareStatement("select * from student");
rs = ps.executeQuery();
while(rs.next()){
Vector data = new Vector();
data.add(rs.getString(1));
data.add(rs.getString(2));
data.add(rs.getString(3));
data.add(rs.getInt(4));
data.add(rs.getString(5));
data.add(rs.getString(6));
rowData.add(data);
}
}catch(Exception e){
e.printStackTrace();
} finally{
try{
if(rs != null){
ct.close();
}
if(ps != null){
ps.close();
}
if(ct != null){
ct.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
jt = new JTable(rowData,columnNames);
jsp = new JScrollPane(jt);
this.add(jsp);
this.setSize(400, 300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
}