BaseDao.java
package com.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.sun.jndi.url.corbaname.corbanameURLContextFactory;
public class BaseDao {
private static final String driver = "com.mysql.jdbc.Driver";
private static final String url = "jdbc:mysql:///admin?characterEncoding=utf-8";
private static final String user = "root";
private static final String password = "root";
static{
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConn(){
Connection conn = null;
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn,PreparedStatement ps,ResultSet rs){
try {
if(null != rs)
rs.close();
if(null != ps)
ps.close();
if(null != conn)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Admin.java
package com.bean;
public class Admin {
private Integer adminId;
private String adminName;
private String adminPwd;
public Integer getAdminId() {
return adminId;
}
public void setAdminId(Integer adminId) {
this.adminId = adminId;
}
public String getAdminName() {
return adminName;
}
public void setAdminName(String adminName) {
this.adminName = adminName;
}
public String getAdminPwd() {
return adminPwd;
}
public void setAdminPwd(String adminPwd) {
this.adminPwd = adminPwd;
}
@Override
public String toString() {
return "Admin [adminId=" + adminId + ", adminname=" + adminName
+ ", adminPwd=" + adminPwd + "]";
}
public Admin(Integer adminId, String adminName, String adminPwd) {
super();
this.adminId = adminId;
this.adminName = adminName;
this.adminPwd = adminPwd;
}
public Admin() {
super();
}
}
News.java
package com.bean;
public class News {
private Integer newsId;
private String newsTitle;
private String newsContent;
private String newsImage;
private String newsCreateTime;
private String newsModifyTime;
public Integer getNewsId() {
return newsId;
}
public void setNewsId(Integer newsId) {
this.newsId = newsId;
}
public String getNewsTitle() {
return newsTitle;
}
public void setNewsTitle(String newsTitle) {
this.newsTitle = newsTitle;
}
public String getNewsContent() {
return newsContent;
}
public void setNewsContent(String newsContent) {
this.newsContent = newsContent;
}
public String getNewsImage() {
return newsImage;
}
public void setNewsImage(String newsImage) {
this.newsImage = newsImage;
}
public String getNewsCreateTime() {
return newsCreateTime;
}
public void setNewsCreateTime(String newsCreateTime) {
this.newsCreateTime = newsCreateTime;
}
public String getNewsModifyTime() {
return newsModifyTime;
}
public void setNewsModifyTime(String newsModifyTime) {
this.newsModifyTime = newsModifyTime;
}
@Override
public String toString() {
return "News [newsId=" + newsId + ", newsTitle=" + newsTitle
+ ", newsContent=" + newsContent + ", newsImage=" + newsImage
+ ", newsCreateTime=" + newsCreateTime + ", newsModifyTime="
+ newsModifyTime + "]";
}
public News(Integer newsId, String newsTitle, String newsContent,
String newsImage, String newsCreateTime, String newsModifyTime) {
super();
this.newsId = newsId;
this.newsTitle = newsTitle;
this.newsContent = newsContent;
this.newsImage = newsImage;
this.newsCreateTime = newsCreateTime;
this.newsModifyTime = newsModifyTime;
}
public News() {
super();
}
}
IAdminDao.java
package com.dao;
import com.bean.Admin;
public interface IAdminDao {
Admin login(Admin admin);
int insert(Admin admin);
}
INewsDao.java
package com.dao;
import java.util.List;
import com.bean.News;
public interface IN