后台已经写好
package bean;
public class Book {
private int id;
private String Code;
private String BookName;
private String BookPrice;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getCode() {
return Code;
}
public void setCode(String code) {
Code = code;
}
public String getBookName() {
return BookName;
}
public void setBookName(String bookName) {
BookName = bookName;
}
public String getBookPrice() {
return BookPrice;
}
public void setBookPrice(String bookPrice) {
BookPrice = bookPrice;
}
}
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import bean.Book;
public class AllBook {
public static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=demodb";
public static final String serName="sa";
public static final String Pwd="888888";
protected static Connection conn=null;
protected static PreparedStatement pst=null;
protected static ResultSet rs=null;
public List fillbook(){
//List menuList=new ArrayList();
List<Book> list1=new ArrayList<Book>();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection(URL,serName,Pwd); //得到连接
Statement st=con.createStatement();
String sql="select * from book"; //查询数据SQL语句s
ResultSet rs=st.executeQuery(sql); //获取结果集
while (rs.next()){
Book book=new Book();
book.setCode(rs.getString("Code"));
book.setBookName(rs.getString("Name"));
book.setBookPrice(rs.getString("Price"));
list1.add(book);
}
con.close(); //关闭连接
}
catch (Exception ex) {
ex.printStackTrace(); //输出出错信息
}
return list1;
}
}