请大家帮我看看是哪里有问题,我刚接触JAVA不久,我是真没办法了。
package 企业人事管理系统;
import YGGZFA.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
/**
*
* @author xm
*/
public class YGGZFAManage {
public DefaultTableModel getEmpoyees() {
String sql = "select * from yuangong ";
//通过查询sql,从数据库里查询数据
ResultSetMetaData rsmd;
YGGZFA YG2 = new YGGZFA(); 这行老是说找不到YGGZFA()
Connection dbConn = this.getConnection();
Vector columnHeads = new Vector();
Vector rows = new Vector();
DefaultTableModel dtm=null; try {
Statement s = dbConn.createStatement();
java.sql.ResultSet rs = s.executeQuery(sql);
columnHeads.addElement("编号");
columnHeads.addElement("姓名");
columnHeads.addElement("性别");
columnHeads.addElement("部门");
columnHeads.addElement("基本工资");
columnHeads.addElement("级别");
columnHeads.addElement("总工资");
columnHeads.addElement("销售额"); while (rs.next()) {
Vector currentRow = new Vector();
currentRow.addElement(rs.getString("sid"));
currentRow.addElement(rs.getString("name"));
currentRow.addElement(rs.getString("sex"));
currentRow.addElement(rs.getString("bumen"));
currentRow.addElement(rs.getInt("gongzi"));
currentRow.addElement(rs.getString("jibie"));
currentRow.addElement(rs.getInt("zonggongzi"));
currentRow.addElement(rs.getInt("xiaoshou"));
rows.addElement(currentRow);
} s.close();
dbConn.close();
dtm = new DefaultTableModel(rows,columnHeads);
} catch (java.sql.SQLException sqle) {
sqle.printStackTrace();
} return dtm; }
public Connection getConnection() {
String driverName = "com.mysql.jdbc.Driver";
String dbURL = "jdbc:mysql://127.0.0.1:3306/yuangong";
String userName = "root";
String userPwd = "1234";
Connection dbConn = null; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
} catch (Exception e) {
e.printStackTrace();
}
return dbConn;
}}
从这里开始是YGGZFA
package YGGZFA;/**
*
* @author Administrator
*/
public class YGGZFA {
String sid;
String name;
String sex;
String bumen;
int gongzi;
String jibie;
int zonggongzi;
int xiaoshou;
public YGGZFA( String ygbh2,String xm2,String xb2,String bm2,int gz2,String jb2,int zgz2,int xs2)
{
this.sid = ygbh2;
this.name = xm2;
this.sex =xb2;
this.bumen =bm2;
this.gongzi =gz2;
this.jibie = jb2;
this.zonggongzi = zgz2;
this.xiaoshou=xs2;
}
public String getsid() {
return sid;
}
public void setsid(String ygbh2) {
this.sid = ygbh2;
}
public String getname() {
return name;
}
public void setname(String xm2) {
this.name = xm2;
}
public String getsex() {
return sex;
}
public void setsex(String xb2) {
this.sex = xb2;
}
public String getbumen() {
return bumen;
}
public void setbumen(String bm2) {
this.bumen = bm2;
}
public int getgongzi() {
return gongzi;
} public void setgongzi(int gz2) {
this.gongzi = gz2;
}
public String getjibie() {
return jibie;
}
public void setjibie(String jb2) {
this.jibie = jb2;
}
public int getzonggongzi() {
return zonggongzi;
} public void setzonggongzi(int zgz2) {
this.zonggongzi = zgz2;
}
public int getxiaoshou() {
return xiaoshou;
} public void setxiaoshou(int xs2) {
this.xiaoshou = xs2;
}
}
package 企业人事管理系统;
import YGGZFA.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
/**
*
* @author xm
*/
public class YGGZFAManage {
public DefaultTableModel getEmpoyees() {
String sql = "select * from yuangong ";
//通过查询sql,从数据库里查询数据
ResultSetMetaData rsmd;
YGGZFA YG2 = new YGGZFA(); 这行老是说找不到YGGZFA()
Connection dbConn = this.getConnection();
Vector columnHeads = new Vector();
Vector rows = new Vector();
DefaultTableModel dtm=null; try {
Statement s = dbConn.createStatement();
java.sql.ResultSet rs = s.executeQuery(sql);
columnHeads.addElement("编号");
columnHeads.addElement("姓名");
columnHeads.addElement("性别");
columnHeads.addElement("部门");
columnHeads.addElement("基本工资");
columnHeads.addElement("级别");
columnHeads.addElement("总工资");
columnHeads.addElement("销售额"); while (rs.next()) {
Vector currentRow = new Vector();
currentRow.addElement(rs.getString("sid"));
currentRow.addElement(rs.getString("name"));
currentRow.addElement(rs.getString("sex"));
currentRow.addElement(rs.getString("bumen"));
currentRow.addElement(rs.getInt("gongzi"));
currentRow.addElement(rs.getString("jibie"));
currentRow.addElement(rs.getInt("zonggongzi"));
currentRow.addElement(rs.getInt("xiaoshou"));
rows.addElement(currentRow);
} s.close();
dbConn.close();
dtm = new DefaultTableModel(rows,columnHeads);
} catch (java.sql.SQLException sqle) {
sqle.printStackTrace();
} return dtm; }
public Connection getConnection() {
String driverName = "com.mysql.jdbc.Driver";
String dbURL = "jdbc:mysql://127.0.0.1:3306/yuangong";
String userName = "root";
String userPwd = "1234";
Connection dbConn = null; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
} catch (Exception e) {
e.printStackTrace();
}
return dbConn;
}}
从这里开始是YGGZFA
package YGGZFA;/**
*
* @author Administrator
*/
public class YGGZFA {
String sid;
String name;
String sex;
String bumen;
int gongzi;
String jibie;
int zonggongzi;
int xiaoshou;
public YGGZFA( String ygbh2,String xm2,String xb2,String bm2,int gz2,String jb2,int zgz2,int xs2)
{
this.sid = ygbh2;
this.name = xm2;
this.sex =xb2;
this.bumen =bm2;
this.gongzi =gz2;
this.jibie = jb2;
this.zonggongzi = zgz2;
this.xiaoshou=xs2;
}
public String getsid() {
return sid;
}
public void setsid(String ygbh2) {
this.sid = ygbh2;
}
public String getname() {
return name;
}
public void setname(String xm2) {
this.name = xm2;
}
public String getsex() {
return sex;
}
public void setsex(String xb2) {
this.sex = xb2;
}
public String getbumen() {
return bumen;
}
public void setbumen(String bm2) {
this.bumen = bm2;
}
public int getgongzi() {
return gongzi;
} public void setgongzi(int gz2) {
this.gongzi = gz2;
}
public String getjibie() {
return jibie;
}
public void setjibie(String jb2) {
this.jibie = jb2;
}
public int getzonggongzi() {
return zonggongzi;
} public void setzonggongzi(int zgz2) {
this.zonggongzi = zgz2;
}
public int getxiaoshou() {
return xiaoshou;
} public void setxiaoshou(int xs2) {
this.xiaoshou = xs2;
}
}
解决方案 »
- 为什么我的程序总是抛出MalforedURLException异常?
- 一个初学者提出的简单问题,希望各位师父能够帮帮我,谢谢您了(一天一点)
- static_cast<int>是什么东西
- 求Java thread programming(java线程编程)这本书
- 为什么我读取txt文件是乱码,文件是按照unicode存的,代码如下:
- 求助java?
- 哪位大侠能不能给小弟贴一个完整的加密、解密算法的类代码(最好附上说明),感激不尽!!
- 有关ORACLE的JDBC连接的问题?
- 如何简单的得到某天的日期?
- 今天把JB的JDK升级到了1。4。0,结果原来程序中的中文都显示成了方框,怎么解决?经验高手指点了。。。
- 急问:java数据库操作的问题
- 正则表达式的疑惑
中文包名?public YGGZFA( String ygbh2,String xm2,String xb2,String bm2,int gz2,String jb2,int zgz2,int xs2)
{
你配置了构造函数 就不能用默认的构造函数了
在YGGZFA 加上
public YGGZFA()
{}