java随机抽题系统_随机抽取试题（java+sql 2005）

import java.awt.BorderLayout;

import java.util.*;

import java.awt.event.*;

import java.awt.Container;

import java.awt.EventQueue;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

public class Test extends JFrame {

public static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";

public static final String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=SystemTest;SelectMethod=Cursor";

public static final String DBUSER="sa";

public static final String DBPASSWORD="123";

public static Connection conn=null;

public static Statement stmt=null;

public static Statement stmt1=null;

public static Statement stmt2=null;

public static ResultSet rs=null;

public static ResultSet rs1=null;

public static void main(String args[]) {

try{

//数据库的连接。

Class.forName(DBDRIVER);

conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);

stmt= conn.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

stmt1= conn.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

stmt2= conn.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

}catch(Exception e)

{

e.printStackTrace();

}

Test t1=new Test();

t1.sel_save();

EventQueue.invokeLater(new