学生信息管理系统- java 连接数据库.doc
文本预览下载声明
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Scanner;
public class Student {
public static final String DRIVER=sun.jdbc.odbc.JdbcOdbcDriver;
public static final String URL=jdbc:odbc:student;
public static final String USERNAME=root;//用户名
public static final String PASSWORD=root;//密码
private static String name;//当前登录管理员的名字
private static int userid;//当前登录管理员的主键
//获得jdbc链接
public Connection connection(){
try {
Class.forName(DRIVER);
Connection con=DriverManager.getConnection(URL, USERNAME, PASSWORD);
return con;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
//管理员登陆
public boolean login() throws Exception{
Scanner sc = new Scanner(System.in);
System.out.print(输入用户名:);
String username = sc.next();
System.out.print(输入密码:);
String password = sc.next();
//查找该用户
String sql = select username,id from muser where username= + username
+ and password= + password + ;
Connection connection = connection();
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(sql);
if (rs.next()) {
name = rs.getString(1);
userid = rs.getInt(2);
return true;
}
return false;
}
//添加学生
//添加学生
public void addstudent(){
System.out.print(请依次输入学号,姓名,年龄,地址(用逗号隔开):);
Scanner scanner = new Scanner(System.in);
String[] str = scanner.next().split(,);
/**********************begin 验证学号是否重复*************************/
String sql = select * from student where 1=1 and stuno=+str[0];
try {
Connection connection = connection();
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(sql);
if(rs.next()){
System.out.println(该学号已经存在,请更换);
return;
}
} catch (SQLException ex) {
}
/**********************end 验证学号是否重复*************************/
String sql
显示全部