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);