大家帮我看看这段代码为什么加载驱动失败

yw920827 2012-05-27 05:22:09
import java.awt.*; //导入java.awt包的所有类
import java.awt.event.*; //导入java.awt.event包的所有类
import javax.swing.*; //导入javax.swing包的所有类
import java.util.Random;
import java.sql.*;

public class shuxue extends JFrame {
JFrame fs;
JLabel
xTiMuLb,xXuanXiangLb;
JButton jiaojuanBT;
MenuBar kemuxuanzheJB;
Menu kemuxuanzheJM;
MenuItem
shuxueJI,yuwenJI;
CheckboxGroup[] xGroup=new CheckboxGroup[100];
Checkbox[] choiceA=new Checkbox[100];
Checkbox[] choiceB=new Checkbox[100];
Checkbox[] choiceC=new Checkbox[100];
Checkbox[] choiceD=new Checkbox[100];
String[] xDA=new String[100];
String[] xz=new String[100];
int[] xChouTi=new int[100];
public shuxue(){
fs=new JFrame("数学考试界面");
fs.setSize(400,400);
fs.setLocation(200,150);
fs.setLayout(null);
fs.setVisible(true);

jiaojuanBT=new JButton("交卷");
jiaojuanBT.setBounds(200,0,100,30);
fs.add(jiaojuanBT);

Random rx=new Random();
String driver="com.mysql.jdbc.Driver";
String connStr="jdbc:mysql://localhost:3306/xuesheng?user=root&password=01083686859";
Connection conn=null;
try
{

Class cl=Class.forName(driver);
conn = DriverManager.getConnection(connStr);
Statement stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rst=stm.executeQuery("SELECT * from math");

int xRowNumber=0;
for(int i=0;i<5;i++)
{
xChouTi[i]=rx.nextInt(xRowNumber)+1;
rst.absolute(xChouTi[i]);

String tihao=rst.getString(1);
String timu=rst.getString(2);
String a=rst.getString(3);
String b=rst.getString(4);
String c=rst.getString(5);
String d=rst.getString(6);

xDA[i]=rst.getString(7).trim();

xTiMuLb=new JLabel();
xTiMuLb.setAlignmentX(Label.LEFT);
xTiMuLb.setText((i+1)+"、"+timu);
xTiMuLb.setBounds(20,60+i*40,500,20);
fs.add(xTiMuLb);
xXuanXiangLb=new JLabel();
xXuanXiangLb.setAlignmentX(Label.LEFT);
xXuanXiangLb.setText("A."+a+" B."+b+" C."+c+" D."+d);
xXuanXiangLb.setBounds(20,80+i*40,700,20);
fs.add(xXuanXiangLb);
xGroup[i]=new CheckboxGroup();
choiceA[i]=new Checkbox("A",xGroup[i],false);
choiceB[i]=new Checkbox("B",xGroup[i],false);
choiceC[i]=new Checkbox("C",xGroup[i],false);
choiceD[i]=new Checkbox("D",xGroup[i],false);
choiceA[i].setBounds(550,60+i*40,40,20);
choiceB[i].setBounds(600,60+i*40,40,20);
choiceC[i].setBounds(650,60+i*40,40,20);
choiceD[i].setBounds(700,60+i*40,40,20);
fs.add(choiceA[i]);
fs.add(choiceB[i]);
fs.add(choiceC[i]);
fs.add(choiceD[i]);
}
for(int j=0;j<5;j++)
{
if(xGroup[j].getSelectedCheckbox()==choiceA[j])
{
xz[j]="A";
}
if(xGroup[j].getSelectedCheckbox()==choiceB[j])
{
xz[j]="B";
}
if(xGroup[j].getSelectedCheckbox()==choiceC[j])
{
xz[j]="C";
}
if(xGroup[j].getSelectedCheckbox()==choiceD[j])
{
xz[j]="D";
}
if(xGroup[j].getSelectedCheckbox()==null)
{
xz[j]="E";
}
}

conn.close();
}
catch(SQLException ee)
{
System.out.println("数据库加载失败");
ee.printStackTrace();
}
catch(Exception ee)
{
System.out.println("驱动程序加载失败:"+driver);
ee.printStackTrace();
}
}
public static void main(String args[])
{
new shuxue();
}
}
...全文
111 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
古布 2012-05-27
  • 打赏
  • 举报
回复
比较一下好用的和不好用的。
没看到错误消息,不会判断
yw920827 2012-05-27
  • 打赏
  • 举报
回复
package student;

import java.awt.*; //导入java.awt包的所有类
import java.awt.event.*; //导入java.awt.event包的所有类
import javax.swing.*; //导入javax.swing包的所有类

import java.util.Random;
import java.sql.*; //导入数据库编程所需的类和接口
import static student.wei.*;
public class confirm extends WindowAdapter implements ActionListener
{
JFrame
f1,fx,f4,f5,f6;
JLabel
sxuehaoLb,smimaLb,guizhe1La,guizhe2La,guizhe3La,guizhe4La,xTiMuLb,xXuanXiangLb,chengjiLb,txuehaoLb,tmimaLb,gxuehaoLb,gmimaLb;
JTextField
sxuehaoTF,smimaTF,chengjiTF,txuehaoTF,gxuehaoTF,tmimaTF,gmimaTF;
JButton
squedingBT,kaishikaoshiBT,confirmBT,shiBT,fouBT,studentBT,teacherBT,guanliBT,tquedingBT,gquedingBT,jiaojuanBT;
JDialog
guizheDlg,jiaojuanDlg,kaoshiDlg;
MenuBar kemuxuanzheJB;
Menu kemuxuanzheJM;
MenuItem
shuxueJI,yuwenJI;
CheckboxGroup[] xGroup=new CheckboxGroup[100];
Checkbox[] choiceA=new Checkbox[100];
Checkbox[] choiceB=new Checkbox[100];
Checkbox[] choiceC=new Checkbox[100];
Checkbox[] choiceD=new Checkbox[100];
String[] xDA=new String[100];
String[] xz=new String[100];
String Str1,Str2;
int[] xChouTi=new int[100];
int fenshu;

public confirm()
{
fenshu=0;

f1=new JFrame("学生考试登陆");
f1.setSize(400,400);
f1.setLocation(200,150);
f1.setLayout(null);
f1.setVisible(true);

sxuehaoLb=new JLabel();
sxuehaoLb.setAlignmentX(Label.LEFT);
sxuehaoLb.setText("学号");
sxuehaoLb.setBounds(20, 50, 40, 30);
f1.add(sxuehaoLb);

smimaLb=new JLabel();
smimaLb.setAlignmentX(Label.LEFT);
smimaLb.setText("密码");
smimaLb.setBounds(20, 80, 40, 30);
f1.add(smimaLb);

sxuehaoTF=new JTextField();
TFrun(sxuehaoTF,65,50,150,30);
f1.add(sxuehaoTF);

smimaTF=new JTextField();
TFrun(smimaTF,65,80,150,30);
f1.add(smimaTF);

squedingBT=new JButton("确定");
squedingBT.setBounds(200,120 ,100,30 );
squedingBT.addActionListener(this);
f1.add(squedingBT);

guizheDlg=new JDialog(f1,"考试规则");
guizheDlg.setSize(550, 400);
guizheDlg.setLocation(250, 160);
guizheDlg.setLayout(null);
guizheDlg.addWindowListener(this);

guizhe1La=new JLabel();
guizhe1La.setAlignmentX(Label.CENTER);
guizhe1La.setBounds(90, 20, 500, 30);
guizhe1La.setText("1. 确认考试科目后,系统根据考试科目对应的科目从题库随机抽取试题");
guizheDlg.add(guizhe1La);

guizhe2La=new JLabel();
guizhe2La.setAlignmentX(Label.CENTER);
guizhe2La.setBounds(90, 40, 500, 30);
guizhe2La.setText("2.学生做完题目后,所选全部答案将记录在分数表中;");
guizheDlg.add(guizhe2La);

guizhe3La=new JLabel();
guizhe3La.setAlignmentX(Label.CENTER);
guizhe3La.setBounds(90, 60, 500, 30);
guizhe3La.setText("3.当学生提交试卷或考试时间到时,系统会给出分数");
guizheDlg.add(guizhe3La);

guizhe4La=new JLabel();
guizhe4La.setAlignmentX(Label.CENTER);
guizhe4La.setBounds(90,80, 500, 30);
guizhe4La.setText("4.迟到1小时以上的考生禁止进行该科目的考试");
guizheDlg.add(guizhe4La);

kaishikaoshiBT=new JButton("开始考试");
kaishikaoshiBT.setBounds(60,160 ,200,30 );
kaishikaoshiBT.addActionListener(this);
guizheDlg.add(kaishikaoshiBT);

fx=new JFrame("考试界面");
fx.setSize(500,500);
fx.setLocation(200,150);
fx.setLayout(null);

jiaojuanBT=new JButton("交卷");
jiaojuanBT.setBounds(200,0,100,30);
jiaojuanBT.addActionListener(this);
fx.add(jiaojuanBT);

jiaojuanDlg=new JDialog(fx,"交卷");
jiaojuanDlg.setSize(500, 500);
jiaojuanDlg.setLocation(250, 160);
jiaojuanDlg.setLayout(null);

shiBT=new JButton("确认");
shiBT.setBounds(60,160 ,100,30 );
fouBT=new JButton("否");
fouBT.setBounds(60,160 ,100,60 );
shiBT.addActionListener(this);
fouBT.addActionListener(this);
jiaojuanDlg.add(shiBT);
jiaojuanDlg.add(fouBT);

chengjiLb=new JLabel();
chengjiLb=new JLabel();
chengjiLb.setAlignmentX(Label.LEFT);
chengjiLb.setText("成绩");
chengjiLb.setBounds(20, 50, 100, 30);
jiaojuanDlg.add(chengjiLb);

chengjiTF=new JTextField();
TFrun(chengjiTF,65,80,150,30);
jiaojuanDlg.add(chengjiTF);

kemuxuanzheJB=new MenuBar();
kemuxuanzheJM=new Menu("科目选择");
shuxueJI=new MenuItem("数学");
yuwenJI=new MenuItem("语文");
kemuxuanzheJB.add(kemuxuanzheJM);
kemuxuanzheJM.add(shuxueJI);
kemuxuanzheJM.add(yuwenJI);
fx.setMenuBar(kemuxuanzheJB);

fx.addWindowListener(this);
shuxueJI.addActionListener(this);
yuwenJI.addActionListener(this);
jiaojuanDlg.addWindowListener(this);


f1.addWindowListener(this);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==squedingBT)
{
Str1=sxuehaoTF.getText().trim();
Str2=smimaTF.getText().trim();
String driver="com.mysql.jdbc.Driver";
String connStr="jdbc:mysql://localhost:3306/xuesheng?user=root&password=01083686859";
Connection conn=null;
try
{
Class cl=Class.forName(driver);
conn = DriverManager.getConnection(connStr);
Statement stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rst=stm.executeQuery("SELECT * from 学生");
for(int j=0;rst.next();j++)
{
String xuehao=rst.getString(1).trim();
String mima=rst.getString(2).trim();

if(xuehao.equals(Str1)&&mima.equals(Str2))
{
f1.setVisible(false);
guizheDlg.setVisible(true);
break;
}
if(xuehao.equals(Str1)&&!mima.equals(Str2))
{
JOptionPane.showMessageDialog(f1,"输入有误,请确认后再输入","警告提示框",JOptionPane.WARNING_MESSAGE);
break;
}
}
conn.close();
}

catch(SQLException ee)
{
System.out.println("数据库连接失败!");
ee.printStackTrace();
}
catch(Exception ee)
{
System.out.println("驱动程序加载失败:"+driver);
ee.printStackTrace();
}
}
if(e.getSource()==kaishikaoshiBT)
{
guizheDlg.setVisible(false);
fx.setVisible(true);
}
Random rx=new Random();
if(e.getSource()==shuxueJI)
{
String driver="com.mysql.jdbc.Driver";
String connStr="jdbc:mysql://localhost:3306/xuesheng?user=root&password=01083686859";
Connection conn=null;
try
{

Class cl=Class.forName(driver);
conn = DriverManager.getConnection(connStr);
Statement stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rst=stm.executeQuery("SELECT * from 数学");

int xRowNumber=0;
for(int i=0;i<5;i++)
{
xChouTi[i]=rx.nextInt(xRowNumber)+1;
rst.absolute(xChouTi[i]);

String tihao=rst.getString(1);
String timu=rst.getString(2);
String a=rst.getString(3);
String b=rst.getString(4);
String c=rst.getString(5);
String d=rst.getString(6);

xDA[i]=rst.getString(7).trim();

xTiMuLb=new JLabel();
xTiMuLb.setAlignmentX(Label.LEFT);
xTiMuLb.setText((i+1)+"、"+timu);
xTiMuLb.setBounds(20,60+i*40,500,20);
fx.add(xTiMuLb);
xXuanXiangLb=new JLabel();
xXuanXiangLb.setAlignmentX(Label.LEFT);
xXuanXiangLb.setText("A."+a+" B."+b+" C."+c+" D."+d);
xXuanXiangLb.setBounds(20,80+i*40,700,20);
fx.add(xXuanXiangLb);
xGroup[i]=new CheckboxGroup();
choiceA[i]=new Checkbox("A",xGroup[i],false);
choiceB[i]=new Checkbox("B",xGroup[i],false);
choiceC[i]=new Checkbox("C",xGroup[i],false);
choiceD[i]=new Checkbox("D",xGroup[i],false);
choiceA[i].setBounds(550,60+i*40,40,20);
choiceB[i].setBounds(600,60+i*40,40,20);
choiceC[i].setBounds(650,60+i*40,40,20);
choiceD[i].setBounds(700,60+i*40,40,20);
fx.add(choiceA[i]);
fx.add(choiceB[i]);
fx.add(choiceC[i]);
fx.add(choiceD[i]);
}
for(int j=0;j<5;j++)
{
if(xGroup[j].getSelectedCheckbox()==choiceA[j])
{
xz[j]="A";
}
if(xGroup[j].getSelectedCheckbox()==choiceB[j])
{
xz[j]="B";
}
if(xGroup[j].getSelectedCheckbox()==choiceC[j])
{
xz[j]="C";
}
if(xGroup[j].getSelectedCheckbox()==choiceD[j])
{
xz[j]="D";
}
if(xGroup[j].getSelectedCheckbox()==null)
{
xz[j]="E";
}
}
if(e.getSource()==jiaojuanBT)
{

fx.setVisible(false);
jiaojuanDlg.setVisible(true);

if(e.getSource()==fouBT)
{
jiaojuanDlg.setVisible(false);
fx.setVisible(true);
}
if(e.getSource()==shiBT)
{
for(int i=0;i<5;i++)
{
if(xDA[i].equals(xz[i]))
fenshu=fenshu+20;
}
}
}
chengjiTF.setText("分数是:"+fenshu);
fenshu=0;
conn.close();
}
catch(SQLException ee)
{
System.out.println("数据库加载失败");
ee.printStackTrace();
}
catch(Exception ee)
{
System.out.println("驱动程序加载失败:"+driver);
ee.printStackTrace();
}
}
public static void main(String args[])
{
new confirm();
}
}
yw920827 2012-05-27
  • 打赏
  • 举报
回复
我要做的是一个考试系统,开始输入账号,密码是链接数据库没有问题,可是链接题目的表时却不能了
yw920827 2012-05-27
  • 打赏
  • 举报
回复
楼上的不对啊
古布 2012-05-27
  • 打赏
  • 举报
回复
String connStr="jdbc:mysql://localhost:3306/xuesheng?user=root&password=01083686859";
==>
String connStr="jdbc:mysql://localhost:3306/xuesheng?user=root;password=01083686859";

23,407

社区成员

发帖
与我相关
我的任务
社区描述
Java 非技术区
社区管理员
  • 非技术区社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧