sqldelete.java

来自「简单的学生管理系统,使用的是SQL2005数据库」· Java 代码 · 共 41 行

package sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLDelete {
	public String methodDel (String id,String sqlDel,String sqlSel)
	{
        String str = null;
		

		
		try{
			try {
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=stu","sa","123");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(sqlSel);
			if(rs.next())
			{
				 str= rs.getString("property");
				
			}
			PreparedStatement ps = con.prepareStatement(sqlDel);
		    ps.execute();
		}catch(SQLException ex){
			ex.printStackTrace();
		}
		return str;
	}

}