import java.sql.Connection;
import java.sql.DriverManager;
import static java.sql.DriverManager.println;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Vector;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author HP-Developer
*/
public class Dao {
protected static String dbClassName= "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
protected static String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=StudentDB"; //连接服务器和数据库电子词典
protected static String dbUser = "sa"; //默认用户名
protected static String dbPwd = "123456";//密码
protected static String second=null;
protected static Connection conn=null;
private Dao(){
try {
if(conn==null){
Class.forName(dbClassName);
conn=DriverManager.getConnection(dbURL, dbUser, dbPwd);
}else
return;
}catch(Exception ee){
ee.printStackTrace();
}
}
private static ResultSet executeQuery(String sql){
try{
if(conn==null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
}catch(SQLException e){
e.printStackTrace();
return null;
}finally{
}
}private static int executeUpdate(String sql){
try{
if(conn==null)
new Dao();
return conn.createStatement().executeUpdate(sql);
}catch (SQLException e){
System.out.print(e.getMessage());
return -1;
}finally{
}
} public static boolean CheckLoginInf(LoginInf li){
String sql="select * from PwdDB where login='"+li.getLogin_name()+"' and password='"+li.getLogin_pwd()+"'";
System.out.print(li.getLogin_name());
System.out.print(li.getLogin_pwd());
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
} public static boolean AddStuInf(StudentInf si){
String sql="insert into StuDB values('"+si.no+"','"+si.name+"','"+si.age+"','"+si.banji+"')";
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
}
/*
修改学生信息
*/
public static boolean UpdateStuInf(StudentInf si,StudentInf oldsi){
String sql = "update StuDB set Sno='"+si.getNo()+
"',Sname='"+si.getName()+"',Sage='"+si.getAge()+"',Sbanji='"+
si.getBanji()+"' where Sno='"+oldsi.getNo()+
"' and Sname='"+oldsi.getName()+"' and Sage='"+oldsi.getAge()+"' and Sbanji='"+
oldsi.getBanji()+"'";
System.out.print(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
删除学生信息
*/
public static boolean DeleteStuInf(StudentInf si){
String sql = "delete from StuDB where Sno='"+si.getNo()+
"' and Sname='"+si.getName()+"' and Sage='"+si.getAge()+"' and Sbanji='"+
si.getBanji()+"'";
System.out.print("name是"+si.getName());
System.out.println(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
获取学生信息
*/
public static List GetStudentInf(){
List list = new ArrayList();
String sql = "select Sno,Sname,Sage,Sbanji from StuDB";
try{
ResultSet rs = executeQuery(sql);
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
while (rs.next()) {
Vector map = new Vector();
for (int i = 1; i <= columnCount; i++) {
map.add( rs.getObject(i).toString());
}
list.add(map);
}
return list;
}catch(Exception e){
e.printStackTrace();
return null;
}
} public static boolean AddLesson(ClassInf si){
String sql="insert into Lessson values('"+si.lesson+"','"+si.teacher+"','"+si.credit+"','"+si.hour+"')";
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
}
/*
修改课程信息
*/
public static boolean UpdateLesson(ClassInf si,ClassInf oldsi){
String sql = "update Lesson set Slesson='"+si.getLesson()+
"',Steacher='"+si.getTeacher()+"',Scredit='"+si.getCredit()+"',Shour='"+
si.getHour()+"' where Slesson='"+oldsi.getLesson()+
"' and Steacher='"+oldsi.getTeacher()+"' and Scredit='"+oldsi.getCredit()+"' and Shour='"+
oldsi.getHour()+"'";
System.out.print(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
删除课程信息
*/
public static boolean DeleteLesson(ClassInf si){
String sql = "delete from Lesson where Slesson='"+si.getLesson()+
"' and Steather='"+si.getTeacher()+"' and Scredit='"+si.getCredit()+"' and Shour='"+
si.getHour()+"'";
System.out.println(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
获取学生信息
*/
public static List GetLesson(){
List list = new ArrayList();
String sql = "select Slesson,Steacher,Scredit,Shour from Lesson";
try{
ResultSet rs = executeQuery(sql);
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
while (rs.next()) {
Vector map = new Vector();
for (int i = 1; i <= columnCount; i++) {
map.add( rs.getObject(i).toString());
}
list.add(map);
}
return list;
}catch(Exception e){
e.printStackTrace();
return null;
}
} public static boolean AddLesson(Class2Inf si){
String sql="insert into Lessson2 values('"+si.lesson+"','"+si.teacher+"','"+si.credit+"','"+si.hour+"')";
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
}
public static List GetLesson2(){
List list = new ArrayList();
String sql = "select Slesson,Steacher,Scredit,Shour from Lesson2";
try{
ResultSet rs = executeQuery(sql);
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
while (rs.next()) {
Vector map = new Vector();
for (int i = 1; i <= columnCount; i++) {
map.add( rs.getObject(i).toString());
}
list.add(map);
}
return list;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
}
import java.sql.DriverManager;
import static java.sql.DriverManager.println;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Vector;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author HP-Developer
*/
public class Dao {
protected static String dbClassName= "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
protected static String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=StudentDB"; //连接服务器和数据库电子词典
protected static String dbUser = "sa"; //默认用户名
protected static String dbPwd = "123456";//密码
protected static String second=null;
protected static Connection conn=null;
private Dao(){
try {
if(conn==null){
Class.forName(dbClassName);
conn=DriverManager.getConnection(dbURL, dbUser, dbPwd);
}else
return;
}catch(Exception ee){
ee.printStackTrace();
}
}
private static ResultSet executeQuery(String sql){
try{
if(conn==null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
}catch(SQLException e){
e.printStackTrace();
return null;
}finally{
}
}private static int executeUpdate(String sql){
try{
if(conn==null)
new Dao();
return conn.createStatement().executeUpdate(sql);
}catch (SQLException e){
System.out.print(e.getMessage());
return -1;
}finally{
}
} public static boolean CheckLoginInf(LoginInf li){
String sql="select * from PwdDB where login='"+li.getLogin_name()+"' and password='"+li.getLogin_pwd()+"'";
System.out.print(li.getLogin_name());
System.out.print(li.getLogin_pwd());
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
} public static boolean AddStuInf(StudentInf si){
String sql="insert into StuDB values('"+si.no+"','"+si.name+"','"+si.age+"','"+si.banji+"')";
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
}
/*
修改学生信息
*/
public static boolean UpdateStuInf(StudentInf si,StudentInf oldsi){
String sql = "update StuDB set Sno='"+si.getNo()+
"',Sname='"+si.getName()+"',Sage='"+si.getAge()+"',Sbanji='"+
si.getBanji()+"' where Sno='"+oldsi.getNo()+
"' and Sname='"+oldsi.getName()+"' and Sage='"+oldsi.getAge()+"' and Sbanji='"+
oldsi.getBanji()+"'";
System.out.print(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
删除学生信息
*/
public static boolean DeleteStuInf(StudentInf si){
String sql = "delete from StuDB where Sno='"+si.getNo()+
"' and Sname='"+si.getName()+"' and Sage='"+si.getAge()+"' and Sbanji='"+
si.getBanji()+"'";
System.out.print("name是"+si.getName());
System.out.println(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
获取学生信息
*/
public static List GetStudentInf(){
List list = new ArrayList();
String sql = "select Sno,Sname,Sage,Sbanji from StuDB";
try{
ResultSet rs = executeQuery(sql);
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
while (rs.next()) {
Vector map = new Vector();
for (int i = 1; i <= columnCount; i++) {
map.add( rs.getObject(i).toString());
}
list.add(map);
}
return list;
}catch(Exception e){
e.printStackTrace();
return null;
}
} public static boolean AddLesson(ClassInf si){
String sql="insert into Lessson values('"+si.lesson+"','"+si.teacher+"','"+si.credit+"','"+si.hour+"')";
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
}
/*
修改课程信息
*/
public static boolean UpdateLesson(ClassInf si,ClassInf oldsi){
String sql = "update Lesson set Slesson='"+si.getLesson()+
"',Steacher='"+si.getTeacher()+"',Scredit='"+si.getCredit()+"',Shour='"+
si.getHour()+"' where Slesson='"+oldsi.getLesson()+
"' and Steacher='"+oldsi.getTeacher()+"' and Scredit='"+oldsi.getCredit()+"' and Shour='"+
oldsi.getHour()+"'";
System.out.print(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
删除课程信息
*/
public static boolean DeleteLesson(ClassInf si){
String sql = "delete from Lesson where Slesson='"+si.getLesson()+
"' and Steather='"+si.getTeacher()+"' and Scredit='"+si.getCredit()+"' and Shour='"+
si.getHour()+"'";
System.out.println(sql);
if(executeUpdate(sql)!=-1)
return true;
else
return false;
}
/*
获取学生信息
*/
public static List GetLesson(){
List list = new ArrayList();
String sql = "select Slesson,Steacher,Scredit,Shour from Lesson";
try{
ResultSet rs = executeQuery(sql);
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
while (rs.next()) {
Vector map = new Vector();
for (int i = 1; i <= columnCount; i++) {
map.add( rs.getObject(i).toString());
}
list.add(map);
}
return list;
}catch(Exception e){
e.printStackTrace();
return null;
}
} public static boolean AddLesson(Class2Inf si){
String sql="insert into Lessson2 values('"+si.lesson+"','"+si.teacher+"','"+si.credit+"','"+si.hour+"')";
ResultSet rs=executeQuery(sql);
try{
if(rs.next()){
return true;
}else
return false;
}catch(Exception e){
e.printStackTrace();
return false;
}
}
public static List GetLesson2(){
List list = new ArrayList();
String sql = "select Slesson,Steacher,Scredit,Shour from Lesson2";
try{
ResultSet rs = executeQuery(sql);
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
while (rs.next()) {
Vector map = new Vector();
for (int i = 1; i <= columnCount; i++) {
map.add( rs.getObject(i).toString());
}
list.add(map);
}
return list;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
}