1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
| package com.joan.search;
import java.io.IOException;
import java.io.InputStream;
import java.sql.DriverManager;
import javax.jws.WebService;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;
@WebService()
public class Book {
/**
*
* @author Administrator
*/
@WebService(serviceName = "WebServiceBook")
public class WebServiceBook {
Connection conn;
Statement statement;
ResultSet res;
public void connect() {
Properties properties = new Properties();
try {
InputStream inputstream = Book.class.getResourceAsStream("/config.properties");
properties.load(inputstream);
inputstream.close();
} catch (IOException e1) {
e1.printStackTrace();
}
try {
Class.forName("com.mysql.jdbc.Driver");
String url = properties.getProperty("url");
try {
conn = DriverManager.getConnection(url, properties.getProperty("user"), properties.getProperty("password"));
} catch (SQLException ex) {
Logger.getLogger(WebServiceBook.class.getName()).log(Level.SEVERE, null, ex);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(WebServiceBook.class.getName()).log(Level.SEVERE, null, ex);
}
catch(Exception e){
throw new RuntimeException(e);
}
}
/**
* This is a sample web service operation
*/
@WebMethod(operationName = "SearchBook")
public List<String> book(@WebParam(name = "isbn") String isbn) {
try{
List<String> book = new ArrayList<String>(0);
try {
connect();
statement = conn.createStatement();
res = statement.executeQuery("select * from book where isbn ='"+isbn+"'");
while(res.next())
book.add(res.getString(1)+" / "+res.getString(2)+" / "+res.getString(3)+" / "+res.getString(4)+" / "+res.getString(5));
statement.close();
res.close();
} catch(SQLException ex) {
Logger.getLogger(WebServiceBook.class.getName()).log(Level.SEVERE, null, ex);
}
return book;
}catch(Exception e){
throw new RuntimeException(e);
}
}
}
} |
Partager