newssms.zip

Java+Mysql学生成绩管理系统

package sql;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import win.LoginWin;
import win.DeleteView;


public class DeleteSql extends SqlVariable{
		
	public static boolean delStu（） throws SQLException {
		i = 0;	
		try {		
			sql = “delete from student where sid=? and sname=?“;
			pstmt = LoginWin.getConnection（）.prepareStatement（sql）;
			pstmt.setInt（1 Integer.parseInt（DeleteView.getT1（）））;
			pstmt.setString（2 DeleteView.getT2（））;
			i = pstmt.executeUpdate（）;
			}catch（SQLException e）
			{
				e.printStackTrace（）;
			}
		sql = null;
		pstmt.close（）;
		if（i !=0 ） {
			return true;
		}else {
			return false;
		}					
	}
	
	public static boolean delTea（） throws SQLException {
		i = 0;
		try {		
			sql = “delete from teacher where

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2020-06-06 00:22  newssms\
     文件         491  2020-06-05 16:32  newssms\.classpath
     文件         383  2020-05-29 23:54  newssms\.project
     目录           0  2020-06-06 00:21  newssms\.settings\
     文件         598  2020-05-29 23:54  newssms\.settings\org.eclipse.jdt.core.prefs
     文件          53  2020-06-06 00:23  newssms\README.txt
     目录           0  2020-06-06 00:21  newssms\bin\
     目录           0  2020-06-06 00:21  newssms\bin\sql\
     文件        2411  2020-06-06 00:09  newssms\bin\sql\DeleteSql.class
     文件        2607  2020-06-06 00:10  newssms\bin\sql\InsertSql.class
     文件        2459  2020-06-06 00:13  newssms\bin\sql\ProcedureSql.class
     文件        4684  2020-06-06 00:05  newssms\bin\sql\SelectAndViewSql.class
     文件         907  2020-06-06 00:11  newssms\bin\sql\SqlVariable.class
     文件        2692  2020-06-06 00:15  newssms\bin\sql\UpdateSql.class
     目录           0  2020-06-06 00:21  newssms\bin\win\
     文件        1312  2020-06-05 22:42  newssms\bin\win\DeleteView$1.class
     文件        1312  2020-06-05 22:42  newssms\bin\win\DeleteView$2.class
     文件        1314  2020-06-05 22:42  newssms\bin\win\DeleteView$3.class
     文件        1312  2020-06-05 22:42  newssms\bin\win\DeleteView$4.class
     文件        1308  2020-06-05 22:42  newssms\bin\win\DeleteView$5.class
     文件        5400  2020-06-05 22:42  newssms\bin\win\DeleteView.class
     文件        1608  2020-06-05 22:44  newssms\bin\win\InsertView$1.class
     文件        1048  2020-06-05 22:44  newssms\bin\win\InsertView$10.class
     文件        1206  2020-06-05 22:44  newssms\bin\win\InsertView$2.class
     文件        1412  2020-06-05 22:44  newssms\bin\win\InsertView$3.class
     文件        1050  2020-06-05 22:44  newssms\bin\win\InsertView$4.class
     文件        1414  2020-06-05 22:44  newssms\bin\win\InsertView$5.class
     文件        1049  2020-06-05 22:44  newssms\bin\win\InsertView$6.class
     文件        1608  2020-06-05 22:44  newssms\bin\win\InsertView$7.class
     文件        1204  2020-06-05 22:44  newssms\bin\win\InsertView$8.class
     文件        1507  2020-06-05 22:44  newssms\bin\win\InsertView$9.class
............此处省略46个文件信息