总结学生选课Dao类相应代码,对应数据库表的内容进行修改
来源:互联网 发布:淘宝上的彩妆正品店 铺 编辑:程序博客网 时间:2024/05/23 15:38
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;
}
}
}
0 0
- 总结学生选课Dao类相应代码,对应数据库表的内容进行修改
- 学生选课数据库 sql server代码
- 学生选课数据库设计
- 利用PO DAO 修改对应数据库数据
- 求学生选课系统代码~~~
- 学生选课,存代码自用
- SQL之学生选课数据库
- 学生选课系统数据库设计
- java swing实现的学生教师选课管理系统代码
- 数据库课程设计-----------学生选课管理系统的设计
- 链接MYSql数据库的学生选课管理系统
- 学生选课数据库(oracle 11g)的设计与管理
- 学生选课系统数据库的设计与实现
- 遇到的问题-----网上下载的项目修改代码无效,不能相应的生成相应的页面内容
- 数据库 简单查询 Sql Server 学生表 课程表 选课表
- Java EE 查询 将数据库中对应的表逐行转换成DAO实体类。
- vc++学生选课系统开发 sql语句操作数据库 修改课程名模块
- 关于学生选课的实现
- leetcode007 Reverse Integer
- A Bug's Life 并查集
- Construct Binary Tree from Inorder and Postorder Traversal
- linux下C语言UDP通信
- 策略模式的小例子
- 总结学生选课Dao类相应代码,对应数据库表的内容进行修改
- android 自定义RatingBar背景图片
- 黑马程序员---java基础---面向对象中的构造方法及static关键字,变量的问题
- WIN7用键盘控制鼠标
- JAVA基础学习(十七)--集合四 工具类Collections
- oracle之简null空值问题,用nvl(a,b)函数解决
- linuxC语言socket广播通信
- JDBC数据库连接的简单应用
- MySQL笔记