读书人

Database 导不进来?该如何解决

发布时间: 2012-02-04 15:43:09 作者: rapoo

Database 导不进来?
package steudent;

import java.util.*;
import java.sql.*;
import javax.swing.*;

/**
* 有关学生信息数据库操作的类
*/
public class StuBean {
String sql;
ResultSet rs = null;

String sNum;
String sName;
String sSex;
String sBirth;
String sHome;
String sEthnic;
String sYear;
String sMajor;
String sCollege;

String colName;//列名
String colValue;//列值
String colValue2;//列值

int stuId;//学生的新学号

/**
* 添加学生信息
*/
public void stuAdd(String name, String sex, String birth, String home, String ethnic, String year, String major, String college){

Database DB = new Database();

this.sName = name;
this.sSex = sex;
this.sBirth = birth;
this.sHome = home;
this.sEthnic = ethnic;
this.sYear = year;
this.sMajor = major;
this.sCollege = college;

if(sName == null||sName.equals( " ")){
JOptionPane.showMessageDialog(null, "请输入学生姓名 ", "错误 ", JOptionPane.ERROR_MESSAGE);


return;
}
else{
sql = "insert into student(sname,ssex,sbirth,shome,sethnic,syear,smajor,scollege) values ( ' "+sName+ " ', ' "+sSex+ " ', ' "+sBirth+ " ', ' "+sHome+ " ', ' "+sEthnic+ " ', ' "+sYear+ " ', ' "+sMajor+ " ', ' "+sCollege+ " ') ";

try{
DB.OpenConn();
DB.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "成功添加一条新的纪录! ");

}
catch(Exception e){
System.out.println(e);
JOptionPane.showMessageDialog(null, "保存失败 ", "错误 ", JOptionPane.ERROR_MESSAGE);
}
finally {
DB.closeStmt();
DB.closeConn();


}
}
}
...............................................................

/////////////////////////
Database DB = new Database();
创建实例都要报错......
Database 没导进来.......

import java.util.*;是这句导进来吗?

盼望大家解决哈
谢谢

[解决办法]
JAVA中是你这样操作数据库的吗?
根本没有什么DataBase类
给你个样例
Class.forName( "com.mysql.jdbc.Driver ");
String dbName= "test ";
String userName= "root ";
String userPwd= "123456 ";
String url= "jdbc:mysql://localhost/ "+dbName+ "?user= "+userName+ "&password= "+userPwd;

conn=DriverManager.getConnection(url);

读书人网 >J2SE开发

热点推荐