sqlamendpassword.java

简单的学生管理系统,使用的是SQL2005数据库

package sql;

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

public class SQLAmendPassword {
	public boolean methodadmin (String newpassword,String id,String password){

		boolean booleanfan = false;
		

		
		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");
			PreparedStatement ps = con.prepareStatement("update users set password=? where id='"+id+"'and password='"+password+"'");
		    ps.setString(1, newpassword);
		    ps.execute();
		    booleanfan = true;
		}catch(SQLException ex){
			ex.printStackTrace();
			booleanfan = false;
		}
		return booleanfan;
		
	}
	//public String methodname(){
		
	//}

}