java 连接sql2005数据库

来源：互联网发布：龙华行知小学校长编辑：程序博客网时间：2024/05/17 06:35

/**
* 从数据库里面取出数据信息
*/
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);

   }
}

0 0