|
|
Dette indlæg blev sidst redigeret af Delver_Si den 20-11-2014 kl. 21:21
[mw_shl_code=sql,true]brug master
Gå
hvis eksisterer (vælg * fra sys.databases, hvor navn = 'skole')
Drop database-skole
Gå
Opret databaseskole
Gå
Brug skolen
Gå
Opret tabel, elev
(
stu_id varchar(10) primærnøgle ,-- tal
stu_name varchar(20) ikke null,-- navn
stu_addr Varchar (100) ,-- adresse
stu_spec Varchar (50) ,-- professionel
stu_dorm Varchar (50) — Sovesal
)
Gå
indsæt i elevværdier ('100001', 'Zhang San', 'Wuhan Xu Dong', 'Informationsteknik', '101')
indsæt i elevværdier ('100002', 'Li Si', 'Wuhan Xu Dong', 'Informationsteknik', '102')
Vælg * fra elev
--slet fra elev, hvor stu_id = '100001'
--opdatering elevsæt stu_name = 'Li Si', stu_addr = 'Zhang San', stu_spec= 'Softwaretest', stu_dorm = '1001' hvor stu_id = '100001'[/mw_shl_code]
[mw_shl_code=java,true]pakke online.school.test;
import java.util.ArrayList;
import java.util.List; importere online.skole.domæne.Student;
import online.school.service.StudentService;
offentlig klasse StudentTest {
public static void main(String[] args) {
ny StudentTest().getAllStudent();
}
public int addStudent() {
Studerende studerende = ny studerende ("3","Wang Wu","Xiaogan","Softwaretest","103");
returner ny StudentService().addStudent(student);
}
public int delStudent() {
StrengstId="3";
returner ny StudentService().delStudent(stuId);
}
public void findStudent() {
StrengstId="3";
Student student =new StudentService().findStudent(stuId);
System.out.println(student.toString());
}
offentlig liste<Student> getAllStudent() {
ArrayList al = (ArrayList) ny StudentService().getAllStudent();
for(int i =0; i<al.size(); i++){
Objekt[] obj =(Objekt[]) al.get(i);
for(int j=0; j<5; j++){
System.out.print(obj[j] + " ");
}
System.out.println();
}
Returner Al;
}
offentlig int updateStudent() {
Studerende = ny studerende ("3", "Wang Wu", "Yingcheng", "Civilingeniør", "103");
ny StudentService().updateStudent(student);
return 0;
}
}
[/mw_shl_code]
[mw_shl_code=java,true]pakke online.school.domain;
offentlig klasse Studerende {
privat String stu_id; Antal
privat String stu_name; Navn
privat String stu_addr; - Adresse
privat String stu_spec; Professionel
menig String stu_dorm; Sovesal
public String getStu_id() {
vend tilbage stu_id;
}
public void setStu_id(String stuId) {
stu_id = dum;
}
public String getStu_name() {
vend tilbage stu_name;
}
public void setStu_name(String stuName) {
stu_name = stuName;
}
public Streng getStu_addr() {
vend tilbage stu_addr;
}
public void setStu_addr(String stuAddr) {
stu_addr = stuAddr;
}
public String getStu_spec() {
vend tilbage stu_spec;
}
public void setStu_spec(String stuSpec) {
stu_spec = stuSpec;
}
public Streng getStu_dorm() {
vend tilbage stu_dorm;
}
public void setStu_dorm(String stuDorm) {
stu_dorm = stuDorm;
}
public Student() {
super();
}
offentlig studerende (String stuId, String stuName, String stuAddr,
Streng stuSpec, Streng stuDorm) {
super();
stu_id = dum;
stu_name = stuName;
stu_addr = stuAddr;
stu_spec = stuSpec;
stu_dorm = stuDorm;
}
@Override
public String toString() {
returner "Student [stu_addr=" + stu_addr + ", stu_dorm=" + stu_dorm
+ ", stu_id=" + stu_id + ", stu_name=" + stu_name
+ ", stu_spec=" + stu_spec + "]";
}
}
[/mw_shl_code]
[mw_shl_code=java,true]pakke online.school.service;
import java.util.List;
import online.school.dao.StudentDao;
importere online.skole.domæne.Student;
importere online.school.utils.SqlHelp;
public class StudentService implementerer IStudentService{
@Override
offentlig int addStudent(Student student) {
Streng sql = "indsæt i studentværdier(?,?,?,?,?)";
return new StudentDao().addStudent(sql,student.getStu_id(),student.getStu_name(),student.getStu_addr(),student.getStu_spec(),student.getStu_dorm());
}
@Override
public int delStudent(String stuId) {
Streng sql = "slet fra elev, hvor stu_id = ?";
return new StudentDao().delStudent(sql, stuId);
}
@Override
public Student findStudent(String stuId) {
Streng sql = "vælg * fra elev, hvor stu_id = ?";
returner ny StudentDao().findStudent(sql, stuId);
}
@Override
offentlig liste<Student> getAllStudent() {
String sql = "vælg * fra student";
returner ny StudentDao().getAllStudent(sql);
}
@Override
offentlig int updateStudent(Student student) {
Streng sql = "update student set stu_name = ?,stu_addr = ?, stu_spec= ?,stu_dorm = ? hvor stu_id = ?";
return new StudentDao().updateStudent(sql, student.getStu_name(),student.getStu_addr(),student.getStu_spec(),student.getStu_dorm(),student.getStu_id());
}
}
[/mw_shl_code] [mw_shl_code=java,true]pakke online.school.dao;
import java.util.ArrayList;
import java.util.List;
importere online.skole.domæne.Student;
importere online.school.utils.SqlHelp;
public class StudentDao implements IStudentDao{
@Override
offentlig int addStudent (String sql, String... args) {
returner ny SqlHelp().executeUpdate(sql,args);
}
@Override
public int delStudent (String sql, string... args) {
returner ny SqlHelp().executeUpdate(sql,args);
}
@Override
offentlig Student findStudent (String sql, String... args) {
ArrayList al = ny SqlHelp().executeQuery(sql, args);
Objekt[] obj =(Objekt[]) al.get(0);
Studerende elev = ny elev();
student.setStu_id((Streng) obj[0]);
student.setStu_name((Streng) obj[1]);
student.setStu_addr((Streng) obj[2]);
student.setStu_spec((Streng) obj[3]);
student.setStu_dorm((Streng) obj[4]);
tilbagevendende studerende;
}
@Override
public List<Student> getAllStudent(String sql) {
ArrayList al = ny SqlHelp().executeQuery(sql);
Returner Al;
}
@Override
offentlig int updateStudent (String sql, string... args) {
returner ny SqlHelp().executeUpdate(sql, args);
}
}
[/mw_shl_code]
|
Tidligere:For nylig laver jeg et online boghandelsprojekt, som er en registreringsfunktion, der er blevet udført de sidste par dageNæste:C#-versionen af studenterledelsessystemet
|
Udlejer|
Opslået på 20/11/2014 21.20.55
|
Opslået på 20/11/2014 21.13.20
|
Opslået på 20/11/2014 20.43.50
