孙连伟 java_java(jsp)简单实现数据库学生信息的增删改查案例

1：创建学生类，创建主函数进行测试java

package cn.edu.hpu.stu;

import java.util.Scanner;

import cn.edu.hpu.jdbclink.*;

/**

*

* @author Programer Guo

* 提供学生实体的javabean类

*/

public class Student {

private int id;

private String name;

private String myclass;

private double score;

private String email;

private int age;

public Student(){

}

public String getname() {

// TODO Auto-generated method stub

return this.name;

}

public String getmyclass() {

// TODO Auto-generated method stub

return this.myclass;

}

public double getScore() {

// TODO Auto-generated method stub

return this.score;

}

public int getage() {

// TODO Auto-generated method stub

return this.age;

}

public String getemail() {

// TODO Auto-generated method stub

return this.email;

}

public void setname(String string) {

// TODO Auto-generated method stub

this.name=string;

}

public void setmycalss(String string) {

// TODO Auto-generated method stub

this.myclass=string;

}

public void setscore(double d) {

// TODO Auto-generated method stub

this.score=d;

}

public void setemail(String string){

this.email=string;

}

public void setage(int d){

this.age=d;

}

public static void main(String[] args){

System.out.println("请选择：");

System.out.println("1:添加");

System.out.println("2:删除");

System.out.println("3:修改");

System.out.println("4:查询");

System.out.println("0:结束");

Scanner sc = new Scanner(System.in);

while(true){

int a = sc.nextInt();

if(a==1){

Student stu = new Student();

String name = null;

int age = 0;

String myclass = null;

double score = 0.0;

String email = null;

System.out.println("请输入信息：");

System.out.println("姓名：");

name = sc.next();

stu.setname(name);

System.out.println("年龄：");

age = sc.nextInt();

stu.setage(age);

System.out.println("班级：");

myclass = sc.next();

stu.setmycalss(myclass);

System.out.println("成绩：");

score = sc.nextDouble();

stu.setscore(score);

System.out.println("email:");

email = sc.next();

stu.setemail(email);

if(new Doinsert().addStudent(stu)){

System.out.println("成功");

}else{

System.out.println("失败");

}

}else if(a==2){

System.out.println("请输入删除姓名：");

String name = sc.next();

if(new Dodelete().delete(name)){

System.out.println("成功");

}else{

System.out.println("失败");

}

}else if(a==3){

System.out.println("请输入修改人姓名：(仅容许修改为绩)");

String name = sc.next();

System.out.println("请输入修改为绩：");

Double score= sc.nextDouble();

if(new Doupdate().update(name,score)){

System.out.println("成功");

}else{

System.out.println("失败");

}

}else if(a==4){

new Doselect().show();

}else if(a==0){

break;

}else {

System.out.println("输入有误！");

}

}

}

}

2.增长操做类

package cn.edu.hpu.jdbclink;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Connection;

import java.sql.Statement;

import com.mysql.jdbc.Driver;

import cn.edu.hpu.stu.*;

/**

*

* @author Programer Guo

*

*/

public class Doinsert {

public boolean addStudent(Student stu){

Connection conn = null;

//Statement对象

Statement st = null;

//结果集对象

ResultSet rs = null;

//驱动

String driver = "com.mysql.jdbc.Driver";

//链接数据库的URL

String url = "jdbc:mysql://localhost/db_jdbc?user=root&password=guo941102&useUnicode=true&characterEncoding=UTF-8";

String sql = "insert into tbl_students (name,age,myclass,score ,email) values('"+stu.getname()+"','"+stu.getage()+"','"+stu.getmyclass()+"','"+stu.getScore()+"','"+stu.getemail()+"')";

boolean flag = false;

try{

Class.forName(driver);

conn = DriverManager.getConnection(url);

st = conn.createStatement();

int i = st.executeUpdate(sql);

if(i==1){

flag = true;

}

}catch (Exception e){

e.printStackTrace();

}finally{

if(st!=null){

try{

st.close();

}catch (SQLException e){

e.printStackTrace();

}

}

if(conn !=null){

try{

conn.close();

}catch (SQLException e){

e.printStackTrace();

}

}

}

return flag;

}

public static void main(String[] args){

Doinsert doinsert = new Doinsert();

Student stu = new Student();

stu.setname("孙连伟");

stu.setage(33);

stu.setmycalss("java001");

stu.setscore(98.00);

stu.setemail("4444444@qq.com");

boolean flag= doinsert.addStudent(stu);

if(flag){

System.out.println("学生信息添加成功");

}else{

System.out.println("学生信息添加失败");

}

}

}

3.修改操做类

package cn.edu.hpu.jdbclink;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class Doupdate {

public boolean update(String name,double score){

boolean flag = false;

Connection conn = null;

Statement st = null;

String driver =null;

String url = null;

String sql = null;

try{

driver="com.mysql.jdbc.Driver";

url = "jdbc:mysql://localhost/db_jdbc?user=root&password=guo941102&useUnicode=true&characterEncoding=UTF-8";

sql = "update tbl_students set score = "+score+" where name = '"+name+"'";

Class.forName(driver);

conn = DriverManager.getConnection(url);

st = conn.createStatement();

int i = st.executeUpdate(sql);

if(i>=1){

flag=true;

}

}catch (Exception e){

e.printStackTrace();

}

return flag;

}

public static void main(String[] args){

Doupdate update = new Doupdate();

boolean flag = update.update("孙连伟",120);

if(flag){

System.out.println("更新成功");

}else{

System.out.println("更新失败");

}

}

}

4.删除操做类

package cn.edu.hpu.jdbclink;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class Dodelete {

public boolean delete(String name){

boolean flag = false;

Connection conn = null;

Statement st = null;

String driver =null;

String url = null;

String sql = null;

try{

driver="com.mysql.jdbc.Driver";

url = "jdbc:mysql://localhost/db_jdbc?user=root&password=guo941102&useUnicode=true&characterEncoding=UTF-8";

sql = "delete from tbl_students where name = '"+name+"'";

Class.forName(driver);

conn = DriverManager.getConnection(url);

st = conn.createStatement();

int i = st.executeUpdate(sql);

if(i>=1){

flag=true;

}

}catch (Exception e){

e.printStackTrace();

}

return flag;

}

public static void main(String[] args){

Dodelete delete = new Dodelete();

boolean flag = delete.delete("孙连伟");

if(flag){

System.out.println("删除成功");

}else{

System.out.println("删除失败");

}

}

}

该案例仅仅实现功能，并且是doc版运行测试，并未嵌入标记语言。jsp更多实现，正在学习中。。。