小问题,大家请帮帮忙~~谢谢~~有分送的~~

[feng80216]

小弟现在不太方便,只能在网吧上网，那个大侠给把这段代码

编译 成class文件


package com.rmyy;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.naming.*;
import java.util.*;

public class Specialist{
//
private final static String SQL_FIND_BY_ID="SELECT * FROM Specialist WHERE ID=?;";
//
private final static String SQL_FIND_ALL_TYPE="SELECT * FROM ExpertType";
//
private final static String SQL_FIND_ALL="SELECT * FROM Specialist ORDER BY Id DESC";
//
private final static String SQL_INSERT="INSERT INTO Specialist (sName,Specialty,Role,Resume,Type,ImgName)VALUES (?,?,?,?,?,?)";
//
private final static String SQL_UPDATE="UPDATE Specialist SET sName=?,Specialty=?,Role=?,Resume=?,Type=?,ImgName=? WHERE Id=? ";
//
private final static String SQL_DELETE="DELETE FROM Specialist WHERE Id=?";
//
private final static String SQL_FIND_WORKTIME="SELECT WorkTime FROM Specialist WHERE Id=?";
//
private final static String SQL_UPDATE_DUTY="UPDATE Specialist SET WorkTime=? WHERE Id=? ";
//
private final static String SQL_FIND_NAME_BY_ID="SELECT sName FROM Specialist WHERE Id=?";
//
private final static String SQL_FIND_BY_WORKTIME="SELECT Id,sName,Role,WorkTime,Specialty FROM Specialist WHERE WorkTime LIKE ?";
/**
*
*
**/
public Specialist(){
}
public List FindById(int Id){
ResultSet rs=null;
List list = new ArrayList();
MSsql mssql = new MSsql(SQL_FIND_BY_ID);
try {
mssql.setInt(1, Id);
rs= mssql.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
while ( rs.next() ){
Map map = new HashMap();
for ( int i = 1; i <= rsmd.getColumnCount(); i++ ){
map.put(rsmd.getColumnName(i), rs.getObject(i));
}
list.add(map);
}
} catch (Exception e) {
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
return list;
}
public List FindAll(){
ResultSet rs=null;
List list = new ArrayList();
MSsql mssql = new MSsql();
try {
rs= mssql.executeQuery(SQL_FIND_ALL);
ResultSetMetaData rsmd = rs.getMetaData();
while ( rs.next() ){
Map map = new HashMap();
for ( int i = 1; i <= rsmd.getColumnCount(); i++ ){
map.put(rsmd.getColumnName(i), rs.getObject(i));
}
list.add(map);
}
} catch (Exception e) {
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
return list;

}
/*
*
*
**/
public List FindAllType(){
ResultSet rs=null;
List list = new ArrayList();
MSsql mssql = new MSsql(SQL_FIND_ALL_TYPE);
try {
rs= mssql.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
while ( rs.next() ){
Map map = new HashMap();
for ( int i = 1; i <= rsmd.getColumnCount(); i++ ){
map.put(rsmd.getColumnName(i), rs.getObject(i));
}
list.add(map);
}
} catch (Exception e) {
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
return list;
}
/*
*
*
**/
public List FindByWorkTime(String workTime){
ResultSet rs=null;
List list = new ArrayList();
if (workTime==null||workTime=="")
return list;
MSsql mssql = new MSsql(SQL_FIND_BY_WORKTIME);
try {
mssql.setString(1,"%"+workTime+"%");
rs= mssql.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
while ( rs.next() ){
Map map = new HashMap();
for ( int i = 1; i <= rsmd.getColumnCount(); i++ ){
map.put(rsmd.getColumnName(i), rs.getObject(i));
}
list.add(map);
}
} catch (Exception e) {
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
return list;
}
/*
*
*
**/
public String FindDuty(int Id){
ResultSet rs=null;
String strResult=null;
MSsql mssql = new MSsql(SQL_FIND_WORKTIME);
try {
mssql.setInt(1, Id);
rs= mssql.executeQuery();
if ( rs.next() ){
strResult=rs.getString(1);
}
} catch (Exception e) {
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
return strResult;
}
/**
*
*
**/
public String FindName(int Id){
ResultSet rs=null;
String strResult=null;
MSsql mssql = new MSsql(SQL_FIND_NAME_BY_ID);
try {
mssql.setInt(1, Id);
rs= mssql.executeQuery();
if ( rs.next() ){
strResult=rs.getString(1);
}
} catch (Exception e) {
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
return strResult;
}
/*
*
*
**/
public void UpdateDuty(int Id,String WorkTime){
if (Id==0)
return ;
MSsql mssql = new MSsql(SQL_UPDATE_DUTY);
try {
mssql.setString(1,WorkTime);
mssql.setInt(2,Id);
mssql.executeUpdate();
}catch(Exception e){
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
}
public void Insert(String sName,String Specialty,String Role,String Resume,String Type,String ImgName){
if (sName==null||sName.length()<=0)
return ;
MSsql mssql = new MSsql(SQL_INSERT);
try {
mssql.setString(1, sName);
mssql.setString(2, Specialty);
mssql.setString(3, Role);
mssql.setString(4, Resume);
mssql.setString(5, Type);
mssql.setString(6,ImgName);
mssql.executeUpdate();
}catch(Exception e){
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
}
public void Update(int Id,String sName,String Specialty,String Role,String Resume,String Type,String ImgName){
if (Id==0)
return ;
MSsql mssql = new MSsql(SQL_UPDATE);
try {
mssql.setString(1, sName);
mssql.setString(2, Specialty);
mssql.setString(3, Role);
mssql.setString(4, Resume);
mssql.setString(5, Type);
mssql.setString(6,ImgName);
mssql.setInt(7,Id);
mssql.executeUpdate();
}catch(Exception e){
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
}
public void Delete(int Id){
if (Id==0)
return ;
MSsql mssql = new MSsql(SQL_DELETE);
try {
mssql.setInt(1, Id);
mssql.executeUpdate();
}catch(Exception e){
System.err.println(e);
}
finally {
mssql.close();
mssql = null;
}
}
public List PageingList(List list ,int pageNum,int showCount){
List temList= new ArrayList();;
if (pageNum<1){
pageNum=1;
}
if (showCount<1){
showCount=1;
}
if (pageNum>(list.size()/showCount)){
pageNum=(list.size()/showCount+1);
}
for(int i =((pageNum-1)*showCount);i<(pageNum*showCount);i++ ){
if (i<list.size()){
temList.add(list.get(i));
}
}
return temList;
}

}

[haoco]

up

[feng80216]

mssql.java

package com.rmyy;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.naming.*;

public class MSsql{

private Connection conn=null;
private Statement stmt=null;
private PreparedStatement prepstmt=null;
/**
*
*
*
**/
public MSsql(){
try{
getDataSource();
//String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rmyy";
//String user="sa";
//String password="sa";
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement();

}catch(Exception e){
System.err.println("MSsql init error:"+e);

}
}
private void getDataSource() {
try {
Context ctx = new InitialContext();
if (ctx == null)
throw new Exception("Boom - No Context");

DataSource ds =
(DataSource) ctx.lookup("java:comp/env/jdbc/userDB");
if (ds != null)
conn = ds.getConnection();

} catch (Exception e) {
System.err.println("getDataSource() error: " + e);
}
}
/**
*
*
*
**/
public MSsql(String sql){
try{
//String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rmyy";
//String user="sa";
//String password="sa";
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//conn=DriverManager.getConnection(url,user,password);
getDataSource();
prepareStatement(sql);

}catch(Exception e){
System.err.println("MSsql init error:"+e);

}

}
public Connection getConnection(){
return conn;
}
public void prepareStatement(String sql) throws SQLException{
prepstmt=conn.prepareStatement(sql);
}
public void setString(int index, String value) throws SQLException {
prepstmt.setString(index, value);
}
public void setInt(int index, int value) throws SQLException {
prepstmt.setInt(index, value);
}
public void setBoolean(int index, boolean value) throws SQLException {
prepstmt.setBoolean(index, value);
}
public void setDate(int index, Date value) throws SQLException {
prepstmt.setDate(index, value);
}
public void setLong(int index, long value) throws SQLException {
prepstmt.setLong(index, value);
}
public void setFloat(int index, float value) throws SQLException {
prepstmt.setFloat(index, value);
}
public void setBinaryStream(int index, InputStream in, int length) throws SQLException {
prepstmt.setBinaryStream(index, in, length);
}
public void clearParameters() throws SQLException {
prepstmt.clearParameters();
}
public PreparedStatement getPreparedStatement() {
return prepstmt;
}
public Statement getStatement() {
return stmt;
}
public ResultSet executeQuery(String sql) throws SQLException {
if (stmt != null){
return stmt.executeQuery(sql);
} else
return null;
}

/**
*
*
*
**/
public ResultSet executeQuery() throws SQLException {
if (prepstmt != null) {
return prepstmt.executeQuery();
} else
return null;
}

/**
*
*
*
**/
public void executeUpdate(String sql) throws SQLException {
if (stmt != null)
stmt.executeUpdate(sql);
}
/**
*
*
*
**/
public int executeUpdate() throws SQLException {
int i=0;
if (prepstmt != null)
i=prepstmt.executeUpdate();
return i;
}

/**
*
*
*
**/
public void close() {
try {
if (stmt != null) {
stmt.close();
stmt = null;
}
if (prepstmt != null) {
prepstmt.close();
prepstmt = null;
}
conn.close();
conn = null;
} catch (Exception e) {
System.err.println("MSsql close error: " + e);
}
}
}

[feng80216]

编译完成后,发到 [e-mail]

谢谢~~

[feng80216]

那位大虾,能帮一下~~

急啊~~

[minisun2000]

编译文件要上网吗?
别说你没电脑~~

[feng80216]

条件所限~~

谢谢~~帮编译一下了~~~~

[feng80216]

谢谢~~~

[feng80216]

晕~~这么简单也没有人帮偶一下啊~~

[kathryn530]

编译有21个错

[feng80216]

不是吧~~~

[feng80216]

在试试好吗??谢谢啦~~~

[feng80216]

55555~~~~

[zhouqi724]

已经发出

[feng80216]

谢谢猛男,分以放出请查收~~~